Job ID:
J56118
Job Title:
Senior Data Architect
Location:
Issaquah, WA
Duration:
8 Months + Extension
Domain Exposure:
Manufacturing
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: $77/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:
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.