Cardinal Integrated Technologies Inc · 2 months ago
Senior Data Modeler
Issaquah, WA
Full-time
Onsite
Senior Level, Lead/Staff
10+ years expCardinal Integrated Technologies Inc is seeking an experienced Database Modeler to lead the data architecture and modeling efforts for a major replatforming project. The role involves migrating legacy IBM iSeries systems to modern cloud-based applications on Google Cloud Platform and/or Microsoft Azure.
BankingInformation TechnologyInsurancePharmaceuticalWeb Development
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
Qualification
Required
10+ Years of experience
8 + Years of experience in Data Modeling
3 + Years of experience in GCP
6+ Years in Erwin, Snowflake, Python, Snowflake, Azure Synapse
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
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
Company
Cardinal Integrated Technologies Inc
We are a company of IT professionals who passionately believe that good quality products & services are delivered by great resources.
201-500 employees
H1B Sponsorship
Cardinal Integrated Technologies Inc has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (5)
2024 (1)
2023 (3)
2022 (5)
2021 (4)
2020 (4)
Funding
Current Stage
Growth StageCompany data provided by crunchbase