Senior Data Modeler

Compunnel, Inc.; Issaquah (WA); Hybrid; USD 120,000 - 150,000; Full time

Job summary

A technology consulting firm is seeking an experienced Senior Data Modeler to lead data architecture initiatives in a major replatforming project. The role focuses on migrating legacy systems to cloud-based applications using Google Cloud Platform and Microsoft Azure. The ideal candidate will possess strong expertise in data modeling and collaboration skills to work with distributed teams, ensuring alignment with cloud best practices.

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).
• Proficient with data modeling tools (Erwin, ER/Studio, SQL Database Modeler).
• Experience with cloud migration strategies and data security.

Responsibilities

• Design and develop logical and physical data models for cloud databases.
• Analyze iSeries data structures and create mapping documents for migration.
• Define and enforce data standards and normalization rules.
• Translate business rules into data models in collaboration with analysts.
• Partner with cloud architects to align models with GCP/Azure architecture.
• Support ETL teams in data transformation and migration.

Skills

Data modeling

Collaboration

Cloud-native database design

Data governance

Agile/Scrum

Tools

Erwin

Azure Data Factory

Google Dataflow

Informatica

Job description

We are seeking an experienced Senior Data Modeler to lead data architecture and modeling initiatives for a major replatforming project.

This role involves 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 strong expertise in data modeling, source-to-target mapping, and cloud-native database design, along with excellent collaboration skills to work effectively with distributed teams.

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 and create detailed mapping documents for migration.
• Define and enforce data standards, normalization rules, and naming conventions aligned with cloud best practices.
• Translate business rules into data models in collaboration with Business Analysts.
• Partner with cloud architects to ensure models align with GCP/Azure architecture, including networking, security, and scalability.
• Design schemas optimized for performance using cloud-native features (partitioning, indexes, materialized views).
• Support ETL teams in 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 for seamless delivery across time zones.

Required 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 Qualifications

• Familiarity with NoSQL databases (Cosmos DB, Firestore).
• Experience with data visualization tools (Power BI, Tableau).
• Exposure to CI/CD pipelines for database deployments.
• Experience with retail or enterprise-scale applications.