Lead Data Modeling Engineer (Azure) - Hybrid

Acosta Group; Charlotte (NC); Hybrid; USD 85,000 - 100,000; Full time

Job summary

Join a forward-thinking company as a Lead Data Modeler Engineer, where you will architect and optimize data modeling solutions utilizing cutting-edge technologies like Microsoft Azure and Power BI. This dynamic role involves collaborating with diverse teams to enhance data reporting capabilities, mentoring fellow engineers, and driving innovation within the Enterprise Data Platform. With a strong focus on professional growth and a commitment to work-life balance, this position offers a unique opportunity to make a significant impact in a thriving environment. If you are passionate about data and eager to shape the future of BI solutions, this is the perfect role for you.

Qualifications

• 10 years of related work experience in data modeling and BI solutions.
• Expert in Power BI and Azure Analysis Services with advanced optimization skills.
• Experience with ETL tools and data analytics software.

Responsibilities

• Develop complex Azure Analysis Services Tabular models and Power BI reports.
• Mentor junior data modelers and optimize BI solutions.
• Collaborate with cross-functional teams to deliver data solutions.

Skills

Power BI

Azure Analysis Services

Data Modeling

DAX Development

ETL Tools

Data Analytics

Problem Solving

Education

Bachelor’s degree or equivalent work experience

Microsoft Certification: Data Analyst Associate

MCSA: BI Reporting

Microsoft Certification: Azure Data Engineer Associate

Tools

Azure Databricks

Microsoft Power BI

Job description

1 month ago Be among the first 25 applicants

Description

Reporting to the Senior Vice President / General Manager, the Lead Data Modeler Engineer 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.

Description

Reporting to the Senior Vice President / General Manager, the Lead Data Modeler Engineer 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.

This position is a #hybrid open to #anywhere. You will be expected to work on-site close to an Acosta Group office at least 3-days a week. Ideal candidates may be located in Jacksonville, FL; Lewisville (Dallas), TX; Rogers, AR; or Charlotte, NC.

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

Physical Requirements

• Seeing
• Listening
• Color Perception
  
  
  

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!

We empower you to Discover Your Path and fully embrace BEING YOU as you shape your journey with us. At Acosta Group, we value equal opportunity in employment practices and career progression. Employment decisions are based on business needs, job requirements, and individual qualifications without regard to race/ethnicity, gender/gender identity, disability, veteran status, or any other basis protected by federal, state, and local laws. Acosta Group will provide reasonable accommodations for applicants with physical or mental disabilities to complete applications or interviews for employment. If reasonable accommodation is needed to participate in the job application or interview process, please contact [e-mail]

Acosta Group and its subsidiaries believe the posted compensation range accurately reflects this role at the time of posting. Final pay may vary based on qualifications and location, and the range may be updated in the future.

Acosta Group is an E-Verify employer. By applying, you agree to our Privacy Statement and Terms of Conditions.

US: http://acosta.jobs/privacy-policy-us/

Canada: http://acosta.jobs/privacy-policy-ca/

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

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Engineering and Information Technology

• Industries

  Business Consulting and Services

Referrals increase your chances of interviewing at Acosta Group by 2x

Get notified about new Modeling Engineer jobs in Charlotte, NC.

Huntersville, NC $98,100 - $156,400 10 months ago

Charlotte, NC $90,000 - $115,000 3 weeks ago

Specialist Mechanical Engineer (Stress Analysis)

Charlotte, NC
$65,000.00
-
$75,000.00
2 months ago

Experienced Design Engineer - Steam Turbine Valves

Senior Systems Modeling Research Engineer

Davidson, NC
$94,000.00
-
$125,000.00
5 hours ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.