Data Architect / Data Modeler

Anblicks; Dallas (TX); On-site; USD 134,000 - 190,000; Full time

Job summary

Anblicks is seeking an experienced Data Architect / Data Modeler to support building a scalable, cloud-based reporting data warehouse. The successful candidate will work with stakeholders to define requirements, design data architecture, and optimize data structures within Snowflake, ensuring effective reporting and analytics.

Qualifications

• 8+ years of experience in data architecture, data modeling, or data warehousing.
• Strong experience with Snowflake, including schema design and optimization.
• Proven experience in building data warehouses for reporting.

Responsibilities

• Work closely with stakeholders to understand reporting requirements.
• Design data models to support the data warehouse on Snowflake.
• Lead the data modeling effort for quality and consistency.

Skills

Data modeling

Snowflake

SQL

Data governance

Tools

Erwin

ER/Studio

dbt

Lucidchart

Job description

Direct message the job poster from Anblicks

Job Title: Data Architect / Data Modeler

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.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Engineering, Information Technology, and Design

• Industries

  IT Services and IT Consulting, Information Services, and Engineering Services

Referrals increase your chances of interviewing at Anblicks by 2x

Get notified about new Data Architect jobs in Dallas, TX.

Senior Clinical Informatics Data Architect

Dallas, TX $134,000.00-$190,000.00 3 days ago

Staff Clinical Informatics Data Architect

Dallas, TX $162,000.00-$230,000.00 13 hours ago

Solutions Architect, Retail, Google Cloud

Addison, TX $147,000.00-$216,000.00 6 days ago

Irving, TX $156,160.00-$234,240.00 1 week ago

Principal AWS Data Architect and Engineer

Head of Data(Data Architect) : Full-Time

Data Architect with Investment Management experience

Senior Clinical Informatics Data Architect

Dallas, TX $134,000.00-$190,000.00 2 months ago

Data Architect / Data Analyst ( experience in Hadoop required)

Irving, TX $140,000.00-$160,000.00 3 days ago

Data Solutions Architect – Federal Program

Irving, TX $119,765.00-$154,990.00 3 days ago

Irving, TX $106,000.00-$145,000.00 1 week ago

Addison, TX $125,000.00-$178,000.00 3 days ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.