Digital Analyst II

shiftdigital; Birmingham (MI); On-site; USD 65,000 - 90,000; Full time

Job summary

Shift Digital in Birmingham, MI is seeking a highly analytical Digital Analyst to transform complex data into actionable business insights across Website Performance, Customer Leads, Dealer Sales, Inventory, and Digital Advertising.

You will design, develop, and maintain Power BI reporting solutions, model data with DAX, and present findings to clients and internal stakeholders, using storytelling to drive data-driven decisions and strategic recommendations.

Qualifications

• 3-5 years of analytics, business intelligence, or a related field.
• Strong analytical skills and experience with large, complex datasets.
• Power BI expertise, including report development, data modeling, DAX, and dashboard design.
• Ability to communicate insights through compelling data storytelling and presentations.
• Experience presenting analytical findings to clients, executives, or business stakeholders.
• Advanced proficiency in Microsoft Excel and PowerPoint.
• Self-motivated, curious, and driven to solve business problems.

Responsibilities

• Collaborate with a talented team of analysts at one of Metro Detroit's Top Places to Work.
• Analyze data across Website Performance, Customer Leads, Dealer Sales, Inventory, Digital Advertising, Field Training, and other business areas.
• Design, develop, and maintain Power BI reporting solutions that enable data-driven decision making.
• Conduct recurring and ad hoc analyses to identify trends, opportunities, and performance drivers.
• Translate complex data into clear, actionable insights through effective storytelling and visualization.
• Present findings and recommendations to clients and internal stakeholders.
• Partner with clients and account teams to understand business goals and provide analytical guidance.
• Developing traffic and advertising pacing models.
• Evaluating media mix performance across digital channels.
• Identifying drivers of business performance through exploratory analysis.
• Delivering data-driven recommendations that support strategic decision-making.

Skills

Analytical mindset

Power BI expertise

Data storytelling

Excel & PowerPoint

Client communication

Tools

Power BI

SQL

Excel

DAX

Job description

Shift Digital is the leader in digital marketing program optimization. Established in 2008 and headquartered in Birmingham, Michigan, our comprehensive solutions help national brands and their local retailers measure, manage, and improve the performance of their digital marketing and sales initiatives.

The Advanced Analytics team is experiencing continued growth and is seeking highly analytical, self-motivated professionals who enjoy transforming complex data into meaningful business insights. Our team consists of subject matter experts across Digital Advertising, Customer Leads, Website Experience, Inventory, Sales, and Field Training.

One of the unique advantages of joining Shift as a Digital Analyst is access to an extensive and connected data ecosystem. Our analysts have the opportunity to evaluate performance across the entire customer journey—from Digital Advertising and Website Experience through Lead Generation, Dealership Engagement, and ultimately Vehicle Sales. This end-to-end visibility allows our team to deliver impactful insights that directly influence client success and business strategy.

Key Responsibilities & Highlights

• Collaborate with a talented team of analysts at one of Metro Detroit's Top Places to Work.
• Analyze data across Website Performance, Customer Leads, Dealer Sales, Inventory, Digital Advertising, Field Training, and other business areas.
• Design, develop, and maintain Power BI reporting solutions that enable data-driven decision making.
• Conduct recurring and ad hoc analyses to identify trends, opportunities, and performance drivers.
• Translate complex data into clear, actionable insights through effective storytelling and visualization.
• Present findings and recommendations to clients and internal stakeholders.
• Partner with clients and account teams to understand business goals and provide analytical guidance.

Examples of projects may include:

• Developing traffic and advertising pacing models.
• Evaluating media mix performance across digital channels.
• Identifying drivers of business performance through exploratory analysis.
• Delivering data-driven recommendations that support strategic decision-making.

Qualifications

• 3-5 years of experience in analytics, business intelligence, or a related field.
• Strong analytical skills and experience working with large, complex datasets.
• Power BI expertise, including report development, data modeling, DAX, and dashboard design.
• Ability to communicate insights through compelling data storytelling and presentations.
• Experience presenting analytical findings to clients, executives, or business stakeholders.
• Advanced proficiency in Microsoft Excel and PowerPoint.
• Self-motivated, curious, and driven to solve business problems.

Preferred Qualifications

• Experience with digital advertising measurement and performance analysis.
• SQL query writing and data extraction experience.
• Statistical analysis or predictive modeling experience.
• Automotive industry experience is a plus, but not required.