Senior Data Modeler

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.