Job Title

Role - Azure Data Architect / Data ModelerLocation - Chicago, ILJob Type - HybridJob Description 10+ years of experience delivering data and data analytics solutions in Azure Ecosystem10+ years of experience in building OLTP and OLAP database modelsStrong work experience as a Data Modeler working in Azure Ecosystem.Expertise in Ralph Kimball/Inmon Dimensional Data Modeling, Star schema, Snow-Flake schema, creation of Fact and Dimension Tables, OLAP, OLTP and thorough understanding of Data-Warehousing concepts.Good experience of implementing Enterprise data models on a Data Medallion architectureExperienced in performing customer-facing rolesGood communication and presentation skills and ability to understand the business priorities and how Technology can support these initiatives.Understanding of the Agile based development and execution approachWell versed with data consumption design patterns like semantic layers, visualizations, ML models, Data Medallion and Data-mesh architectures.ResponsibilitiesDefine, review and document data modeling and design standardsExperienced in gathering requirements from Business users for creating and modifying existing Data marts and Reports for various Projects and Departments.Engage with business and technology stakeholders to gather the required information, understand the client expectations, get clarity through workshops, suggest/deliberate on the right data models that meet business requirements.Ability to write complex SQL statements to validate data profiling and transformations.Provide subject matter as a Data Modeler to resolve and address business issues and prioritiesDesigning enterprise data models on cloud (Azure) including services like ETL pipelines, ADF, Synapse etc.