Overview
On Site
$55 - $60
Full Time
Accepts corp to corp applications
100% Travel
Skills
Azure SQL
Cloud SQL
ER/Studio
NoSQL
Azure Data Factory
Google Dataflow
Informatica
Jira
Confluence
Slack
GCP
Job Details
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 (Google Cloud Platform) 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 Google Cloud Platform/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: Google Cloud Platform, Azure
Databases: Azure SQL, Cloud SQL, Cloud SQL, 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.
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 (Google Cloud Platform) 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 Google Cloud Platform/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: Google Cloud Platform, Azure
Databases: Azure SQL, Cloud SQL, Cloud SQL, 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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.