Data Engineer

CBTS; Sharonville (OH); On-site; USD 110,000 - 150,000; Full time

Job summary

DuBois Chemicals seeks a Data Engineer to design, develop, and operate scalable data pipelines for analytics, reporting, and AI initiatives. You will transform transactional and unstructured data into analytics-ready datasets used by Sales, Manufacturing, and Finance.

This senior, hands-on role requires deep technical expertise and collaboration with analytics, BI, and business stakeholders to ensure data assets are scalable, governed, and reliable.

Qualifications

• 3–5 years as Data Engineer handling transactional and analytic data.
• Deep expertise in Snowflake architecture, performance, and modeling.
• Strong experience with dbt including development, testing, and deployment.
• Experience integrating data from ERP/CRM/operational systems (Dynamics 365 preferred).
• Ability to manage multiple priorities and communicate with technical and non-technical stakeholders.

Responsibilities

• Design and implement scalable dimensional data models (fact/dim tables, star schemas).
• Maintain enterprise standards for data modeling, naming, transformations, and reusable logic.
• Partner with stakeholders to define metrics, hierarchies, and master data concepts.
• Develop analytics-ready data products for Power BI and AI solutions.
• Ingest data across sources and maintain dbt transformation frameworks.
• Optimize Snowflake performance and cost; implement CI/CD for data transformations.

Skills

Dimensional data modeling

Snowflake architecture

dbt development

Data integration

Stakeholder collaboration

Data quality & lineage

Education

Bachelor’s degree in CS/IT/Engineering

Tools

Snowflake

dbt

Job description

The 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, analytics‑ready datasets that enable informed decision‑making across Sales, Manufacturing, and Finance.

This is a hands‑on, senior individual contributor role requiring deep technical expertise, strong collaboration skills, and the ability to operate in a fast‑paced environment. The 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:

• Design and implement scalable dimensional data models, including fact tables, dimension tables, star schemas, and semantic business layers.
• Continuing enterprise standards for data modeling, naming conventions, transformations, and reusable business logic.
• Partner with business stakeholders to define and govern critical business metrics, hierarchies, and master data concepts.
• Design analytics-ready data products that support Power BI, AI solutions, and self‑service analytics.

Snowflake & dbt Engineering

• Design, build, and operate reliable ingestion pipelines across multiple data sources.
• Design, develop, and maintain dbt transformation frameworks following data engineering best practices.
• Develop modular, reusable, and testable dbt models to standardize business logic across the enterprise.
• Optimize Snowflake performance, warehouse utilization, storage architecture, and cost management.
• Implement automated testing, documentation, lineage, and deployment processes within dbt.
• Establish CI/CD practices and development standards for enterprise data transformations.
• Lead migration of legacy SQL Server, Excel, and Alteryx-based processes into modern cloud‑based architectures.

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 production‑grade 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, hands‑on 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.
• Deep expertise in Snowflake architecture, performance optimization, and data modeling.
• Strong experience with dbt including model development, testing, documentation, and deployment.
• Extensive experience designing dimensional models, semantic layers, and enterprise reporting datasets.
• Experience integrating data from ERP, CRM, and operational systems, preferably Dynamics 365 Finance & Operations and Dynamics 365 CRM.
• Ability to manage multiple priorities, meet deadlines, and collaborate effectively with technical and non‑technical stakeholders.
• Strong written and verbal communication skills.

PREFERRED QUALIFICATIONS:

• Experience with Microsoft Dataverse, OneLake
• Experience developing analytics solutions for Power BI.
• Experience to Snowflake Cortex or similar AI‑enabled data platform capabilities.
• Experience implementing CI/CD pipelines and DataOps practices.
• Familiarity with building custom agents using Copilot Studio or Azure AI Foundry.

EDUCATION QUALIFICATIONS:

• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field, or equivalent practical experience.