Senior Data Engineer (Snowflake/ETL/SQL)

Location: Houston, TX

Work Setting: Hybrid (3 days onsite)

Position Overview

We are seeking a highly experienced Senior Data Engineer with strong expertise in SQL, Data Warehousing, ETL design, and Snowflake. The ideal candidate will have 10 years of hands-on experience in enterprise data environments, building and optimizing data pipelines, and supporting large-scale data platforms. Strong analytical, problem-solving, and communication skills are required, along with the ability to work in fast-paced business and technical environments.

Key Responsibilities

• Work extensively with Snowflake to design schemas, optimize queries, and implement data-sharing and security best practices.
• Design, develop, and optimize SQL queries, stored procedures, and scripts for complex data transformations and reporting needs.
• Architect and implement scalable Data Warehouse solutions that support analytics, BI, and reporting platforms.
• Build, manage, and automate ETL pipelines to extract, transform, and load data from diverse sources into enterprise data systems.
• Leverage Python for automation, data wrangling, and integration tasks across projects.
• Collaborate with business analysts, data scientists, and stakeholders to translate requirements into robust technical solutions.
• Monitor, troubleshoot, and improve the performance and scalability of existing data solutions.
• Follow data governance, quality, and security standards to ensure compliance and accuracy.

Required Skills & Experience

• Snowflake (4 years, intermediate to advanced): Involvement in at least 2 3 end-to-end Snowflake implementations/projects, with experience in performance tuning, data sharing, and role-based access.
• Advanced SQL (10 years): Proven expertise with query optimization, performance tuning, and complex SQL development.
• Data Warehousing (10 years): Strong understanding of dimensional modeling, star/snowflake schemas, and enterprise DW design.
• ETL Development: Hands-on experience with ETL design, development, and orchestration tools (Informatica, Talend, ADF, or similar).
• Python (2 3 years, intermediate): Proficiency in scripting for automation, data manipulation, and API integration.
• Ability to work independently and mentor junior team members.
• Excellent communication and collaboration skills.