Job Summary:
John W. Danforth Company, one of the largest mechanical contractors in the Northeast, is growing! As a Data Analytics Engineer, you will play a critical role in enabling data-driven decision-making across the organization by designing, building, and maintaining scalable data pipelines and analytics-ready datasets.
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:
Required:
โข 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.
Company:
John W. Danforth Company is a construction company that offers HVAC, plumbing, and maintenance services. Founded in 1884, the company is headquartered in Tonawanda, USA, with a team of 501-1000 employees. The company is currently Late Stage.