BI Developer II - Amazon Quicksight

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.