Data Analytics Engineer: Star-Schema & Snowflake Expert
-
IT/Tech
Job Description & How to Apply Below
The IT - Data Modeler is responsible for building and maintaining the analytical foundation that supports enterprise reporting and analytics. This hands-on role focuses on DBT, Snowflake, SQL, and dimensional data modeling, with an emphasis on designing scalable analytical solutions that align with business processes and use cases. The role partners with technical and business stakeholders to deliver trusted, analytics-ready datasets from ingestion through transformation and into the semantic layer.
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 regarding dimensional design, normalization, and denormalization.
• Partner 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 data modeling standards.
• 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 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.
• Strong hands-on experience with Git Hub.
• Ability to work effectively in a collaborative, cross-functional team environment.
• Ability to communicate technical concepts effectively to both technical and non-technical stakeholders.
Preferred Qualifications
• Experience with Azure Data Factory (ADF).
• Experience with Python or Power Query.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction