About the role
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
Originally posted on Himalayas