Overview :
TekWissen is a global workforce management provider headquartered in Ann Arbor Michigan that offers strategic talent solutions to our clients world-wide. Our client provider of digital technology and transformation information technology and services
Position : Senior Database Modeler
Location : Issaquah WA 98027
Duration : 6 Months
Job Type : Temporary Assignment
Work Type : Hybrid
Job Description
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 AzureDatabases : Azure SQL Cloud SQL BigQuery NoSQL (Cosmos DB Firestore)Modeling Tools : Erwin ER / StudioETL : Azure Data Factory Google Dataflow InformaticaVersion Control : Git BitbucketCollaboration : Jira Confluence Slack Microsoft TeamsNice 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.TekWissen Group is an equal opportunity employer supporting workforce diversity.
Key Skills
Atl,CMMS,ABAP,Community Support,CRM,Fleet
Employment Type : Full Time
Experience : years
Vacancy : 1