PURIS · 10 hours ago
Data Warehouse Engineer
The Woodlands, TX
Full-time
Onsite
Senior LevelPURIS is the largest independent trenchless rehabilitation provider in North America, focusing on sustainable resource management for water, wastewater, and stormwater markets. They are seeking a highly experienced Data Warehouse Engineer to design and maintain data warehouse solutions, ensuring high-performance data platforms for business reporting and analytics while mentoring engineering teams and driving best practices.
ConstructionEnvironmental ConsultingEnvironmental EngineeringIndustrialInfrastructure
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
Qualification
Required
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
Preferred
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
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
Company
PURIS
PURIS provides end-to-end water infrastructure renewal solutions, specializing in environmentally sustainable trenchless pipeline rehabilitation.
Founded in 1984
1001-5000 employees
H1B Sponsorship
PURIS has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2022 (1)
Funding
Current Stage
Late StageTotal Funding
unknown2018-12-27Acquired
2009-06-06Series Unknown
Leadership Team
Michael Fegan
Chief Executive Officer
Recent News
EIN Presswire
2025-08-18
Company data provided by crunchbase