Lead BI Analyst

Horizontal Talent

Denver, CO, United States

25 days ago

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

3 years minimum

Working hours

Regular working hours

Job source

Adobe Analytics Microsoft Azure Big Data BigQuery Information Engineering Data Presentation Database Queries Power BI Sql Optimization Snowflake

Translate Adobe Analytics data into meaningful insights across acquisition, engagement, revenue, and overall marketing performance
Combine performance data from paid media, CRM, ecommerce, web, and app channels into unified reporting stories
Lead recurring reporting discussions with stakeholders, including monthly, quarterly, and executive reviews
Analyze attribution, cohort trends, and performance metrics to support business decisions and optimization opportunities
Design and deliver end-to-end Power BI solutions, including semantic models, DAX development, and dashboard visualization
Build executive-ready dashboards that serve as a reliable source of truth for reporting
Improve fragmented reporting processes by creating scalable BI frameworks
Write advanced SQL to transform, validate, and analyze large datasets
Collaborate with data engineering teams in Snowflake, Azure, or BigQuery environments
Partner with marketing, engineering, and business leaders to define KPI standards and measurement frameworks
Lead client-facing analytics conversations with confidence, clarity, and professionalism

7+ years of experience in marketing analytics, business intelligence, or analytics consulting
3+ years of hands-on Power BI experience, including data modeling, DAX development, and governance
Deep working knowledge of Adobe Analytics
Strong SQL skills with experience handling large-scale datasets
Experience presenting insights and recommendations to senior stakeholders and executives
Strong data storytelling, visualization, and reporting skills
Ability to connect technical analysis with business outcomes
Portfolio or work examples that demonstrate Power BI dashboard design and reporting strategy, * Experience working in an agency or client-services environment
Familiarity with Snowflake, Azure, or BigQuery
Experience supporting modern marketing measurement and attribution approaches
Ability to work independently while collaborating effectively across teams
Strong communication skills and a thoughtful, consultative approach to problem-solving