Develop database designs and architecture in Azure, secure data migrations, and conduct data profiling while collaborating with teams on technical designs.
- Work in an Azure data warehouse environment, which includes developing database designs and architecture, data modeling and metadata repository creation
- Work with Architects, Technical Leads and Business Teams and contributes to the development of technical designs
- Secure data migrations & transformations to/from clients, customers, and vendors
- Provides technical database consultation on application development, global infrastructure, and other database administration efforts related to specific DBMS
- Conduct data profiling, cataloging, and mapping for technical design and construction of technical data flows
- Migrate current ETL and SSIS packages to Synapse
Requirements
- 2-3+ Years of proven experience performing large data migration and transformation efforts
- Strong hands-on experience with Microsoft Azure Data & Analytics including Azure Synapse, Azure Data Factory, & Azure Data Lake Storage
- Experience in writing complex SQL queries and creating data models
- Experience or exposure to TSQL, SQL server, PL/SQL
- Experience or exposure to Informatica PowerCenter, Star Schema, Snowflake Schema
- Database performance tuning
- Data warehouse and data mart experience
- Strong knowledge of various data structures and the ability to extract data from various data sources (such as Cognos, Informatica, Hyperion, etc.)
Benefits
- Education Assistance/Student Loan Repayment - up to $2400 annually
- Remote work allowance
- Internet reimbursement
- Bench pay
- Profit share
- Healthcare reimbursement
- 401k - 4% match
- Short-Term disability
- Long-Term disability
- Life Insurance
Top Skills
Azure Data Factory
Azure Data Lake Storage
Azure Data Warehouse
Azure Synapse
Informatica Powercenter
Pl/Sql
SQL
SQL Server
Tsql
Similar Jobs
AdTech • Cloud • Digital Media • Information Technology • News + Entertainment • App development
As a Data Engineer II, you will design, build, and maintain data pipelines, collaborate with teams, and troubleshoot production issues.
Top Skills:
Amazon MwaaApache AirflowAthenaAWSDynamoDBEmrGlueInformaticaJavaLambdaPysparkPythonRedshiftS3ScalaSQLTalendTerraform
AdTech • Consumer Web • Digital Media • eCommerce • Marketing Tech
Design and optimize data pipelines for integration and analysis, ensuring data quality while collaborating with a cross-functional scrum team.
Top Skills:
Apache BeamApache KafkaSparkAWSBigQueryGCPLookerPub/SubPythonSQL
Big Data • Fintech • Information Technology • Insurance • Software
The Data Engineer II at Bestow will build data pipelines, improve data reliability, quality, and support MLOps, collaborating across teams to meet data needs.
Top Skills:
Apache AirflowApp EngineCircleCICloud FunctionsCloud RunCloud StorageDbtDockerGitGCPPulumiPythonSQLTerraformVertex Ai
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
