Senior Data Engineer

Senior Data EngineerExperience Required: 10+ Years Location: RichardsonKey ResponsibilitiesDesign, 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, warehouses sizing) for performance and cost efficiency.Knowledge on data models (dimensional/star schema, Data Vault, or 3NF) and contribute to building a semantic layer for consistent, governed reporting across BI tools.Collaborate with data analysts, BI developers, and business stakeholders to translate requirements into reliable, well-documented 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/partitioning strategies.Document data flows, transformation logic, and semantic layer definitions for maintainability and knowledge transfer.Mentor junior data engineers and enforce engineering best practices and coding standards.Required Skills & Qualifications10+ years of experience in Data Engineering, ETL/ELT development, or Data Warehousing.Strong hands-on expertise with Snowflake (architecture, performance tuning, security, cost optimization).Proven experience with DBT Cloud (models, macros, tests, jobs, snapshots, documentation, CI/CD integration).Experience with SnapLogic or comparable ETL/integration tools (Informatica, Talend, Matillion, Fivetran, Azure Data Factory, etc.).Advanced/ Complex SQL skills — window functions, CTEs, query optimization, performance tuning.Strong understanding of data modeling concepts (dimensional modeling, Data Vault, normalization) and experience building/maintaining a semantic layer.Solid grasp of ELT/ETL design patterns, data pipeline orchestration (Airflow, dbt Cloud jobs, or similar).Experience with cloud platforms (AWS/Azure/GCP) and cloud-native data architecture.Proficiency in scripting/programming (Python preferred) for automation and data processing.Familiarity with version control (Git) and CI/CD practices for data engineering workflows.Strong analytical, problem-solving, and communication skills; ability to work with cross-functional teams.Preferred / Good-to-Have SkillsExperience with BI/reporting tools (Tableau, Power BI, Looker) and their integration with a semantic layer.Knowledge of data governance, data cataloging, and metadata management tools.Exposure to real-time/streaming data (Kafka, Snowpipe Streaming).Snowflake certification (SnowPro Core/Advanced) is a plus.Experience in Agile/Scrum delivery environments.EducationBachelor's or Master's degree in Computer Science, Information Systems, Engineering, or a related field (or equivalent practical experience).