Senior GCP Data Modeler

Job Title: Senior Database Modeler Location: Onsite (Issaquah, WA) Experience Required: 10+ Years Rate:$60/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.