Senior Data Engineer - Azure Data Pipelines & Analytics

R.S. Hughes Co, Inc; Marietta (GA); On-site; USD 110,000 - 118,000; Full time

Benefits offered by this job

Life insurance

Short term disability

401(k)

Job summary

R.S. Hughes Co, Inc. seeks a Senior Data Engineer to design, build, and maintain scalable data pipelines and analytics-ready data models powering reporting and decision-making across the organization.

The role emphasizes Azure-based data engineering, dimensional modeling, and enterprise analytics enablement with a focus on data quality, performance, and maintainability. Collaboration with BI teams and stakeholders is essential.

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; supporting schema changes, deployments, and operational stability.

Responsibilities

• Design, build, and maintain 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 aligned to a medallion architecture (Bronze, Silver, Gold).
• Apply Kimball dimensional modeling techniques to deliver clean star schemas.
• Ensure data models are optimized for Power BI report developers and analysts.
• Validate source data and implement data quality checks throughout the pipeline lifecycle.
• Maintain documentation for pipelines, models, and business logic for enterprise reuse.
• Deliver curated semantic-ready datasets for enterprise reporting; collaborate with BI teams to meet analytical requirements; support Power BI star schemas.

Skills

Azure Synapse Analytics

Azure SQL Database

ELT/ETL pipelines

REST APIs

SQL

Python

PySpark

Dimensional modeling

Power BI

Data quality

Data governance

Medallion architecture

Education

Bachelor's degree in Computer Science

Bachelor's degree in Computer Engineering

Tools

Azure Synapse Analytics

Azure SQL Database

Power BI

Python

PySpark

Job description

R.S. Hughes Co, Inc. seeks a Senior Data Engineer to design, build, and maintain scalable data pipelines and analytics-ready data models powering reporting and decision-making across the organization.

The role emphasizes Azure-based data engineering, dimensional modeling, and enterprise analytics enablement with a focus on data quality, performance, and maintainability. Collaboration with BI teams and stakeholders is essential.