What are the responsibilities and job description for the Data Modeler position at Kanak Elite Services?
Hello There,
My name is Himanshu Sharma, and I serve as the Recruitment Lead at Kanak-IT INC. I am reaching out to share an excellent career opportunity for the role of Data Modeler with our esteemed client. If you are interested then please share your updated resume at Himanshu01@kanakits.com
Job Description
Position : Data Modeler
Location : Issaquah WA Hybrid (3 days onsite)
Duration : 5 months with extension
Must Have Skills Data Modeler
Skill 1 8 Years of exp in Data Modeling
Skill 2 3 Years of Exp in GCP
Skill 3- 6 Years In Erwin, Snowflake, Python, Snowflake, Azure Synapse
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.
My name is Himanshu Sharma, and I serve as the Recruitment Lead at Kanak-IT INC. I am reaching out to share an excellent career opportunity for the role of Data Modeler with our esteemed client. If you are interested then please share your updated resume at Himanshu01@kanakits.com
Job Description
Position : Data Modeler
Location : Issaquah WA Hybrid (3 days onsite)
Duration : 5 months with extension
Must Have Skills Data Modeler
Skill 1 8 Years of exp in Data Modeling
Skill 2 3 Years of Exp in GCP
Skill 3- 6 Years In Erwin, Snowflake, Python, Snowflake, Azure Synapse
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.