**DESCRIPTION** **Lead, Data Modeling Tech** reporting to the Senior Manager of Advanced Modeling & Analytics, the Lead Data Modeler 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 Data Modeling Tech Lead is also accountable for the optimization and automation of those BI solutions within Acosta's Enterprise Data Platform. **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** This position is not eligible for employer-sponsored work visas, and candidates must be authorized to work in the United States without current or future sponsorship. This role follows a **Hybrid** schedule requiring three in‑office days each week at a local Acosta hub or office. #Hybrid **Minimum Education and Work Experience** + Bachelor’s degree in Business, Analytics, Information Systems, Computer Science, or equivalent practical experience. + 7 years or more of hands-on experience building tabular data models using Azure Analysis Services (AAS) or SQL Server Analysis Services (SSAS). + 5 years or of experience developing Power BI semantic models, including strong skills in DAX, Power Query (M), and data modeling best practices. + Practical experience working with Azure Databricks (SQL, notebooks, view creation, performance tuning). + Experience supporting analytics solutions for Retail or CPG organizations (POS, syndicated data, supply chain, sales, category performance, etc.) is _preferred_ . + Demonstrated ability to work directly with business stakeholders and/or external clients to translate requirements into scalable BI solutions. **Knowledge, Skills, and Abilities** + Strong understanding of relational database concepts, dimensional modeling, and star-schema design. + Proven experience optimizing BI semantic models (query performance, model size, refresh efficiency). + Hands-on experience developing or enhancing AAS tabular models, including model relationships, partitions, incremental refresh, and security configuration. + Ability to write efficient SQL for data validation, transformations, and Databricks view creation. + Familiarity with modern Azure data platform tools (Data Lake, Synapse, Databricks). + Comfortable working with large datasets and complex business logic. + Ability to explain technical solutions in clear, business-friendly language. + Experience participating in client-facing or cross-functional meetings, particularly with analytics or business leadership. + Strong problem-solving skills with the ability to think critically about how data models impact business decisions. + Ability to document requirements, assumptions, and modeling decisions in a clear and organized manner. + Experience mentoring junior or mid-level BI developers or analysts in Power BI, DAX, or AAS modeling. + Ability to collaborate with project managers, QA, data engineers, and business users. + Comfortable working in Agile environment **Physical Requirements** + Seeing + Listening + Color Perception \#DiscoverYourPath **ABOUT US** Acosta Group is a collective uniting the most trusted retail, marketing, and foodservice agencies—Acosta, ActionLink, CORE Foodservice, CROSSMARK, Mosaic, Premium Retail Services, and Product Connections. Together, we connect consumers with the brands they love through omnichannel selling, merchandising, brand advocacy, and integrated marketing. We recognize our associates are the foundation of our success. That’s why we prioritize your growth, development, and well-being to help you reach your full potential. With programs designed to support a fulfilling work-life balance, we offer opportunities that fit your lifestyle and ambitions—whether you’re looking for part-time flexibility or full-time career advancement. Ready for a career path that’s as unique as you? Discover your path at Acosta Group! 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 AskHR@acosta.com. 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. The Acosta Group utilizes E-Verify for validating the ability to work in the United States for all job candidates. If you want more information on what this entails and your rights as a job applicant, please use the link provided to access information on our use of E-Verify and your right to work. Employer Resources (e-verify.gov) 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:** $90,000.00 - $105,000.00 **Company:** Acosta Employee Holdco LLC **Req ID:** 21931 **Employer Description:** ACOSTA\_GRP\_EMP\_DESC