Senior Data Engineer

Imagine a company that recognizes excellence in not only the products it sells, but also in its employees. R.S. Hughes Company, Inc. is that company. We hold ourselves to the highest standards of quality and professionalism - and we treat our employees like the valuable assets they are.

Founded in 1954, R.S. Hughes Co., Inc. is a dynamic, North American distributor of industrial supplies. With 49 warehouse sites in the United States and Mexico, we maintain an extensive inventory of adhesives, abrasives, electrical, static control, tapes, labeling and safety products. We are proud to represent products from leading manufacturing companies including 3M, Henkel Loctite, Momentive, Brady, Kimberly Clark, Ansell Edmont, and many others. We specialize in sales and service solutions to manufacturing companies in both OEM and MRO applications.

In addition to competitive salaries and benefits, we offer an environment that asks you to make a difference. We value hard work and common sense, and we consistently reward those that exemplify these traits. If you're looking for a great team to grow with and if you are willing to embrace the challenges of being expected to be the best, we welcome you to come join the R.S. Hughes Company, Inc. team!

Job Summary

R.S. Hughes is seeking a Senior Data Engineer to support and evolve our enterprise analytics platform. This role is responsible for designing, building, and maintaining scalable data pipelines and analytics-ready data models that power 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 mindset oriented toward data quality, performance, and long-term maintainability.

Core Responsibilities

• Data Ingestion & Integration
• Design, develop, and maintain robust ELT/ETL pipelines using Azure Synapse Analytics, Azure Logic Apps, and related Azure services
• Ingest data from diverse source systems including databases, flat files, and REST and Microsoft Graph APIs
• Develop and maintain custom API integrations using Python and/or PySpark notebooks
• Own end-to-end onboarding of new data sources, from initial extraction through production-ready modeling

Data Transformation & Modeling

• Implement data transformations using SQL stored procedures aligned to a medallion architecture (Bronze, Silver, Gold)
• Apply Kimball dimensional modeling techniques to deliver clean, performant star schemas
• Make thoughtful design decisions around:
• Star vs. snowflake schemas
• Normalized vs. denormalized datasets
• Conformed dimensions across multiple source systems
• Ensure data models are optimized for consumption by Power BI report developers and analysts

Data Quality & Governance

• Validate source data and implement data quality checks throughout the pipeline lifecycle
• Troubleshoot and resolve data issues related to freshness, accuracy, and completeness
• Maintain clear and accurate documentation for pipelines, models, and business logic to support enterprise understanding and reuse

Analytics Enablement

• Deliver curated, semantic-ready datasets that serve as trusted sources for enterprise reporting
• Collaborate closely with BI developers, analysts, and business stakeholders to understand and translate analytical requirements
• Support and maintain existing Power BI star schemas used across the organization

Basic 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
• Managing cost awareness and optimization
• Supporting schema changes, deployments, and operational stability

Skills:

• Familiarity with data quality frameworks or validation tooling
• Experience working in large-scale, enterprise reporting environments
• Strong documentation and written communication skills
• Exposure to modern analytics governance or semantic modeling concepts
• Experience supporting enterprise analytics in Power BI
• Experience mentoring, coaching, or training others in data engineering or analytics best practices

Certifications & Licenses

• Advanced certifications in data management, Microsoft SQL Server, or Progress databases preferred.

Compensation

Our merit-based salary/bonus program offers exceptional growth opportunities. We provide a comprehensive medical, dental, life insurance, wellness benefit, short term disability plan, paid vacation, and a 401(k) retirement savings plan, and an Employee Stock Ownership Program (ESOP), where employees are eligible after 30 days of service.

Compensation for this exempt role is up to $118,000 DOE.