Senior Data Engineer - SME Level Experience: 10+ Years Location: Richardson, TX - Locals Only Interview: 1st Round Video, 2nd Round F2F

*Job Title: Senior Data Engineer - SME Level*
*Experience: 10+ Years*
*Location: Richardson, TX - Locals Only*
*Interview: 1st Round Video, 2nd Round F2F*

*Key Responsibilities:*
- Design, build, and optimize scalable data pipelines and ETL/ELT workflows to ingest, transform, and load data from multiple source systems into Snowflake.
- Develop, maintain, and enhance data transformation logic using DBT Cloud following best practices (modularity, testing, documentation, CI/CD).
- Build and manage integrations using SnapLogic or equivalent ETL/iPaaS tools (Informatica, Talend, Matillion, Fivetran, etc.) for batch and near real-time data movement.
- Write and optimize complex SQL queries, stored procedures, and Snowflake-specific features (streams, tasks, materialized views, clustering, warehouse sizing).
- Knowledge on data models (dimensional/star schema, Data Vault, or 3NF) and contribute to building a semantic layer for consistent, governed reporting.
- Collaborate with data analysts, BI developers, and business stakeholders to translate requirements into reliable data solutions.
- Implement data quality checks, validation frameworks, and monitoring/alerting for pipeline reliability.
- Manage version control, CI/CD deployment pipelines for DBT models and ETL jobs (Git, GitHub Actions / Azure DevOps / Jenkins).
- Optimize Snowflake performance and cost through query tuning, warehouse right-sizing, and efficient storage strategies.
- Document data flows, transformation logic, and semantic layer definitions.
- Mentor junior data engineers and enforce engineering best practices.

*Required Skills:*
- 10+ years in Data Engineering, ETL/ELT, Data Warehousing - *Need SME Level*
- Strong hands-on expertise with Snowflake
- Proven experience with DBT Cloud
- Experience with SnapLogic or comparable tools
- Advanced Complex SQL
- Strong understanding of data modeling and semantic layer
- ELT/ETL design patterns, pipeline orchestration
- Cloud Platforms (AWS/Azure/Google Cloud Platform)
- Python scripting
- Git and CI/CD practices

*Good to Have:*
- Tableau, Power BI, Looker
- Data governance, cataloging, metadata management
- Kafka, Snowpipe Streaming
- Snowflake certification
- Agile/Scrum