Sr. Business Intelligence Developer

Senior Business Intelligence Developer Summary of Position: 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. Duties & Responsibilities: • 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 Minimum Qualifications: • Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field, or equivalent work experience • 5+ years of hands-on Power BI development experience, including semantic model design, DAX authoring, report and dashboard development, and row-level security implementation • Strong proficiency in T-SQL and Microsoft SQL Server (2016+), including stored procedures, views, and query optimization at production scale; SQL Server 2019 experience strongly preferred • Expert-level Power BI performance optimization, including import mode, DirectQuery, composite models, aggregations, and incremental refresh • Deep experience building and maintaining semantic ...