BI Developer II

Sound Physicians • ,

13d • $90,000 - $140,000 • Remote

About The Position

The BI Developer II is an experienced BI professional responsible for independently designing, developing, and optimizing Power BI solutions that support enterprise-wide reporting needs. This role is instrumental in building reusable semantic models, implementing complex DAX calculations, and ensuring adherence to governance and performance standards. Working closely with the BI Manager, data engineers, product managers, and stakeholders, the BI Developer 2 translates complex requirements into scalable, high-quality reporting solutions and mentors junior developers to elevate team capability.

Requirements

• Advanced SQL proficiency, including experience with complex joins, performance tuning, and working with large datasets from cloud-based platforms (e.g., Azure, Snowflake).
• Strong DAX skills, with the ability to design complex measures, apply time intelligence functions, and implement dynamic security (Row-Level Security).
• Experience designing and optimizing semantic models for performance, scalability, and governed self-service across a broad user base.
• Proficiency with Agile delivery practices, including sprint planning, backlog management, and iterative development.
• Knowledge of modern data platform components such as Azure Synapse, Databricks, or Snowflake, and how they integrate with BI solutions.
• Demonstrated ability to work directly with business stakeholders to gather requirements, clarify objectives, and deliver impactful solutions with minimal oversight.
• Strong attention to data accuracy, performance optimization, and visual clarity.
• Minimum Bachelor’s degree in Computer Science, Data Science, Data Informatics, Engineering, or equivalent field.
• 3-5 professional experience in BI development, with proven expertise in creating enterprise-grade Power BI dashboards and reports.

Nice To Haves

• Experience working with healthcare data preferred, particularly within clinical, operational, and revenue cycle domains, including familiarity with data types such as claims, encounters, provider rosters, patient records, and utilization metrics.

Responsibilities

• Independently design, build, and maintain advanced Power BI dashboards, reports, and semantic models to meet enterprise reporting needs.
• Translate complex business requirements into scalable, performant BI solutions that adhere to established governance, data modeling, and visual design standards.
• Develop and maintain advanced DAX calculations, incorporating time intelligence, conditional logic, and security filters to meet nuanced analytical needs.
• Optimize report and data model performance through indexing, query tuning, and best-practice modeling techniques.
• Implement and manage Row-Level Security (RLS) and other governance features to ensure secure, role-based data access.
• Collaborate with data engineers and governance teams to align BI assets with enterprise architecture, data quality standards, and compliance requirements.
• Mentor BI Developer 1 team members, providing technical guidance, code reviews, and skill development feedback.
• Document data models, report specifications, and development standards to ensure reusability, maintainability, and team alignment.
• Actively contribute to BI strategy by proposing new solutions, evaluating emerging tools, and championing continuous improvement in BI delivery processes.

Benefits

• Medical insurance, Dental insurance, and Vision insurance
• Health care and dependent care flexible spending account
• 401(k) retirement savings plan with a company match
• Paid time off (PTO) begins accruing immediately upon start date at a rate of 15 days per year, in accordance with Sound's PTO policy
• Ten company-paid holidays per year

What This Job Offers

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