Business Intelligence Developer

Role Description

The Business Intelligence Developer is a hands-on business intelligence professional responsible for leading the design, development, and optimization of enterprise-grade dashboards and reporting solutions. This role serves as a subject-matter expert in Power BI and partners closely with BI Engineers and data platform teams to ensure scalable, well-modeled data structures that support business intelligence tools and performance at scale. The role blends deep technical expertise with strong consulting and advisory skills, helping shape both front-end visualization standards and back-end data modeling decisions.

Essential Functions

• Power BI Development & Visualization
  • Lead the design and development of advanced Power BI reports and dashboards for internal stakeholders and/or clients.
  • Serve as a Power BI subject-matter expert, advising on best practices for DAX, data modeling, Power Query, and visualization design.
  • Develop complex DAX measures and calculations to support analytical use cases.
  • Optimize report performance, dataset size, refresh strategies, and semantic models.
  • Establish and promote visualization and dashboard standards across teams.
• Data Modeling & Engineering Partnership
  • Partner closely with BI Engineers and data platform teams to:
    • Advise on data structures, dimensional models, and semantic layers.
    • Ensure data models are optimized for BI consumption and performance.
    • Identify gaps or inefficiencies in source data that impact reporting.
    • Translate reporting requirements into clear data model and source table recommendations.
    • Help bridge the gap between business requirements and technical data design.
• Cross-Tool & Analytical Support
  • Create and maintain both technical and design standards for business intelligence products.
  • Contribute to decision-making around tool usage, migration, or standardization, where applicable.
• Stakeholder Engagement
  • Partner with analytics leaders and business stakeholders to define requirements and success criteria.
  • Review and validate analytical outputs for accuracy, clarity, and business relevance.
  • Support UAT, dashboard certification, training, and knowledge transfer.

Qualifications

• Bachelor’s degree in a quantitative or technical field (Analytics, Computer Science, Information Systems, etc.).
• 5+ years of experience in business intelligence, analytics, or data visualization.
• Experience supporting executive or client-facing dashboards.
• Expert-level experience with Power BI, including:
  • Advanced DAX.
  • Data modeling and semantic layers.
  • Power BI Service administration concepts.
• Strong SQL skills and experience working directly with enterprise data warehouses.
• Demonstrated experience collaborating with BI Engineers or data engineers on data modeling decisions.
• Experience working in Snowflake, Azure, Databricks, or similar cloud data platforms.
• Ability to influence technical design without direct ownership of data pipelines.
• Intermediate to advanced experience in Tableau (development or strong comprehension) strongly preferred.
• Experience in healthcare, life sciences, or regulated data environments strongly preferred.

Benefits

• The potential base pay range for this role, when annualized, is $84,600.00 - $211,600.00.
• The actual base pay offered may vary based on a number of factors including job-related qualifications such as knowledge, skills, education, and experience; location; and/or schedule (full or part-time).
• Dependent on the position offered, incentive plans, bonuses, and/or other forms of compensation may be offered, in addition to a range of health and welfare and/or other benefits.