GCP Data Modeler

We are looking for Database Modeler with Cloud and Erwin exp.

Mandatory Areas
Must Have Skills Data Modeler
Skill 1 8 Years of exp in Data Modeling
Skill 2 3 Years of Exp in GCP
Skill 3- 6 Years In Erwin Snowflake Python Snowflake Azure Synapse

Job Title: Senior Database Modeler
Location: Onsite (Issaquah WA)
Experience Required: 10 Years
$65/hr on C2C

Role Overview:

We are seeking an experienced Database Modeler to lead the data architecture and modeling efforts for a major replatforming project migrating legacy IBM iSeries (AS/400) systems to modern cloud-based applications on Google Cloud Platform (GCP) and/or Microsoft Azure. The ideal candidate will have hands-on experience in data modeling source-to-target mapping and cloud-native database design. Strong collaboration skills and the ability to work with distributed teams are essential.

Key Responsibilities:
Design and develop logical and physical data models for cloud databases (Azure SQL Database Cloud SQL BigQuery Spanner).
Analyze iSeries (AS/400) data structures (physical/logical files SQL tables indexes views) and create detailed mapping documents for migration.
Define and enforce data standards normalization rules and naming conventions aligned with cloud best practices.
Work closely with Business Analysts to interpret business rules and translate them into data models.
Collaborate with cloud architects to ensure models align with GCP/Azure architecture including networking security and scalability.
Design schemas for high performance leveraging cloud-native features (partitioning indexes materialized views).
Work with ETL teams to support data transformation and migration using tools like Azure Data Factory Google Dataflow or Informatica.
Maintain data dictionaries metadata repositories and version control for models.
Document processes data flows and architectural decisions.
Collaborate with onsite and offshore teams to ensure seamless delivery across time zones.

Required Skills & Qualifications:
6 years of experience in data modeling database design and migration projects.
Strong hands-on experience with relational databases (Azure SQL Cloud SQL BigQuery).
Proficiency with data modeling tools (Erwin ER/Studio SQL Database Modeler).
Hands-on experience with cloud migration strategies data security and cost optimization.
Experience with ETL tools (Azure Data Factory Google Dataflow Informatica).
Solid understanding of data governance compliance and cloud security principles.
Excellent communication and leadership skills.
Experience working in Agile/Scrum environments.

Preferred Tools & Technologies:
Cloud Platforms: GCP Azure
Databases: Azure SQL Cloud SQL BigQuery NoSQL (Cosmos DB Firestore)
Modeling Tools: Erwin ER/Studio
ETL: Azure Data Factory Google Dataflow Informatica
Version Control: Git Bitbucket
Collaboration: Jira Confluence Slack Microsoft Teams

Nice to Have:
Certifications in cloud platforms or data modeling.
Experience with data visualization tools (Power BI Tableau).
Exposure to CI/CD pipelines for database deployments.
Experience with retail or enterprise-scale applications.