BI Developer II - Amazon Quicksight at Hsag · LumiJobs
mid
$102k–$130k
H1B: no
Hsag BI Developer II at HSAG specializing in Amazon QuickSight dashboard development within the CMS environment. Design, develop, and maintain dashboards supporting healthcare quality improvement initiatives.
Responsibilities
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
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.
Bachelor’s degree in computer scienceFamiliarity with Tableau
Required
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.
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.
