Sr. Business Intelligence Developer

About the Role

The role will involve working closely with the Director of Data Engineering, the Data Engineering team, and business stakeholders to ensure that the reporting layer keeps pace with the company's rapid growth. As the team and data platform mature, the Senior Business Intelligence Developer will be expected to contribute to upstream data engineering concerns, including the Azure-based data stack.

What You Will Do

• Design, develop, and maintain Power BI reports, dashboards, and semantic models that support business operations and decision-making
• Build and maintain DAX measures, calculated columns, and data model relationships to ensure accurate, performant reporting
• Configure and manage row-level security (RLS) within Power BI to enforce data access governance and HIPAA compliance
• Optimize Power BI solutions for performance at scale, including appropriate use of import mode, DirectQuery, composite models, aggregations, and incremental refresh
• Take primary ownership of the production BI environment: independently resolve report bugs and data discrepancies, manage enhancements, and maintain the reliability and accuracy of all BI assets
• Develop additions and enhancements to existing reports based on evolving business requirements
• Lead the full build lifecycle for new Power BI reports and dashboards — from requirements gathering and stakeholder alignment through delivery and documentation
• Work directly with business stakeholders and end users to clarify requirements, manage expectations, and deliver solutions without requiring hand-holding
• Write and maintain T-SQL queries, stored procedures, views, and functions to support reporting and BI needs

What We Are Looking For

• 5+ years of experience in Business Intelligence development, with a focus on Power BI and T-SQL
• Strong data modeling instincts and experience with data warehousing and ETL processes
• Excellent problem-solving skills and attention to detail
• Ability to work independently and collaboratively as part of a cross-functional team
• Strong communication and interpersonal skills
• Experience with Azure-based data stacks, including Azure Synapse, Azure SQL, and Azure Data Factory
• Knowledge of HIPAA and HITRUST compliance requirements

Nice to Have

• Experience with other BI tools, such as Tableau or QlikView
• Knowledge of machine learning and predictive analytics
• Certification in Power BI or T-SQL development

Benefits and Perks

• Competitive salary and benefits package
• Opportunity to work with a rapidly growing company in the healthcare industry
• Collaborative and dynamic work environment
• Professional development and training opportunities
• Flexible remote work arrangements
• Access to the latest tools and technologies

• Develop a strong portfolio that showcases your Power BI and T-SQL development skills, including examples of reports, dashboards, and data models you've created
• Be prepared to walk the interviewer through your problem-solving process and how you approach data modeling and BI development
• Highlight your experience with data governance and compliance, particularly in regards to HIPAA and HITRUST
• Show a willingness to learn and adapt to new technologies and tools, such as Azure-based data stacks
• Don't be afraid to ask questions during the interview process, such as what the company's data strategy is and how the BI team contributes to it
• Research the company's culture and values to ensure you're a good fit, and be prepared to discuss your own values and motivations