Data warehouse engineer Jobs in USA

Job Description

Job Description

Data Warehouse Engineer

About PURIS :

PURIS operates across North America as the largest independent trenchless rehabilitation provider with 900+ employees dedicated to building lasting infrastructure with smart, sustainable resource management. The PURIS Family of Companies provides trenchless renewal solutions in the water, wastewater, and stormwater markets. Our environmentally friendly solutions work within the existing infrastructure to save time, minimize environmental impact, and cause fewer community disruptions. With an unrivaled toolbox of technologies, PURIS has the RIGHT solution for each project.

Job Summary Description :

We are seeking a highly experienced Data Warehouse Engineer with deep expertise in SQL and enterprise data warehousing to design, build, and maintain sophisticated data warehouse and data mart solutions. This role requires strong technical leadership in architecting scalable, secure, and high-performance data platforms that enable trusted business reporting and advanced analytics. The ideal candidate will bridge business requirements with technical implementation, mentor engineering teams, and drive best practices across data architecture and ETL / ELT processes.

Essential Job Accountabilities :

• Design and Develop Data Warehouse Architecture - Lead the design and technical architecture of enterprise data warehouse solutions, data marts, and analytical data structures optimized for high-performance querying with SQL.
• Data Modeling - Create and maintain logical and physical data models (star schemas, snowflake schemas) to ensure consistency, flexibility, and scalability of data structures used for analytics.
• SQL Mastery and Database Design - Write, optimize, and maintain complex SQL for data ingestion, transformation, aggregation, and performance tuning across large datasets; ensure efficient use of indexes, partitions, and query plans.
• ETL / ELT and Integration Strategy - Architect, implement, and oversee robust extract-transform-load (ETL / ELT) processes, ensuring high data quality, consistency, governance, and lineage as data flows from source systems into the warehouse and data marts.
• Performance and Scalability - Identify performance bottlenecks and design optimized solutions for storage, processing, and retrieval to support reporting and analytics at scale.
• Collaboration and Stakeholder Engagement - Work closely with business stakeholders, analytics teams, BI developers, and IT leaders to gather requirements and translate business needs into scalable data architecture solutions.
• Data Quality and Governance - Establish standards and best practices for data quality, data definitions, security, and documentation; implement mechanisms to monitor and maintain data reliability.
• Cloud and Modern Data Platforms - Evaluate and integrate modern cloud data warehouse solutions (e.g., Snowflake, BigQuery, Redshift) and tools as part of strategic data platform evolution.
• Mentorship and Leadership - Coach and mentor data engineers and analysts in SQL best practices, data modeling principles, and architectural standards.

Knowledge, Skills, and Abilities :

Preferred Qualifications :

Microsoft Data Engineer – preferred

What Success Looks Like

Benefits :

Life Insurance

Equal Opportunity Employer / Veterans / Disabled.