Its fun to work in a company where people truly BELIEVE in what they are doing!
Were committed to bringing passion and customer focus to the business.
POSITION SUMMARY:
The Senior Data Engineer will work onsite at our Corporate Headquarters in Sharonville OH. The Senior Data Engineer is responsible for the design development and operation of DuBois Chemicals data pipelines to support enterprise analytics reporting and AI initiatives. This role plays a critical part in transforming transactional and unstructured data into trusted analyticsready datasets that enable informed decisionmaking across Sales Manufacturing and Finance.
This is a handson senior individual contributor role requiring deep technical expertise strong collaboration skills and the ability to operate in a fastpaced environment. The Senior Data Engineer partners closely with analytics BI and business stakeholders to ensure data assets are scalable governed reliable and aligned to business needs.
KEY RESPONSIBILITIES:
Data Engineering & Analytics Enablement
Design and implement wellstructured dimensional data models (fact and dimension tables; star schemas) from unstructured and transactional data with an initial focus on Dynamics 365 ERP and CRM systems.
Translate business requirements into governed reusable data models by moving business logic out of dashboards and into the data layer.
Deliver analyticsready datasets consumed by Power BI and downstream analytics and AI use cases.
Establish standardized metrics definitions and grains to ensure consistency accuracy and trust across enterprise reporting.
Design build and operate reliable ingestion and transformation pipelines across multiple data sources.
Translate existing Alteryx workflows into reusable performant data transformations.
Integrate data pipeline with Microsoft Fabric and Azure services as appropriate including Azure Data Factory Azure Data Lake Storage and Event Hubs.
Data Quality Metadata & Reliability
Enrich datasets with technical and business metadata including data definitions ownership and lineage.
Implement data quality monitoring and controls including freshness duplicate detection schema drift and anomaly detection.
Improve pipeline observability monitoring and operational reliability to support productiongrade data workloads.
Collaboration & Technical Leadership
Partner closely with analytics engineers BI developers and business stakeholders to deliver trusted data solutions.
Contribute to shared standards patterns and best practices for data engineering and analytics enablement.
Provide technical leadership and mentorship appropriate for a senior handson engineering role without direct people management responsibilities.
MINIMUM QUALIFICATIONS:
3-5 years of technical hands-on experience as a Data Engineer working with both transactional and analytical data. Deep understanding of dimensional data modeling.
Demonstrated experience transforming ERP and CRM data into analyticsready datasets.
Handson experience with modern cloudbased data platforms and data pipeline development: ADF dbt snowflake.
Strong SQL and Python.
Ability to manage multiple priorities meet deadlines and collaborate effectively with technical and nontechnical stakeholders.
Strong written and verbal communication skills.
Candidates will ideally live within a reasonable daily commute of Sharonville OH or be willing to relocate at own expense
PREFERRED QUALIFICATIONS:
Experience with Microsoft Dataverse OneLake
Experience developing analytics solutions for Power BI.
Familiarity with building custom agents using Copilot Studio or Azure AI Foundry.
Exposure to Snowflake Cortex or similar AIenabled data platform capabilities.
EDUCATION QUALIFICATIONS:
Bachelors degree in Computer Science Information Technology Engineering or a related field or equivalent practical experience.
DuBois provides equal employment opportunities to all employees and applicants for employment without regard to race color ancestry national origin gender sexual orientation marital status religion age disability gender identity gender expression genetic information service in the military veteran status or any other protected status in accordance with applicable federal state and/or local law and/or regulation.
Required Experience:
Senior IC