Database/ETL Developer

Our client, a leading HVAC, building automation, and intelligent climate solutions company, is looking to hire a Database/ETL Developer in Beverly, MA (Onsite).

Duration: 12 Months plus

Pay Rate Range: $65-$75/hr on W2, depending on experience

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.
  
  
  #RTA
  #LI-SK1
   

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.