MPP data platforms like Azure SQL, Managed SQL, Azure Data Lake
Data Modeling
Job Description:
10+ years of experience in data architecture & data analytics space.
5+ years of experience in developing end to end data solution architecture for various data architecture patterns. E.g. data warehouses, Operational data stores, Data Lakes etc.
Must have experience in various data model patterns used in different data architectures.
Must have experience in producing various architecture artifacts and presenting it to various stakeholders and review boards.
Must have experience in one or more ETL workloads using Azure Data Factory, HDFS and Spark
Must have experience in one or more MPP data platforms like Azure SQL, Managed SQL, Azure Data Lake
Must have experience working in Agile environment.
Up to date on latest technology platform trends in data architecture space.
Data modeling principles including conceptual, logical and physical data modeling, dimensional modelling techniques
Well familiar with Data models technologies and approaches
Should have experience in data warehouse architectures (e.g. Azure Synapse DB and Enterprise BI)
Ability to facilitate communication between technical and business stakeholders to ensure functional requirements and technical implementation considerations are understood and accepted.
Data discovery and prototype work in SQL, and work with data consumers to evolve from initial models to final specifications that meet business needs.
Present data models in review meetings
Practical experience in data mining and analysis tools with intermediate to advanced query skills (ex. MS SQL, Synapse Analytics, Data Explorer, Cosmos, Hive, MR, RedShift, Snowflake, MySQL).
Ability to learn quickly and identify opportunities for improvement.
Experience with understanding technical design specifications that are consumed by development/engineering teams as a guide for