Acosta

Lead Data Modeling Engineer, Azure

Acosta

full-time

Posted on:

Origin:  • 🇺🇸 United States • Florida, North Carolina

Visit company website
✨ AI Apply
Manual Apply

Job Level

Senior

Tech Stack

AzureETLRDBMS

About the role

  • Architecture, design, development and deployment of data modeling and reporting capabilities using Microsoft Azure Analysis Services, Azure Databricks and Microsoft Power BI.
  • Part of the Enterprise Data Platform team managing ingestion, storage, modeling, and consumption of data for Acosta and clients.
  • Accountable for optimization and automation of BI solutions within Acosta's Enterprise Data Platform.
  • This position is a hybrid role open to anywhere; expected to work on-site close to an Acosta Group office at least 3 days a week; ideal locations: Jacksonville, FL; Lewisville (Dallas), TX; Rogers, AR; Charlotte, NC.
  • This position is not eligible for Visa Sponsorship.
  • Development of complex/advanced AAS Tabular models with large volumes of data and advanced business logic, and enhancements to existing models.
  • Creation of complex and efficient views in Azure Databricks to support AAS Tabular modeling.
  • Work closely with Project Managers, BI Architects, BI QA Analysts and Data Engineering Developers in Agile and Waterfall settings to deliver solutions to stakeholders.
  • Performance monitoring, tuning and optimization of AAS and Power BI models.
  • Mentor Junior and Senior Data Modelers in PBI and AAS development, focusing on optimization and automation.
  • Research and POC new and emerging BI technologies and share solutions within the Data Platform team.
  • Focus on continual self-development of BI, modeling, and data skills.
  • Automation and scheduling/triggering of data refreshes for the AAS models.
  • Provisioning and sizing of AAS resources.
  • Development and enhancement of complex/advanced Power BI reports as required.
  • Familiarize with Acosta's services and supporting data solutions (NARS, POS, CPG Syndicated).
  • Think critically about delivered data model solutions and extract actionable insights.
  • Other duties as assigned.

Requirements

  • Bachelor’s degree or equivalent work experience.
  • 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.
  • Expert in Power BI, inclusive of the Vertipaq storage engine (compression/segmentation), performance measurement and monitoring, analyzing query plans, advanced optimization of large models.
  • Advanced understanding of Relational Database Management Systems (RDBMS) foundations and best practices for optimizing data and reporting.
  • Advanced proficiency in AAS (or SSAS) tabular models including loading data, relationships, modeling, analyzing query plans, security, processing, and partitioning.
  • 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.
  • Physical Requirements: Seeing; Listening; Color Perception.