Reporting to the Senior Vice President / General Manager, the Lead Data Modeling Engineer (Azure) is responsible for the architecture, design, development and deployment of data modeling and reporting capabilities utilizing Microsoft Azure Analysis Services, Azure Databricks and Microsoft Power BI software platforms. The role is part of our Enterprise Data Platform team that manages the ingestion, storage, modeling, and consumption of data for Acosta and our clients. The Lead Modeling Engineer is also accountable for the optimization and automation of those BI solutions within Acosta’s Enterprise Data Platform.

MINIMUM EDUCATION AND WORK EXPERIENCE

• Bachelor’s degree or equivalent work experience in industry name required.
• Microsoft Certification: Data Analyst Associate.
• MCSA: BI Reporting.
• Microsoft Certification: Azure Data Engineer Associate.
• 10 years of related work experience.
• 7 years of experience in Microsoft SSAS, AAS and data warehouse design for Business Intelligence.
• 5 years of experience with data analytics and various report development software.
• 5 years of experience in Power BI including M Query and DAX development.
• Experience working with ETL tools such as Azure Databricks.

KNOWLEDGE, SKILLS, AND ABILITIES

• Expert in Power BI, inclusive of the Vertipaq storage engine (compression/segmentation), performance measurement and monitoring, analyzing query plans, advanced optimization of large models.
• An advanced understanding of Relational Database Management Systems (RDBMS) foundations and best practices as it relates to optimizing data and reporting.
• Advanced proficiency in AAS (or SSAS) tabular models, inclusive of loading data, relationships, and modeling, analyzing query plans, security, processing, and partitioning.
• A solid foundation in Azure Databricks including navigation within workspaces, querying notebooks, usage of gateways and DSNs.
• Good problem solving and debugging skills.
• Effective written and verbal communication skills.

Please refer the Job description for details