What are the responsibilities and job description for the Senior Database Modeler position at Torque Technologies LLC?
Job Details
Senior Database Modeler
Day 1 Onsite (Issaquah, WA)
Experience Required: 10 Years
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 (Google Cloud Platform) 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 Google Cloud Platform/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: Google Cloud Platform, 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.