Data Analytics Engineer: Star-Schema & Snowflake Expert

Compunnel Inc.; Spring (TX); Ibrido; USD 110.000 - 140.000; Tempo pieno

Descrizione del lavoro

Compunnel, Inc. is seeking an IT - Data Modeler to design and maintain scalable analytical models and datasets. The role emphasizes DBT, Snowflake, and dimensional modeling to support enterprise reporting and analytics.

You will collaborate with engineers, product owners, and business stakeholders to translate requirements into analytics-ready solutions, ensuring data quality from ingestion to the semantic layer.

Competenze

• Hands-on DBT development and testing experience.
• Strong Snowflake and SQL optimization skills.
• Proven design of star-schema dimensional models.
• Deep knowledge of fact and dimension modeling and DW concepts.
• Hands-on experience with GitHub.
• Ability to work in a collaborative, cross-functional team.
• Effective communication of technical concepts to stakeholders.

Mansioni

• Design, develop, and maintain star-schema data models, including fact and dimension tables.
• Build and support DBT models and testing frameworks.
• Develop, optimize, and troubleshoot data structures and SQL workloads in Snowflake.
• Apply data modeling best practices and dimensional design decisions.
• Partner with Data Engineers, BI Developers, Product Owners, and stakeholders.
• Participate in design discussions, knowledge sharing, peer reviews.
• Support data delivery from ingestion through transformation to semantic layer.
• Document modeling decisions and collaborate to improve data architecture.

Conoscenze

DBT development

Snowflake

SQL optimization

Star-schema modeling

Fact and dimension modeling

GitHub

Cross-functional collaboration

Stakeholder communication

Strumenti

DBT

Snowflake

Azure Data Factory (ADF)

Python

Power Query

GitHub

Descrizione del lavoro

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 GitHub.

• 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.