Senior Data Engineer – Azure Analytics & Data Modeling

R.S. Hughes Co, Inc; Texas; On-site; USD 90,000 - 118,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401(k) retirement plan

ESOP

Job summary

R.S. Hughes Company, Inc. is seeking a Senior Data Engineer to design, build, and maintain scalable data pipelines and analytics-ready data models that power reporting across the organization.

The role focuses on Azure-based data engineering, dimensional modeling, and enterprise analytics enablement with emphasis on data quality, performance, and maintainability. The ideal candidate will have strong experience with Azure Synapse Analytics, SQL Database, and medallion architecture, and will

Qualifications

• 3+ years of experience in Data Engineering or Analytics Engineering roles
• Strong hands-on experience with Azure Synapse Analytics and Azure SQL Database
• 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, 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 databases, flat files, REST and Microsoft Graph APIs
• Develop and maintain API integrations using Python and/or PySpark
• Own end-to-end onboarding of new data sources from extraction to production-ready models
• Implement data transformations using SQL stored procedures in a medallion architecture
• Apply Kimball dimensional modeling to deliver clean star schemas
• Design decisions around star vs. snowflake schemas and normalized vs. denormalized datasets
• Ensure data models are optimized for Power BI reporting

Skills

Azure Synapse Analytics

Azure SQL Database

ELT/ETL pipelines

REST APIs

SQL

Python

PySpark

Dimensional modeling (Kimball)

Star schema design

Data quality

Power BI

Education

Bachelor's in Computer Science

Bachelor's in Computer Engineering

Job description

R.S. Hughes Company, Inc. is seeking a Senior Data Engineer to design, build, and maintain scalable data pipelines and analytics-ready data models that power reporting across the organization.

The role focuses on Azure-based data engineering, dimensional modeling, and enterprise analytics enablement with emphasis on data quality, performance, and maintainability. The ideal candidate will have strong experience with Azure Synapse Analytics, SQL Database, and medallion architecture, and will