Data Warehouse Engineer

PURIS Corporation, LLC • The Woodlands, TX

7d

About The Position

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.

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.

Requirements

• Expert SQL Skills- Advanced proficiency writing and optimizing large-scale SQL queries, stored procedures, and performance-tuned database solutions.
• Data Warehousing Expertise- Extensive experience building enterprise data warehouses, data lakes, and data marts for analytics and reporting.
• Strong Data Modeling Background- In-depth understanding of dimensional modeling, entity-relationship design, and schema evolution.
• ETL / ELT and Integration Tools- Hands-on experience with ETL frameworks (e.g., SSIS, Informatica, Talend) or ELT patterns in cloud environments.
• Performance and Scalability Orientation- Ability to design for high performance, fault tolerance, partitioning strategies, and efficient data retrieval.
• Cloud Data Warehouse Experience- Experience with cloud platforms (AWS, GCP, Azure) and modern data warehouse technologies.
• Software and Scripting- Familiarity with scripting languages (Python, Shell) for automation and data processing tasks is a plus.
• Analytical and Problem-Solving Mindset- Strong ability to analyze complex problems, define root causes, and propose scalable solutions.
• Communication and Leadership- Excellent communication skills and ability to translate technical concepts for non-technical stakeholders.

Nice To Haves

• Bachelor’s or Master’s degree in Computer Science, Information Technology, Engineering, or related field
• Certifications in data warehousing, cloud platforms, or database technologies
• Microsoft Data Engineer – preferred
• Microsoft Data Analyst - preferred
• Experience with BI and reporting platforms (Power BI, Tableau)
• Prior leadership or architectural governance experience

Responsibilities

• 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.

Benefits

• Comprehensive and competitive benefits package that include medical/Rx, dental, vision, critical illness and accident insurance, and short-term disability.
• Several 100% company-paid benefits including
• Life Insurance
• Long-term disability
• Employee assistance program
• Bonus program
• 401(k) savings plan with company match
• Generous PTO
• 10 paid holidays
• Tuition reimbursement
• Career advancement opportunities

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level