Data Analytics Engineer

John W. Danforth Company; Dublin (OH); On-site; USD 80,000 - 110,000; Full time

Benefits offered by this job

Medical, dental, and vision coverage

401(k) Savings Plan

Employee assistance program

Job summary

John W. Danforth Company, located in Dublin, Ohio, is seeking a Data Analytics Engineer. In this pivotal role, you will design and maintain scalable data pipelines and analytics-ready datasets to enable data-driven decisions across various teams.

The ideal candidate will have 3-7+ years of experience, strong SQL skills, and familiarity with cloud platforms like AWS or Azure. A competitive salary range of $80,000-$110,000 and comprehensive benefits are offered.

Qualifications

• 3–7+ years of experience in data engineering, analytics engineering, or a related field.
• Strong SQL skills and experience with data modeling concepts.
• Experience with ETL/ELT tools and frameworks.
• Familiarity with cloud platforms such as Azure, AWS, or GCP.

Responsibilities

• Build and optimize ETL/ELT pipelines for scalable data processing.
• Integrate data from various sources ensuring accuracy and consistency.
• Develop logical and physical data models for reporting insights.
• Implement data quality checks and monitoring processes.
• Collaborate with teams to translate requirements into data solutions.

Skills

SQL

Data modeling

ETL/ELT frameworks

Cloud platforms (Azure/AWS/GCP)

Python or Spark

Problem-solving

Analytical skills

Communication skills

Education

Bachelor’s degree in Computer Science or Information Systems

Tools

ETL tools

Job description

Company Overview

John W. Danforth Company, one of the largest mechanical contractors in the Northeast, is growing! We believe our people are our greatest asset and invest in training, career development, employee engagement, and team support. We are committed to delivering industry-leading experiences for our customers across commercial and industrial HVAC, plumbing, refrigeration, advanced technology manufacturing, process piping, fabrication, mission-critical environments, and energy performance projects, backed by comprehensive service maintenance and repair.

Job Summary

As a Data Analytics Engineer at John W. Danforth Company, you will play a critical role in enabling data‑driven decision‑making across the organization. You will design, build, and maintain scalable data pipelines, data models, and analytics‑ready datasets. In this role, you will partner closely with analytics, IT, and business teams to ensure reliable, efficient, and accessible data solutions that support reporting and advanced analytics initiatives.

Essential Duties & Responsibilities

• Build, maintain, and optimize ETL/ELT pipelines to support scalable data processing and integration across systems.
• Integrate data from internal and external sources while ensuring accuracy, consistency, and availability.
• Develop and maintain logical and physical data models, including analytics‑ready data layers for reporting and insights.
• Deliver clean, reliable datasets that enable self‑service analytics and support business intelligence tools.
• Implement data quality checks, validation processes, and monitoring to ensure data integrity.
• Support data governance initiatives, including metadata management, lineage, and compliance with security and regulatory standards.
• Optimize data pipelines, queries, and storage solutions to improve performance, scalability, and cost efficiency.
• Collaborate with IT, engineering, and business stakeholders to translate requirements into scalable data solutions.
• Troubleshoot production issues, provide enhancements, and contribute to continuous improvement efforts.

Qualifications

• 3–7+ years of experience in data engineering, analytics engineering, or a related field.
• Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent experience).
• Strong SQL skills and experience with data modeling concepts and techniques.
• Experience with ETL/ELT tools and frameworks.
• Familiarity with cloud platforms such as Azure, AWS, or GCP.
• Knowledge of data warehousing concepts (e.g., dimensional modeling).
• Proficiency in programming or scripting languages such as Python, Spark, or similar.
• Strong problem‑solving, analytical, and communication skills.
• Ability to manage multiple priorities and work collaboratively across teams.

Equal Opportunity Employer

As a leading provider of mechanical and electrical construction, facilities services, and energy infrastructure, we offer employees a competitive salary and benefits package and we are always looking for individuals with the talent and skills required to contribute to our continued growth and success. Equal Opportunity Employer / Veterans / Disabled.

Geographic Disclosure

• Compensation Range: $80,000-$110,000
• Other Compensation: Bonus eligible
• Benefits: We are committed to providing employees a comprehensive benefits package which includes medical, dental, and vision coverage, along with health savings and flexible spending accounts, life insurance, disability, a 401(k) Savings Plan, and an employee assistance program.