The Senior Business Intelligence (BI) Developer will own the day-to-day development and maintenance of Verisma's Power BI reporting environment, serving as the primary builder and steward of our business intelligence solutions. This role sits at the intersection of SQL development and Power BI engineering, responsible for translating business requirements into performant, accurate, and compliant reports and dashboards. The BI Developer will take primary ownership of "run" activities: resolving report bugs, maintaining and enhancing existing solutions, creating new reports, working with stakeholders and end users, and ensuring all BI assets are well-documented and audit-ready. The ideal candidate brings solid Power BI and T-SQL experience, strong data modeling instincts, and the discipline to maintain a growing BI environment in a regulated healthcare setting. This person will work closely with the Director of Data Engineering, the Data Engineering team, and business stakeholders to ensure our reporting layer keeps pace with a rapidly growing business. As the team and data platform mature, this role will increasingly contribute to upstream data engineering concerns, including the Azure-based data stack.
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
Partner with the SQL Developer on query optimization, indexing, and data structure design to ensure reporting performance at scale
Define and enforce BI standards, naming conventions, semantic model design patterns, and governance frameworks as the team and data platform mature
Own the data quality program within the BI layer: establish monitoring, surface anomalies, drive resolution, and maintain data trust across reporting assets
Lead the integration of Power BI solutions with the Azure data stack, including Azure Synapse, Azure SQL, and Azure Data Factory, as the platform matures
Serve as the BI subject matter expert in cross-functional technical discussions, architecture reviews, and data platform planning
Provide technical mentorship and guidance to Associate and mid-level BI developers; lead code and design reviews for reporting and data layer changes
Operate as a senior individual contributor: manage own workload and project delivery independently; escalate architectural decisions and cross-team dependencies to the Director of Data Engineering
Create and maintain comprehensive documentation including report documentation, data dictionaries, field definitions, measure libraries, and process flows
Document data lineage and business logic embedded in reports, semantic models, and supporting SQL objects
Ensure all reporting solutions comply with HIPAA, HITRUST, and SOC 2 requirements for PHI data handling and access governance; maintain audit-ready documentation and access control records
Perform other duties, as assigned, to ensure effective operation of the department and the Company
Live by and promote Verisma Core Values