Overview
On Site
Depends on Experience
Full Time
Skills
SQL Azure
ETL Tools
SQL
Cloud Sql
Google Cloud Platform
data modeling
Agile/Scrum
Job Details
- 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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.