DataJobs.io
← Back to all jobs

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