Data Engineer
3d Design Tools
Analytics
Apache Airflow
Aws Data Warehouse
Big Data
Bigdata
Business Intelligence
CI/CD
Cloud
Cloud Data Engineering
Cloud Data Platform
Cloud Data Warehouse
Cloud Data Warehouse
Cloud Platform
Cloud Platforms
Data
Data Analysis
Data Analytics
Data Architecture
Data Build Tool
Data Engineer
Data Engineering
Data Integration
Data Integration Tools
Data Lakehouse
Data Management
Data Modeling
Data Operations
Data Pipeline
Data Pipelines
Data Platform
Data Processing
Data Transforms
Data Warehouse
Data Warehousing
Database
Databases
Databricks
DevOps
Devops Tools
Digital Marketing
Engineer
ETL
Fivetran
Google Cloud Bigquery
Informatica
Information Technology (IT)
Programming Language
Rendering Engines
Reporting and Analytics
Snowflake
Software Development
Software Engineering
Spark
SQL
Workflow Orchestration
Job Description
Join the Business Intelligence team within Divisions Maintenance Group’s Revenue Strategy and Planning organization and help build the data infrastructure that powers analytics, reporting, and better decision-making. This onsite role in Cincinnati, OH focuses on scalable pipelines, dependable data quality and governance, and delivering analytics-ready datasets to teams across the organization.
What you’ll do
- Design, build, and maintain scalable data pipelines and ETL/ELT workflows that support analytics and reporting.
- Develop and optimize data models in the warehouse for downstream BI dashboards and operational reporting.
- Implement orchestration and scheduling to keep automated data processing reliable.
- Monitor pipeline performance, troubleshoot failures, and help ensure uptime and reliability for critical data systems.
- Optimize SQL queries and data structures for performance and cost efficiency.
- Establish and enforce data quality standards using validation checks and monitoring for accuracy and consistency.
- Document data lineage, transformation logic, and schema definitions to support transparency and governance.
- Partner with stakeholders to define data contracts, naming conventions, and architectural standards.
- Build reusable frameworks and patterns that improve consistency across datasets.
- Collaborate with BI analysts and data scientists to understand requirements and deliver clean, structured datasets.
- Support the creation of dimensional models and analytics-ready tables for self-service reporting.
- Provide technical guidance to analytics team members on data usage, best practices, and troubleshooting.
- Balance platform-level engineering with responsiveness to evolving analytics needs.
- Use AI tools (for example, ChatGPT and Claude) to accelerate development, documentation, code review, and troubleshooting.
- Leverage low-code/no-code automation tools (for example, Zapier and Make, or similar) to streamline data workflows and integrations when appropriate.
- Identify opportunities to reduce manual effort through automation while maintaining data quality and governance standards.
- Build pragmatic solutions that balance technical rigor with speed and business impact.
- Perform other duties as assigned by management.
What you bring
- Bachelor’s degree in Computer Science, Data Engineering, Computer Engineering, or a related technical field.
- 3–5 years of experience in data engineering, analytics engineering, or a related role (minimum 3 years).
- Strong SQL skills, including writing complex queries, optimizing performance, and designing data models.
- Experience building and maintaining production data pipelines with modern tools such as Airflow, dbt, and/or Fivetran (or similar).
- Proficiency in Python for data transformation, automation, and pipeline development.
- Working knowledge of cloud data platforms such as Snowflake, BigQuery, Redshift, or Databricks.
- Familiarity with data modeling best practices, including dimensional modeling, normalization, and slowly changing dimensions.
- Understanding of data governance, including lineage, quality monitoring, and documentation.
- Experience with Git and CI/CD practices for data workflows.
- Comfort using AI tools to accelerate coding, problem-solving, and documentation.
- Willingness to use low-code/no-code tools when they add practical value without compromising data integrity.
- Ownership mindset with attention to detail and a focus on reliability.
- Ability to manage stress in a fast-paced environment.
- Ability to meet the in-person requirements of the team and/or business needs.
Benefits
- Health, dental and vision coverage on day 1.
- 401K match dollar-for-dollar up to 4% of salary, with immediate 100% vesting.
- Paid Primary and Secondary Caregiver leave.
- Employee Assistance Program to help with everyday challenges.
- Paid time off to volunteer.
Tools you’ll use
SQL, ETL/ELT, Airflow, dbt, Fivetran, Python, Snowflake, BigQuery, Redshift, Databricks, Git, CI/CD, ChatGPT, Claude, Zapier, Make
Similar Jobs
C