Overview We are looking for a hands-on Data Analytics Engineer with strong experience in DBT, Snowflake, and dimensional data modeling to help build and maintain the analytical foundation that supports enterprise reporting and analytics.
Key Responsibilities:
- Design, develop, and maintain star-schema data models, including fact and dimension tables.
- Build and support DBT models and testing frameworks to deliver trusted, analytics-ready datasets.
- Develop, optimize, and troubleshoot data structures and SQL workloads in Snowflake.
- Apply data modeling best practices and make informed decisions around dimensional design, normalization, and denormalization.
- Partner closely with Data Engineers, BI Developers, Product Owners, and business stakeholders to translate requirements into scalable analytical solutions.
- Participate in design discussions, knowledge sharing, and peer reviews to promote consistent modeling standards across the team.
- Support data delivery from ingestion through transformation and into the semantic layer for reporting and analytics.
- Document modeling decisions and collaborate with team members to continuously improve data architecture and engineering practices.
Required Qualifications:
- Strong hands-on experience with DBT development and testing.
- Strong experience with Snowflake and SQL optimization.
- Proven experience designing and implementing star-schema dimensional models.
- Deep understanding of fact and dimension modeling and analytical data warehouse concepts.
- Ability to work effectively in a collaborative, cross-functional team environment and communicate technical concepts to both technical and non-technical stakeholders.