Azure Data Engineer - ETL, Data Warehouse & Power BI

Russell Tobin; Beverly (MA); On-site; USD 96,000 - 109,000; Full time

Job summary

Our client, a leading HVAC, building automation, and intelligent climate solutions company, is hiring a Database/ETL Developer in Beverly, MA (Onsite). The role focuses on designing and maintaining databases, data warehouses, and ETL pipelines in Azure, and delivering Power BI dashboards.

Responsibilities include building scalable ETL/ELT processes with Azure Data Factory and SSIS, optimizing SQL performance, and collaborating with stakeholders to deliver reliable data solutions.

Qualifications

• Bachelor's degree in CS/IT/Engineering or related field.
• 5+ years in Data Engineering or similar roles.
• Strong relational and dimensional data modeling.
• Advanced SQL with performance tuning.
• Experience with Azure Data Factory/SSIS.
• Power BI dashboards and Report Builder experience.
• Experience with Snowflake/BigQuery/Redshift or SQL Server.
• Azure cloud administration experience.
• ETL/ELT pipelines and data integrations.
• AI/ML tools or LLM APIs preferred.
• Strong communication and collaboration with stakeholders.

Responsibilities

• Design, develop, test, implement, and maintain databases, data warehouses, data marts, and related systems.
• Gather and analyze data requirements before database and ETL development.
• Design and optimize data models using Dimensional/Star Schema, Data Vault, or 3NF.
• Develop, deploy, and orchestrate scalable ETL/ELT pipelines using Azure Data Factory and SSIS.
• Integrate data from multiple sources and deliver clean, reliable datasets.
• Develop and maintain enterprise Data Warehouses and Data Marts.
• Create and maintain interactive Power BI dashboards and paginated reports using Power BI Report Builder.
• Monitor daily data loads, troubleshoot pipeline failures, and optimize SQL queries.
• Write complex SQL queries and stored procedures and perform performance tuning.
• Support and enhance existing data warehouses, reports, system integrations, SSIS packages, and data tools.
• Collaborate with Program Managers, Solutions Engineers, and stakeholders to define requirements.
• Participate in requirements, prototyping, development, testing, deployment, and support.
• Leverage AI/ML tools and LLM APIs to improve data pipelines and modeling.
• Work within the Azure cloud environment to deploy and manage enterprise data solutions.
• Identify issues and apply rapid prototyping to improve processes.

Skills

Data engineering experience

SQL proficiency

Dimensional modeling

Power BI development

ETL/ELT pipelines

Azure Data Factory/SSIS

Azure cloud administration

Data warehousing concepts

AI/ML tools

Stakeholder collaboration

Education

Bachelor's degree in CS/IT/Engineering or related field

Tools

Azure Data Factory

SSIS

Power BI

Power BI Report Builder

Snowflake

BigQuery

Redshift

SQL Server

Job description

Our client, a leading HVAC, building automation, and intelligent climate solutions company, is hiring a Database/ETL Developer in Beverly, MA (Onsite). The role focuses on designing and maintaining databases, data warehouses, and ETL pipelines in Azure, and delivering Power BI dashboards.

Responsibilities include building scalable ETL/ELT processes with Azure Data Factory and SSIS, optimizing SQL performance, and collaborating with stakeholders to deliver reliable data solutions.