Data Architect

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

Responsibilities

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

Required Skills

• 10 to 15 years of overall experience, with 8 to 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.
• Strong analytical thinking and problem-solving skills.
• Bachelor's degree in Computer Science or an equivalent field.

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.