Sr. Business Intelligence Developer

Verisma; United States; On-site; USD 120,000 - 180,000; Full time

Job summary

Verisma is seeking a Senior BI Developer to own the Power BI reporting environment, translating business requirements into robust reports, dashboards, and semantic models. The role sits at the intersection of SQL development and Power BI engineering, with responsibility for run activities, bugs, and audit-ready documentation.

The ideal candidate has strong Power BI and T-SQL experience, data modeling instincts, and a disciplined approach to maintaining a growing BI environment in a regulated

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 with semantic models, DAX, and RLS.
• Strong proficiency in T-SQL and Microsoft SQL Server (2016+), including production-scale optimization.
• Expert-level Power BI performance optimization (import mode, DirectQuery, composite models, aggregations, incremental refresh).
• Experience building and maintaining semantic data models with complex relationships and RLS.
• Understanding of relational DB design and dimensional modeling for BI workloads.
• Ability to own the full BI build lifecycle independently with minimal supervision.
• Experience defining BI standards, governance, and data quality programs.
• Mentorship experience and ability to review code/designs.
• Healthcare/regulatory data handling experience preferred.
• Proficiency with Azure data services and Power BI Dataflows; Python and dbt exposure beneficial.
• Travel up to 10%.

Responsibilities

• Design, develop, and maintain Power BI reports, dashboards, and semantic models.
• Create DAX measures, calculated columns, and data model relationships for accurate reporting.
• Configure and manage row-level security (RLS) in Power BI for data governance and HIPAA compliance.
• Optimize Power BI solutions for performance at scale (import/DirectQuery, aggregations, refresh).
• Own production BI environment: fix bugs, implement enhancements, ensure reliability and auditability.
• Lead end-to-end lifecycle for new Power BI reports from requirements to delivery and docs.
• Collaborate with stakeholders to clarify requirements and manage expectations.
• Write and maintain T-SQL queries, stored procedures, and views to support BI needs.
• Partner with SQL Developer on query optimization and data structure design.

Skills

Power BI development

T-SQL / SQL Server

Data modeling

HIPAA compliance

Stakeholder communication

Mentorship

CI/CD practices

Azure data services

Documentation

Cross-functional collaboration

Education

Bachelor’s degree in CS/IS/Data Analytics

Tools

Azure Synapse

Azure SQL

Azure Data Factory

Git

Job description

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