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 data models with complex relationships, calculated tables, and row-level security
•Solid understanding of relational database design and dimensional modeling principles as they apply to BI and reporting workloads
•Demonstrated ability to own the full BI build lifecycle independently — from requirements gathering through delivery, documentation, and ongoing maintenance — with minimal supervision
•Proven experience defining or significantly contributing to BI standards, naming conventions, governance frameworks, or data quality programs
•Experience providing technical mentorship to other developers or leading code and design reviews
•Experience serving as a technical subject matter expert; able to represent the BI function in cross-functional discussions and defend design decisions to technical and non-technical stakeholders
•Demonstrated ownership of HIPAA, HITRUST, or regulated data-handling compliance within a BI or reporting layer; experience maintaining audit-ready documentation and access controls
•Strong written and verbal communication skills; able to document solutions clearly and translate technical findings for business stakeholders
•Experience writing and maintaining technical documentation including data dictionaries, report and measure definitions, and data lineage records
•Ability to manage competing priorities, work independently in a fast-paced environment, and engage directly with business stakeholders to clarify and deliver against reporting requirements
•Experience with Azure data services including Azure SQL, Azure Data Factory, Azure Synapse Analytics, Azure Blob Storage, or related services
•Experience with Power BI semantic models backed by Azure Synapse or Azure SQL
•Experience with version control (Git) and CI/CD practices for BI or database deployments (e.g., Azure DevOps)
•Background in healthcare technology or other regulated industries strongly preferred
•Experience with Power BI Dataflows for data preparation and transformation within the BI layer
•Exposure to Python for data preparation, automation, or scripting tasks
•Familiarity with SQL-based transformation tooling such as dbt or similar
•Experience with SSAS tabular models or multi-dimensional cubes
•Microsoft Power BI Data Analyst (PL-300) certification preferred
•Proficiency using AI tooling to accelerate development, documentation, and analysis work
•Willingness to travel up to 10% of the time