Associate Director, Business Intelligence

Revance • Nashville, TN

2d

About The Position

The Associate Director, Business Intelligence leads Revance's enterprise reporting and analytics capability: the Power BI platform, the BI development team, and the next generation of self-service intelligence tools that let business users ask questions in natural language and receive advanced, visual answers. Partnering with Data Engineering and with stakeholders across commercial, finance, supply chain and operations, this leader sets the reporting standard for the company. Dashboards should be accurate, trusted, widely used, and built to a level of polish and ease of use that reflects the Revance brand. It is a hands-on leadership role in a fast-paced, entrepreneurial environment where much of the BI roadmap is still being written.

Requirements

• Bachelor of Science degree in business administration, computer science, statistics or another closely related field.
• 7+ years in business intelligence or analytics, with deep hands-on Power BI experience
• 3+ years leading BI or analytics teams, including managing or working through offshore and distributed resources
• Extensive knowledge of business intelligence and data warehouse environments, including system administration, dimensional modelling, semantic layer design, security, reporting and analytics, on a modern data platform such as Microsoft Fabric, Azure Synapse, Snowflake or Databricks
• SME in data visualization and modeling in Power BI to answer both routine and abstract business questions
• Broad Microsoft stack skills across SQL Server, Power BI, Power Apps, DAX, M (Power Query), SSIS and Excel; strong practical T-SQL is essential, and DAX, M and XMLA proficiency is expected
• Demonstrated strategic focus, with the capacity to shape a vision and take accountability for advancing business intelligence objectives
• Outstanding interpersonal and communication skills, able to engage stakeholders across the full range of data literacy, from beginner to expert
• Proven track record managing end-to-end BI projects, and comfort in a fast-paced, entrepreneurial environment with shifting priorities and limited precedent

Nice To Haves

• Master’s degree in business administration with a concentration in business intelligence.
• Experience delivering AI-assisted or natural language analytics (Power BI Copilot, Snowflake Cortex, or comparable LLM-based query interfaces) strongly preferred
• Life sciences, medical aesthetics or consumer health experience a plus

Responsibilities

• Build and own a capability that lets business users query enterprise data in natural language and receive advanced, context-aware responses, including visualizations generated on demand.
• Own all aspects of the Power BI platform and hold every dashboard to a high bar for accuracy, performance and usability.
• Collaborate with Data Engineering to design, build and govern a shared semantic layer serving both curated dashboards and self-service intelligence, with consistent definitions, certified measures and efficiently modelled master data sets, so a metric means the same thing everywhere at Revance.
• Define and enforce Revance standards for BI deliverables, covering templates, layout, brand-coherent color and visualization conventions, so reports consistently meet the company's expectations for ease of use and analytical sophistication.
• Work directly with business stakeholders to translate business requirements into intuitive, decision-ready reporting, probing the underlying decision behind each request.
• Build and lead a high-performing BI team spanning onshore and offshore resources, including a Manager, BI and a team of BI developers.
• Oversee multiple BI projects end to end, managing timelines, resources and stakeholder requirements, and run intake and prioritization with the leadership team.
• Assess reporting requirements across the enterprise, own the long-term reporting strategy, and translate it into operational plans aligned to business priorities and budget.
• Ensure data accuracy, consistency and integrity across all BI reports and underlying models; monitor performance, troubleshoot issues, and use Azure DevOps and deployment pipelines for ALM.
• Operate a control framework that minimizes risk, establish a clear ownership model for Power BI artifacts, and adhere to Revance's Data Policy guidelines.

Benefits

• Competitive Compensation including base salary and annual performance bonus.
• Flexible PTO (12 days' PTO), holidays, and parental leave.
• Generous healthcare benefits, HSA match, 401k match, employer paid life and disability insurance, pet insurance, wellness discounts and much more!

What This Job Offers

• Job Type: Full-time
• Career Level: Senior