Associate Director, Business Intelligence

Revance; Nashville (TN); On-site; USD 140,000 - 195,000; Full time

Benefits offered by this job

Competitive compensation

Flexible PTO

Healthcare benefits

401k match

Job summary

Revance is seeking an Associate Director of Business Intelligence in Nashville to lead enterprise reporting and analytics. You will own the Power BI platform, the BI team, and self-service AI-enabled analytics across commercial, finance, supply chain and operations.

Role requires hands-on BI leadership, governance, and strong partnering with Data Engineering. You will drive adoption, quality, and a polished Revance-brand reporting experience.

Qualifications

• 7+ years in business intelligence or analytics, with deep hands-on Power BI experience.
• 3+ years leading BI or analytics teams, including offshore and distributed resources.
• Experience delivering AI-assisted or natural language analytics (Power BI Copilot, Snowflake Cortex, or similar) is preferred.
• Extensive knowledge of BI and data warehouse environments including modelling, security, and governance.

Responsibilities

• Build and own a next-generation self-service intelligence capability with natural language queries and visualizations.
• Own all aspects of Power BI platform, drive adoption, measure utilization, and retire low-value reports.
• Design, build, and govern a shared semantic layer with consistent definitions and certified measures.
• Define and enforce BI reporting standards for templates, layout, and visuals.
• Work with stakeholders to translate business needs into decision-ready reports.
• Lead onshore/offshore BI teams, set delivery standards, and align across time zones.
• Oversee multiple BI projects end-to-end, manage timelines and resources.
• Develop long-term reporting strategy aligned to business priorities and budget.
• Ensure data integrity and platform operations with governance and risk controls.

Skills

Power BI

BI leadership

Data governance

SQL / T-SQL

Stakeholder management

Data visualization

AI analytics

Natural language queries

Education

Bachelor’s degree in business administration, computer science, statistics

Master’s degree in business intelligence (preferred)

Tools

Power BI

SQL Server

Azure Synapse

Snowflake

Databricks

Microsoft Fabric

DAX

M (Power Query)

XMLA

SSIS

Excel

Job description

Job Summary:

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.

Key Responsibilities:

• Next-generation self-service intelligence: 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. Remain platform-agnostic in evaluating and scaling the options, among them Power BI Copilot and Q&A, Snowflake Cortex Analyst, Databricks Genie, and web-based or embedded conversational analytics applications. Establish the governance, accuracy testing and enablement that make these tools trustworthy.
• Power BI quality and utilization: Own all aspects of the Power BI platform and hold every dashboard to a high bar for accuracy, performance and usability. Drive adoption by measuring utilization, retiring low-value reports, and closing the gap between what is published and what is used.
• Semantic layer: 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.
• Reporting standards: 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.
• Business partnership: Work directly with business stakeholders to translate business requirements into intuitive, decision-ready reporting, probing the underlying decision behind each request.
• Team leadership: Build and lead a high-performing BI team spanning onshore and offshore resources, including a Manager, BI and a team of BI developers. Coach and develop talent, set delivery standards, and keep a distributed team aligned across time zones.
• Portfolio and delivery management: Oversee multiple BI projects end to end, managing timelines, resources and stakeholder requirements, and run intake and prioritization with the leadership team.
• Reporting strategy: Assess reporting requirements across the enterprise, own the long-term reporting strategy, and translate it into operational plans aligned to business priorities and budget.
• Data integrity and platform operations: 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.
• Governance and risk: Operate a control framework that minimizes risk, establish a clear ownership model for Power BI artifacts, and adhere to Revance's Data Policy guidelines.

Requirements

Minimum Required:

• Bachelor of Science degree in business administration, computer science, statistics or another closely related field.

Preferred:

• Master's degree in business administration with a concentration in business intelligence.

• 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

• Experience delivering AI-assisted or natural language analytics (Power BI Copilot, Snowflake Cortex, or comparable LLM-based query interfaces) strongly preferred

• 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

• Life sciences, medical aesthetics or consumer health experience a plus

Company Summary:

Revance is a global company developing, producing, and distributing industry-leading, differentiated products across aesthetics, skincare, and therapeutics. Revance drives innovation beyond convention to offer treatment options for individuals across generations. The Company's vision is to redefine excellence in aesthetics, skincare, and therapeutics through science-powered innovation, with an unwavering commitment to its providers, patients, and consumers. Revance's award-winning products are the result of robust research and development, a cornerstone for the Company, driven by renowned scientists. For more information about Revance, please visit us at www.revance.com.

What Revance invests in you:

• 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!

This section of the job description is required by the American with Disability Act (ADA). The ADA requires that job descriptions reflect the physical and mental demands required to effectively perform the essential duties of the job. The ADA prohibits employers from discriminating against a "qualified individual with a disability" in all aspects of the employment relationship. A "qualified individual with a disability" is "an individual who meets the education, experience, skill, and other job-related requirements of a position held or desired, and who, with reasonable accommodation, can perform the essential functions of a specified job."

Revance is an Equal Opportunity employer. All qualified applicants will receive consideration for employment based on merit, without regard to race, color, religion, sex, national origin, disability, protected Veteran Status, or any other characteristic protected by applicable federal, state, or local law.