Analytics Engineer
First seen by Alion on Aug 12, 2026.
Role Overview :
We are looking for an experienced DBT & Snowflake Engineer / Analytics Engineer with strong hands-on expertise in dbt, Snowflake, advanced SQL, and data modeling. The candidate will be responsible for designing, developing, and maintaining scalable data transformation pipelines and analytical data models. You will work closely with Data Engineering, Data Architecture, BI, QA, and Product teams to deliver reliable, high-performance data solutions for enterprise reporting and analytics.
Key Responsibilities :
- Develop and maintain dbt models on Snowflake.
- Design scalable staging, intermediate, and data mart models.
- Develop complex and optimized SQL queries in Snowflake.
- Implement incremental models, snapshots, macros, seeds, sources, and dbt tests.
- Design dimensional models including fact and dimension tables.
- Optimize Snowflake queries, warehouses, and data models for performance and cost.
- Implement data quality, reconciliation, and validation frameworks.
- Maintain data lineage, documentation, dependencies, and data dictionaries.
- Troubleshoot data discrepancies across source systems, Snowflake, dbt, and reporting layers.
- Define and implement effective ETL/ELT strategies with Data Engineers and Architects.
- Support integration of Snowflake data models with Power BI and other BI platforms.
- Implement dbt CI/CD workflows using Git/GitHub/Azure DevOps.
- Participate in code reviews and follow SQL, dbt, Snowflake, and data engineering best practices.
- Monitor production transformations and resolve data pipeline and data-quality issues.
- Create and maintain technical documentation and runbooks.
Mandatory Technical Skills :
DBT :
- Strong hands-on experience with dbt Core or dbt Cloud.
- Experience with models, sources, tests, snapshots, macros, seeds, and incremental processing.
- Good understanding of dbt project structure, dependencies, exposures, and documentation.
- Experience with dbt CI/CD and Git-based development workflows.
Snowflake :
- Strong hands-on experience with Snowflake.
- Advanced SQL development and query optimization.
- Understanding of Snowflake architecture and compute/storage separation.
- Experience with virtual warehouses, databases, schemas, stages, views, tables, and secure views.
- Experience with Snowflake performance and cost optimization.
- Knowledge of Time Travel, Zero-Copy Cloning, Streams/Tasks, and Snowpipe is preferred.
- Experience designing analytical data models in Snowflake.
Data Engineering & SQL :
- Strong SQL skills with experience handling complex transformations and large datasets.
- Strong understanding of ETL/ELT architecture.
- Experience with dimensional modeling, star schema, and data marts.
- Understanding of data quality, validation, reconciliation, and data governance.
Good-to-Have Skills :
- Power BI, Python, Azure Data Lake, SAP, GitHub / Azure DevOps, CI/CD pipelines, Enterprise Data Warehouse / Datamart implementations, Cloud data platform performance and cost optimization, Agile/Scrum experience.
Education :
- Bachelor's or Master's degree in Computer Science, IT, Engineering, Data Science, or a related field.
Skills
Data Engineering, Snowflake DB, Data Build Tool, SQL, ETL, Dimensional Modeling, Data Management, Analytics