Azure Data Engineer — Scalable Analytics & ELT Pipelines

R.S. Hughes Co, Inc; Carol Stream (IL); On-site; USD 106,000 - 130,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Life insurance

401(k) plan

ESOP

Job summary

R.S. Hughes Co, Inc. is seeking a Senior Data Engineer to support and evolve our enterprise analytics platform. You will design, build, and maintain scalable data pipelines and analytics-ready data models powering reporting and decision-making across the organization.

The ideal candidate brings strong experience in Azure-based data engineering, dimensional modeling, and enterprise analytics enablement, with a focus on data quality, performance, and maintainability.

Qualifications

• 3+ years of experience in Data Engineering or Analytics Engineering roles.
• Strong hands-on experience with Azure Synapse Analytics and Azure SQL Database (or closely related technologies).
• Proven experience designing and orchestrating ELT/ETL pipelines.
• Experience integrating SaaS platforms using REST APIs.
• Advanced proficiency in SQL, including complex transformations and stored procedures.
• Experience using Python and/or PySpark for data extraction and transformation.
• Experience designing and maintaining incremental data processing patterns to efficiently ingest and transform data at scale.
• Deep understanding of medallion architecture principles.
• Strong applied knowledge of dimensional modeling (Kimball).
• Demonstrated ability to design performant star schemas for analytical workloads.
• Comfort performing light DBA responsibilities in Azure SQL Database, including: monitoring storage usage, compute utilization, and performance, cost optimization, and deployments.

Responsibilities

• Design, build, and maintain scalable ELT/ETL pipelines using Azure Synapse Analytics, Azure Logic Apps, and related Azure services.
• Ingest data from diverse sources including databases, flat files, REST and Microsoft Graph APIs.
• Develop and maintain API integrations using Python and/or PySpark notebooks.
• Own onboarding of new data sources from extraction to production-ready modeling.
• Implement data transformations using SQL stored procedures in a medallion architecture.
• Apply Kimball dimensional modeling to deliver clean star schemas.
• Validate source data and implement data quality checks throughout pipelines.
• Deliver semantic-ready datasets for enterprise reporting and analytics enablement.
• Collaborate with BI developers, analysts, and stakeholders to translate analytical requirements and support Power BI star schemas.

Skills

Azure Synapse Analytics

Azure SQL Database

SQL

Python

PySpark

ELT/ETL pipelines

Dimensional modeling (Kimball)

Star schemas

Medallion architecture

REST APIs

Data quality

Power BI

Data engineering

Education

Bachelor's degree in Computer Science

Bachelor's degree in Computer Engineering

Tools

Azure Synapse Analytics

Azure SQL Database

Power BI

REST API integrations

Python

PySpark

Job description

R.S. Hughes Co, Inc. is seeking a Senior Data Engineer to support and evolve our enterprise analytics platform. You will design, build, and maintain scalable data pipelines and analytics-ready data models powering reporting and decision-making across the organization.

The ideal candidate brings strong experience in Azure-based data engineering, dimensional modeling, and enterprise analytics enablement, with a focus on data quality, performance, and maintainability.