Senior Data Engineer with ETL and ADF_REMOTE@ON W2

Senior Data Engineer with ETL and ADF_REMOTE@ON W2

Posted 3 days ago by BURGEON IT SERVICES LLC

Negotiable
Undetermined
Remote
Remote or Hybrid in Richardson, Texas

Summary: The Senior Data Engineer role involves designing, developing, and maintaining scalable data solutions on the Azure platform. The position requires expertise in ETL/ELT pipelines and collaboration with business and analytics teams to ensure data quality and meet reporting needs. The role is primarily remote, with potential hybrid options in Richardson, Texas. Candidates should possess strong SQL skills and experience with Azure technologies.

Key Responsibilities:

  • Design and develop ETL/ELT pipelines using Azure Data Factory
  • Perform data ingestion from multiple source systems
  • Implement data transformations based on business rules
  • Collaborate with business and analytics teams to gather and finalize data requirements
  • Conduct data profiling, validation, and cleansing to ensure data quality
  • Develop and optimize T-SQL queries for performance and scalability
  • Work with Azure Synapse, Spark, and SSAS to support analytics and reporting needs
  • Troubleshoot data issues and optimize existing pipelines.

Key Skills:

  • Strong SQL / T-SQL
  • Azure Data Factory (ADF)
  • Azure Synapse Analytics
  • Apache Spark
  • SQL Server Analysis Services (SSAS)
  • Azure Fabric (Nice to Have)

Salary (Rate): undetermined

City: undetermined

Country: undetermined

Working Arrangements: remote

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Role: Senior Data Engineer

Locations (Reporting): Bellevue, WA | Tempe, AZ | Richardson, TX
Work Type: Remote
Employment Type: Contract (W2)

Required Skills

  • Strong SQL / T-SQL
  • Azure Data Factory (ADF)
  • Azure Synapse Analytics
  • Apache Spark
  • SQL Server Analysis Services (SSAS)

Nice to Have

  • Azure Fabric

Job Description:

We are seeking a Senior Data Engineer to design, develop, and maintain scalable data solutions on the Azure platform.

Responsibilities:

  • Design and develop ETL/ELT pipelines using Azure Data Factory
  • Perform data ingestion from multiple source systems
  • Implement data transformations based on business rules
  • Collaborate with business and analytics teams to gather and finalize data requirements
  • Conduct data profiling, validation, and cleansing to ensure data quality
  • Develop and optimize T-SQL queries for performance and scalability
  • Work with Azure Synapse, Spark, and SSAS to support analytics and reporting needs
  • Troubleshoot data issues and optimize existing pipelines.