Data Architect / Data Modeler

Anblicks Inc.; Dallas (TX); On-site; USD 120,000 - 160,000; Full time

Job summary

A leading company specializing in data solutions seeks a Data Architect/Data Modeler to lead the design and implementation of a cloud-based reporting data warehouse using Snowflake. The ideal candidate will bring 8+ years of experience, strong skills in dimensional modeling, and a collaborative approach to working with technical stakeholders. You will shape the data architecture standards and ensure optimal performance and scalability in the data environment.

Qualifications

• 8+ years' experience in data architecture/modeling.
• Hands-on Snowflake proficiency required.
• Expertise in data modeling tools essential.

Responsibilities

• Design conceptual, logical, and physical data models.
• Lead data modeling for data consistency and quality.
• Collaborate with teams for data integration.

Skills

Data Architecture

Data Modeling

Snowflake

SQL

ETL/ELT Processes

Dimensional Modeling

Communication

Education

Bachelor's or Master's in Computer Science, Information Systems, or related field

Tools

Snowflake

Erwin

Looker

Tableau

Power BI

ER/Studio

dbt

Job description

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.