Data Modeler

Job Title: Senior Data Modeler

Location: Onsite (Issaquah, WA)

Experience Required: 10 Years

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.