Database/ETL Developer

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 looking to hire a Database/ETL Developer in Beverly, MA (Onsite).

Pay Rate Range: $70-$79/hr on W2, depending on experience

Duration: 12 Months plus

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 conceptual, logical, and physical data models using Dimensional/Star Schema, Data Vault, or 3NF methodologies.

• Develop, deploy, and orchestrate scalable ETL/ELT pipelines using tools such as Azure Data Factory and SSIS.

• Integrate data from multiple internal and external sources and deliver clean, reliable datasets.

• Develop and maintain enterprise Data Warehouses and Data Marts for various business needs.

• 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 and ETL processes for performance and reliability.

• Write complex SQL queries, stored procedures, and perform database performance tuning.

• Support and enhance existing data warehouses, reports, system integrations, SSIS packages, and data tools.

• Collaborate with Program Managers, Solutions Engineers, business users, consultants, and other stakeholders to define requirements and deliver data solutions.

• Participate throughout the project lifecycle, including requirements gathering, prototyping, development, testing, deployment, troubleshooting, and support.

• Leverage AI/ML tools and LLM APIs to improve data pipelines, automate data cleansing/transformation, and enhance predictive data modeling capabilities.

• Work within the Azure cloud environment to deploy and manage enterprise data solutions.

• Proactively identify issues, improve processes, and apply creative problem-solving and rapid prototyping techniques.

Required Qualifications:

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.

• 5+ years of experience in Data Engineering, Data Development, Database Development, or a similar role.

• Strong experience with relational and dimensional data modeling, including Fact and Dimension tables.

• Advanced SQL skills, including complex queries, stored procedures, and performance tuning.

• Hands-on experience with Azure Data Factory and/or SSIS.

• Strong experience developing Power BI dashboards and paginated reports using Power BI Report Builder.

• Experience with modern cloud data warehouses such as Snowflake, BigQuery, or Redshift, or traditional platforms such as SQL Server.

• Experience with Azure cloud administration, including deploying and managing enterprise solutions.

• Experience building and maintaining ETL/ELT pipelines and data integrations.

• Strong troubleshooting and debugging skills with the ability to quickly identify and resolve data pipeline and database issues.

• Experience leveraging AI/ML tools or LLM APIs for data engineering, data cleansing, transformation, or predictive modeling is preferred.

• Strong communication and collaboration skills with the ability to work effectively with technical and business stakeholders.

For workers in the United States, PrideGlobal and it's affiliates offers eligible employee’s comprehensive healthcare coverage (medical, dental, and vision plans), supplemental coverage (accident insurance, critical illness insurance and hospital indemnity), 401(k)-retirement savings, life & disability insurance, an employee assistance program, legal support, pet insurance and employee discounts with preferred vendors.

Equal Employment Opportunity

PrideGlobal and it's affiliates are an equal opportunity employer. We do not discriminate on the basis of the race, religious creed, color, national origin, ancestry, physical disability, mental disability, reproductive health decision making, medical condition, genetic information, marital status, sex, gender, gender identity, gender expression, age, sexual orientation, veteran or military status, or any other characteristic protected by applicable federal, state, or local law.

Fair Chance Employment

PrideGlobal and it's affiliates are a Fair Chance employer. We consider all qualified applicants, including those with criminal histories, in a manner consistent with applicable state and local Fair Chance laws and ordinances, including, the California Fair Chance Act and all applicable local Fair Chance ordinances.

Accommodations

We are committed to providing reasonable accommodations to applicants and employees with disabilities. If you require a reasonable accommodation to participate in the application or interview process, or to perform the essential functions of this role, please contact us.

Only applicable for San Francisco Candidates: Under the San Francisco Lactation in the Workplace Ordinance, we will provide written notice of lactation accommodation rights, and this notice will automatically be given upon hiring, any inquiry of parental leave or lactation accommodation.

Only applicable for Kentucky positions: For this type of employment, state law requires a criminal record check as a condition of employment. This applies to direct care staff (Examples: RN, LPN, Nurse Aides, Therapists) referred to Kentucky nursing facilities, assisted living communities, or long-term care facilities, in accordance with KRS 216.793.