Lead Data Modeling Engineer (Azure)

DESCRIPTION

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.

Ideal candidates may be located in Jacksonville, FL; Dallas, TX; Rogers, AR; St. Louis, MO; Chicago, IL; or Charlotte, NC, however open to other candidates in EST or CST time zones

*This position is not eligible for Visa Sponsorship (i.e. H1-B, H4, etc.).

RESPONSIBILITIES

• Development of complex/advanced Azure Analysis Services (AAS) Tabular models with large volumes of data and advanced business logic, as well as enhancements to existing large/advanced AAS models.

• Creation of complex and efficient views in Azure Databricks to support AAS Tabular modeling requirements.

• Work closely with Project Managers / Scrum Masters, BI Architects, BI QA Analysts and Data Engineering Developers in both Agile and Waterfall work settings to deliver solutions against a deadline that meet the requirements of the business and product stakeholders.

• Performance monitoring, tuning and optimization of AAS and PBI models.

• Mentors Junior and Senior Data Modelers in PBI and AAS development, specifically surrounding optimization, and automation.

• Investigate new and emerging technologies with potential uses for Microsoft and other BI technologies by researching, POC'ing and sharing solutions within the Data Platform team that will help drive efficiency and innovation for our business and product stakeholders.

• Continually focus on self-development by allocating time to continually develop your BI, modeling, and data skills.

• Automation and scheduling/triggering of data refreshes for the AAS models.

• Investigate new and emerging technologies with potential uses and impacts for the Data Platform and Acosta as a whole.

• Provisioning and sizing of AAS resources.

• In addition to model development, there will also be occasions where new complex/advanced Power BI reports, as well as enhancements to existing complex/advanced Power BI reports will require development

• Familiarize yourself with Acosta's services (namely Retail, Headquarter Selling) - along with the data solutions (NARS, POS, CPG Syndicated) that support those services.

• Think critically about the data model solutions you're delivering. You need to understand it and expand its implications beyond the numbers alone. As a critical thinker, you can think analytically about modeling data and BI, identifying patterns and extracting actionable insights and information from the data made available to you.

• Other duties as assigned

QUALIFICATIONS

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.

#DiscoverYourPath

ABOUT US

Acosta is a part of Acosta Group - a collective of the industry's most trusted retail, marketing and foodservice agencies reimagining the way people connect with brands at every point in their shopping journey.

Specializing in retail sales services, digital strategy, and business intelligence, Acosta empowers brands to thrive in the world of omnichannel shopping. Our sales and digital teams build lasting relationships, ensuring our client brands get the space they deserve in stores and outperform the competition online, while our merch reps make brands shine in retail locations across the world.

But it's not just about what we do - it's about who we are. With a team of over 20,000 associates, we're a community of forward-thinking, value-driven professionals committed to an unmatched level of trust and transparency in the industry. And, we understand the importance of work-life balance, which is why many of our field roles provide our associates with flexible scheduling options. Join us and be a part of a team that values growth and making a real impact for our clients, retail partners and their customers.

Acosta Group is an equal opportunity employer and will ensure that applicants with disabilities are provided with reasonable accommodations. If reasonable accommodation is needed, please contact Be sure to include "Applicant Accommodation" in the subject of your email to expedite the request.

Acosta Group believes in good faith that the minimum and maximum annual salary or hourly compensation range for this opportunity is accurate and reasonable at the time of posting.

By applying, you agree to our Privacy Policy and Terms and Conditions of Use.

#DiscoverYourPath

Acosta, and its subsidiaries, is an Equal Opportunity Employer

Job Category: Administration

Position Type: Full time

Business Unit: Sales

Salary Range: $85,000.00 - $100,000.00

Company: Acosta Employee Holdco LLC

Req ID: 5009

Employer Description: ACOSTA_EMP_DESC