Job Overview:

We are seeking an experienced Data Architect / Data Modeler with strong expertise in data warehouse design and Snowflake to support our client in building a scalable, cloud-based reporting data warehouse. The ideal candidate will have a solid background in designing enterprise-level data models and architectures that enable efficient, high-quality reporting and analytics.

Key Responsibilities:

Work closely with business and technical stakeholders to understand reporting and analytics requirements.

Design conceptual, logical, and physical data models to support the data warehouse on Snowflake.

Define data architecture standards and best practices for the cloud-based reporting environment.

Lead the data modeling effort to ensure data consistency, quality, and usability across reporting layers.

Develop data dictionaries, ER diagrams, and documentation for data structures and business rules.

Collaborate with ETL developers, BI analysts, and data engineers to ensure smooth data integration and accessibility.

Optimize data structures for performance and scalability within Snowflake.

Support data governance, security, and compliance needs in the design.

Required Skills & Experience:

8+ years of experience in data architecture, data modeling, or data warehousing.

Strong hands-on experience with Snowflake, including schema design, performance optimization, and security.

Proven experience in building data warehouses for reporting and analytics.

Expertise in data modeling tools (e.g., Erwin, ER/Studio, dbt, Lucidchart).

Deep understanding of dimensional modeling (star/snowflake schemas), normalization, and OLAP concepts.

Strong SQL and experience with ETL/ELT processes.

Excellent communication and documentation skills.

Preferred Qualifications:

Experience with reporting tools like Tableau, Power BI, or Looker.

Familiarity with cloud platforms (AWS/Azure/GCP).

Experience with data governance and MDM frameworks.