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