PURIS · 4 hours ago
Data Warehouse Engineer
The Woodlands, TX, US
Full-time
Onsite
Senior LevelPURIS is the largest independent trenchless rehabilitation provider in North America, dedicated to sustainable resource management. They are seeking a highly experienced Data Warehouse Engineer to design, build, and maintain sophisticated data warehouse and data mart solutions, ensuring high-performance data platforms for business reporting and analytics.
ConstructionEnvironmental ConsultingEnvironmental EngineeringIndustrialInfrastructure
Responsibilities
Lead the design and technical architecture of enterprise data warehouse solutions, data marts, and analytical data structures optimized for high-performance querying with SQL
Create and maintain logical and physical data models (star schemas, snowflake schemas) to ensure consistency, flexibility, and scalability of data structures used for analytics
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
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
Identify performance bottlenecks and design optimized solutions for storage, processing, and retrieval to support reporting and analytics at scale
Work closely with business stakeholders, analytics teams, BI developers, and IT leaders to gather requirements and translate business needs into scalable data architecture solutions
Establish standards and best practices for data quality, data definitions, security, and documentation; implement mechanisms to monitor and maintain data reliability
Evaluate and integrate modern cloud data warehouse solutions (e.g., Snowflake, BigQuery, Redshift) and tools as part of strategic data platform evolution
Coach and mentor data engineers and analysts in SQL best practices, data modeling principles, and architectural standards
Qualification
Required
Deep expertise in SQL and enterprise data warehousing
Strong technical leadership in architecting scalable, secure, and high-performance data platforms
Ability to bridge business requirements with technical implementation
Mentor engineering teams and drive best practices across data architecture and ETL/ELT processes
Lead the design and technical architecture of enterprise data warehouse solutions, data marts, and analytical data structures optimized for high-performance querying with SQL
Create and maintain logical and physical data models (star schemas, snowflake schemas)
Write, optimize, and maintain complex SQL for data ingestion, transformation, aggregation, and performance tuning across large datasets
Architect, implement, and oversee robust extract-transform-load (ETL/ELT) processes
Identify performance bottlenecks and design optimized solutions for storage, processing, and retrieval
Work closely with business stakeholders, analytics teams, BI developers, and IT leaders to gather requirements
Establish standards and best practices for data quality, data definitions, security, and documentation
Evaluate and integrate modern cloud data warehouse solutions (e.g., Snowflake, BigQuery, Redshift)
Coach and mentor data engineers and analysts in SQL best practices, data modeling principles, and architectural standards
Advanced proficiency writing and optimizing large-scale SQL queries, stored procedures, and performance-tuned database solutions
Extensive experience building enterprise data warehouses, data lakes, and data marts for analytics and reporting
In-depth understanding of dimensional modeling, entity-relationship design, and schema evolution
Hands-on experience with ETL frameworks (e.g., SSIS, Informatica, Talend) or ELT patterns in cloud environments
Ability to design for high performance, fault tolerance, partitioning strategies, and efficient data retrieval
Experience with cloud platforms (AWS, GCP, Azure) and modern data warehouse technologies
Familiarity with scripting languages (Python, Shell) for automation and data processing tasks
Strong ability to analyze complex problems, define root causes, and propose scalable solutions
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