Position Details
Senior Database Modeler Apply
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, 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.
TekWissen Group is an equal opportunity employer supporting workforce diversity.
