Associate Director, Business Intelligence

Socket.dev; Nashville (TN); On-site; USD 140,000 - 200,000; Full time

Benefits offered by this job

Competitive compensation and annual-c2

Flexible PTO and holidays

Comprehensive healthcare benefits

Job summary

Revance seeks an Associate Director, Business Intelligence to lead enterprise reporting and analytics, including the Power BI platform, BI team, and self-service tools. You will partner with Data Engineering and stakeholders across commercial, finance, supply chain, and operations to set reporting standards and ensure trusted dashboards with polished UX reflecting Revance branding.

This is a hands‑on leadership role in a fast‑paced, entrepreneurial environment where much of the BI roadmap is

Qualifications

• BS degree in business administration, computer science, statistics or related field
• MBA with BI concentration preferred
• 7+ years in BI/analytics with hands-on Power BI
• 3+ years leading BI/analytics teams including offshore resources
• Experience delivering AI-assisted or natural language analytics (Power BI Copilot, Snowflake Cortex)
• Knowledge of BI/data warehouse environments (MS Fabric, Azure Synapse, Snowflake, Databricks)
• Expertise in data visualization and modeling in Power BI to answer diverse questions
• Broad Microsoft stack skills: SQL Server, Power BI, Power Apps, DAX, M, SSIS, Excel

Responsibilities

• Build and own self-service intelligence capabilities with natural language queries and visual responses
• Own Power BI platform quality, performance, and usability, drive adoption and retire low-value reports
• Design and govern a shared semantic layer with consistent definitions and certified measures
• Define and enforce BI reporting standards for templates, layout, color, and visualization
• Translate business requirements into intuitive, decision-ready reporting with stakeholders
• Lead a BI team spanning onshore/offshore, coach talent, set delivery standards
• Oversee multi-project BI delivery, manage timelines, resources, and priorities
• Shape the long-term reporting strategy aligned to business priorities and budget
• Ensure data integrity across BI reports and models; monitor performance and issue-troubleshoot
• Operate governance and risk controls with a clear ownership model for Power BI artifacts

Skills

Power BI

T-SQL

Data visualization

Leadership

Stakeholder management

Education

Bachelor of Science in business administration, computer science, statistics or related field

Master’s degree in business administration with BI concentration

Tools

Power BI

SQL Server

Power Apps

DAX

M (Power Query)

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.