BI Developer II - Amazon Quicksight

Health Services Advisory Group, Inc. (HSAG); United States; On-site; USD 90,000 - 120,000; Full time

Job summary

Health Services Advisory Group, Inc. (HSAG) is seeking a Business Intelligence (BI) Developer II to design, implement, and support dashboards in Amazon QuickSight within the CMS data environment.

The role includes validating data, creating datasets, and delivering insights to QIO stakeholders. You will collaborate with analysts, data scientists, and CMS personnel, with opportunities to use Tableau for other visual analytics tasks and to contribute to end-to-end ETL pipelines in SQL Server

Qualifications

• 3+ years designing and maintaining visualization solutions in Amazon QuickSight
• Experience with Tableau dashboard development
• 3+ years ETL in a Microsoft SQL Server environment
• 3+ years of data warehousing experience
• Experience gathering and refining requirements and interviewing business users
• Experience with SQL Server, SSIS, SSAS, Power BI, and Databricks is preferred

Responsibilities

• Serve as an integral member of HSAG’s Data Science & Advanced Analytics division
• Work with HSAG staff, CMS stakeholders, and customers to elicit and refine dashboard requirements
• Design, develop, test, deploy, document, and maintain Amazon QuickSight analyses and dashboards in CMS environment
• Develop intuitive QuickSight navigation, filters, calculations, and role-views
• Apply data validation and quality-control to reflect specifications
• Maintain dashboard documentation and controlled promotion of changes
• Create Tableau dashboards for other HSAG work as needed
• Design proof-of-concept BI visualizations and advanced dashboards
• Validate data sources and perform ad hoc analyses
• Develop end-to-end ETL solutions using dynamic SQL for large datasets
• Architect complex business rules in SQL to meet contract specs
• Lead data quality by developing SQL-based validation and automated corrections
• Document technical dashboards, data mappings, ETL diagrams, and guidance
• Provide advanced support for QuickSight dashboards, data access, and functionality
• Oversee UAT to ensure loads and dashboards meet requirements
• Manage dashboard and data projects lifecycle to align with schedules and security
• Collaborate with HSAG departments to support research issues
• Stay current on QuickSight and related tech and communicate advancements
• Communicate technical topics through docs, demos, and presentations

Skills

Amazon QuickSight

Tableau

SQL development

ETL pipelines

Data warehousing

Dashboard design

Data analysis

Education

Bachelor’s degree in CS or related field

Master’s degree preferred

Tools

Microsoft SQL Server

SSIS

SSAS

Power BI

Databricks

Job description

Are you passionate about improving the quality of healthcare?

Are you ready to leverage your talents to make healthcare better for everyone?

Do you want the opportunity to give back to your community?

Do you want to have fun at work?

Then join the growing team at Health Services Advisory Group (HSAG) that is transforming the delivery of healthcare in the United States!

Summary

HSAG is nationally recognized as an industry leader in healthcare data analysis, measure development, and survey research. We are seeking a Business Intelligence (BI) Developer II with hands‑on Amazon QuickSight expertise to design and deliver dashboards supporting HSAG’s Quality Improvement Organization (QIO) contract within the secure Centers for Medicare & Medicaid Services (CMS) environment. Familiarity with Tableau is also desired to support other HSAG visual analytics work.

The BI Developer II position benefits from HSAG’s commitment to developing future leaders in healthcare data science and quality improvement. Under the direction of the Business Intelligence Architect and other senior DSAA leaders, this position collaborates directly with analysts, data scientists, project leaders, and QIO staff. The role’s primary focus is creating, enhancing, and supporting QIO dashboards in Amazon QuickSight, with opportunities to use Tableau for other visual analytics initiatives.

Description

The BI Developer II is a key contributor to federal analytic work supporting HSAG’s Quality Improvement Organization (QIO) contract. The primary responsibility of this role is to create, enhance, validate, document, and maintain dashboards in Amazon QuickSight within the secure CMS data environment. The successful candidate must be able to translate business and contract requirements into clear, accurate, and actionable dashboard experiences for QIO stakeholders.

Data incorporated into these dashboards may include, but are not limited to:

• medical and prescription drug claims
• skilled nursing facility (SNF) home minimum data set (MDS) data
• case review
• facility self-reported
• demographics
• QIO operational data
• publicly reported data (e.g., Care Compare)
• survey and certification data

Essential Competencies, Duties And Responsibilities

• Serve as an integral member of HSAG’s Data Science & Advanced Analytics division
• Work with HSAG staff, CMS stakeholders, and other customers to elicit, document, and refine dashboard requirements
• Design, develop, test, deploy, document, and maintain Amazon QuickSight analyses, datasets, reports, and multi‑level dashboards in the CMS environment
• Develop efficient, intuitive QuickSight dashboard navigation, drill‑downs, filters, parameters, calculations, and role‑appropriate views
• Apply data validation and quality‑control procedures to confirm that dashboard measures, calculations, labels, and visualizations accurately reflect approved specifications
• Maintain dashboard version documentation and support controlled promotion of dashboard changes in accordance with CMS and HSAG processes
• Create and maintain Tableau dashboards or visualizations for other assigned HSAG work, as needed
• Design and implement proof‑of‑concept solutions and advanced BI visualizations, applying effective data visualization and dashboard usability practices
• Use approved data sources and reporting tools to validate dashboard measures, investigate data issues, and support ad hoc analysis
• Design, develop, and automate end‑to‑end ETL solutions using dynamic SQL to perform file validation, manage staging‑to‑production pipelines, and prepare large‑scale datasets for QuickSight dashboards and other BI solutions
• Architect and implement complex business rules within the SQL environment to ensure data transformations meet rigorous contract and project specifications
• Lead data quality management by developing SQL‑based validation frameworks and implementing automated corrective actions to resolve data anomalies
• Author and maintain comprehensive technical documentation, including dashboard documentation, data definitions, data mapping, ETL workflow diagrams, user guidance, presentations, and related project materials that help ensure data are secure, accurate, and accessible
• Provide advanced technical support and troubleshooting to HSAG staff, stakeholders, providers, and contractors regarding QuickSight dashboards, data, access, and functionality, as well as data gathering, database design, and dissemination activities
• Oversee the technical User Acceptance Testing (UAT) process to validate that data loads, dashboards, and system outputs meet customer and budget requirements; document findings, resolve defects, and support production readiness for dashboards
• Manage the full dashboard and data project lifecycle, ensuring timely delivery of high‑quality products that align with project schedules, QIO contract requirements, security expectations, and milestones
• Collaborate with other HSAG departments to troubleshoot project activities and provide data support services for complex customer research issues
• Stay current on emerging QuickSight capabilities, database structures, ETL technologies, and analytic methodologies, communicating relevant advancements to the team to improve internal data infrastructure
• Communicate complex technical and analytic topics clearly through written documentation, demonstrations, and oral presentations

Education and/or Experience

• Bachelor’s degree in computer science, computer information systems, or a quantitative discipline; Master’s degree preferred
• At least 3 years of hands‑on experience designing, developing, and maintaining visualization solutions in Amazon QuickSight is required. Candidates must demonstrate practical QuickSight expertise, including experience creating analyses, dashboards, calculated fields, filters, parameters, and interactive visualizations
• Familiarity with Tableau dashboard development is required to support additional HSAG visual analytics work; hands‑on Tableau development experience is preferred
• At least three (3) years of experience with ETL processes in a Microsoft SQL Server environment is required
• At least three (3) years of data warehousing experience is required
• Experience gathering and refining requirements and interviewing business users to understand and document data requirements is required
• Strong attention to detail and experience documenting business and technical requirements based on user interviews are required
• Experience with Microsoft SQL Server, SSIS, SSAS, Power BI, and Databricks is preferred

Other Qualifications

• Experience working with healthcare data, Medicare data, claims data, quality improvement data, or other regulated data is strongly preferred
• Proficient in Microsoft Word and Excel
• Excellent verbal and written communication skills
• Ability to handle several projects simultaneously and work with multiple teams

CMS Access and Security Requirements

This position requires access to CMS data systems and secure computing environments. As a condition of performing assigned QIO work, the selected candidate must successfully complete all required CMS vetting, identity verification, background investigation, security, privacy, and access‑authorization processes applicable to the role.

The employee must maintain eligibility for CMS system access, complete required security and privacy training, comply with CMS and HSAG policies for handling sensitive information, and promptly provide documentation or information needed to establish and retain access.

Employment in the role and assignment of CMS‑related duties are contingent upon obtaining and maintaining the required CMS approvals and system access. Inability to obtain or retain required access may affect the individual’s ability to perform the essential functions of the position.

Work Environment

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Disclaimer

This is not necessarily an exhaustive list of all responsibilities, skills, duties, requirements, efforts or working conditions associated with the position. While this is intended to be an accurate reflection of the current position, management reserves the right to revise the position or to require that other or different tasks be performed when circumstances change (e.g., emergencies, changes in personnel, work load, rush jobs requiring non‑regular work hours, or technological developments).

HSAG is an EEO Employer of Veterans protected under Section 4212.

If you have special needs and require assistance completing our employment application process, please feel free to contact us.

EOE M/F/Veteran/Disability

We may use artificial intelligence ("AI") tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.