Description

You will design and implement data modeling solutions to optimize data flow and define lineage within an Azure Data Warehouse.

This role is on-site.

Responsibilities

• Design conceptual, logical, and physical data models for large-scale warehousing and source integrations.
• Document existing architecture and propose optimized data models and ETL processes.
• Collaborate with development teams to implement physical models, build data flows, and optimize database structures.
• Analyze source systems to create detailed Source to Target mappings and develop SQL queries for consumption views.
• Train and lead a small team of data engineers.

Required Skills

• 10+ years of overall experience, with 8-11 years specifically in data modeling for large Data Warehouses.
• Expertise in relational, dimensional, and analytical modeling using RDBMS and NoSQL.
• Advanced SQL skills, including complex query writing and performance tuning.
• Proficiency in data modeling tools such as ER Studio or Erwin.
• Experience translating and mapping relational data models into XML and Schemas.
• Hands-on experience with ETL, data ingestion protocols, and metadata management.
• Ability to utilize BI tools like Power BI or Tableau to represent insights.

Preferred Skills

• Experience in the banking domain building data marts for various banking functions.
• Knowledge of Python or Azure PowerShell scripting for data transformation.
• Familiarity with Azure PaaS components including Azure Data Factory, Databricks, Data Lake, and Azure Synapse.

Key Skills

Education

Any Graduate