Job Description


Job Overview

  • Job ID:

    J55920

  • Job Title:

    Senior Data Architect

  • Location:

    Issaquah, WA

  • Duration:

    8 Months + Extension

  • Domain Exposure:

    Consumer Discretionary

  • Client:

    To Be Discussed Later

  • Employment Type:

    W-2, 1099, C2C

  • Work Authorization:

    US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Job Title:Senior Data Architect

Location: Issaquah, WA

Duration: 8 Months + Extension

Bill Rate: $78/hour (C2C)

Job Type: W-2, 1099, C2C

Client: To Be Discussed Later

Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Job Description: 

8+ years of experience in data modeling, database design, and enterprise
data architecture, with strong exposure to Google Cloud Platform (GCP).
The ideal candidate will design scalable, high-quality data models for
cloud applications, APIs, analytics platforms, and enterprise
integration solutions.
This role will partner closely with Data Architects, Application
Architects, Developers, Business Analysts, Product Owners, and Data
Engineering teams to translate complex business requirements into
effective logical and physical data models.

Responsibilities:

Design and maintain conceptual, logical, and physical data models for
enterprise and cloud-based applications.
Translate complex business requirements into scalable and reusable data
structures.
Develop data models supporting transactional applications, APIs,
microservices, analytics, and reporting solutions.
Design data models for solutions hosted on Google Cloud Platform (GCP).
Develop and optimize data structures for BigQuery, Cloud SQL, and other
applicable GCP data services.
Define entities, attributes, relationships, keys, reference data, and
business rules.
Apply appropriate normalization and dimensional modeling techniques
based on transactional and analytical requirements.
Develop star schemas, snowflake schemas, facts, dimensions, and semantic
data structures for analytical workloads.
Establish and maintain enterprise data dictionaries, metadata, naming
standards, and modeling conventions.
Perform source-to-target data mapping and support data transformation
requirements.
Collaborate with Data Engineers on ingestion, transformation, migration,
and data integration solutions.
Partner with API and application teams to align application data
contracts with enterprise data models.
Review existing data models and recommend improvements for scalability,
performance, maintainability, and data quality.
Assess legacy database structures and develop target-state models as
part of cloud modernization and migration initiatives.
Participate in data architecture and design reviews.
Support impact analysis for data model and schema changes across
dependent applications and interfaces.
Work with governance teams to ensure adherence to data governance,
security, privacy, and retention requirements.
Provide technical guidance and mentoring to development and data
engineering teams on data modeling best practices.

Requirements:

8+ years of experience in data modeling, database design, data
architecture, or related data engineering roles.
Strong experience creating conceptual, logical, and physical data
models.
Strong understanding of relational, dimensional, and analytical data
modeling.
Hands-on experience with Google Cloud Platform (GCP) data technologies.
Strong knowledge of BigQuery and Cloud SQL. - Advanced knowledge of SQL
and relational database concepts.
Experience designing models for APIs, microservices, cloud-native
applications, and enterprise integrations.
Strong understanding of normalization, denormalization, referential
integrity, indexing, keys, and database design principles.
Experience with star schema, snowflake schema, facts, dimensions, and
dimensional modeling.
Experience with source-to-target mapping, data lineage, and metadata
management.
Experience with enterprise data modeling tools such as erwin Data
Modeler, ER/Studio, SAP PowerDesigner, or similar tools.
Experience working with Data Architects, Data Engineers, Application
Architects, and business stakeholders.
Strong analytical, problem-solving, documentation, and communication
skills.


Apply Now
Equal Opportunity Employer

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.