BI Developer II – Amazon Quicksight

This is a fully remote position, open to applicants in United States.

📋 Description

• Design, develop, test, deploy, document, and maintain analyses, datasets, reports, and multi-level dashboards using Amazon QuickSight within a secure CMS environment.

• Convert business and contract requirements into clear, precise, and actionable dashboard experiences for QIO stakeholders.

• Gather, document, and refine dashboard requirements in collaboration with HSAG staff, CMS stakeholders, and clients.

• Create navigation, drill-downs, filters, parameters, calculations, and role-specific views for QuickSight dashboards.

• Implement data validation and quality-control procedures for dashboard metrics, calculations, labels, and visualizations.

• Keep documentation of dashboard versions and support the controlled promotion of changes to dashboards.

• Build and manage Tableau dashboards or visualizations for other HSAG initiatives.

• Develop proof-of-concept solutions and sophisticated BI visualizations.

• Verify dashboard metrics, investigate data discrepancies, and assist with ad hoc analysis.

• Design, develop, and automate comprehensive ETL solutions using dynamic SQL.

• Apply complex SQL business rules and establish SQL-based data-quality validation frameworks.

• Create technical documentation, including dashboard details, data definitions, data mappings, ETL workflows, user guidance, and presentations.

• Offer technical support and troubleshooting for dashboards, data, access, functionality, database design, and dissemination activities.

• Supervise technical User Acceptance Testing, document outcomes, address defects, and ensure production readiness.

• Manage the entire lifecycle of dashboard and data projects to adhere to schedules, QIO contract stipulations, security requirements, and milestones.

• Collaborate with HSAG departments to troubleshoot project-related activities and support intricate customer research inquiries.

• Remain updated on developments in QuickSight, databases, ETL, and analytics, and communicate relevant advancements.

• Present technical and analytical topics through documentation, demonstrations, and presentations.

⛳️ Requirements

• Bachelor’s degree in computer science, computer information systems, or a quantitative field.

• A minimum of 3 years of practical experience in designing, developing, and maintaining visualization solutions in Amazon QuickSight.

• Proficient in Amazon QuickSight, including analyses, dashboards, calculated fields, filters, parameters, and interactive visualizations.

• Familiarity with Tableau dashboard development.

• At least 3 years of experience with ETL processes in a Microsoft SQL Server environment.

• Minimum of 3 years of experience in data warehousing.

• Experience in gathering and refining requirements and interviewing business users to comprehend and document data needs.

• Strong attention to detail with experience in documenting business and technical requirements based on user interviews.

• Proficient in Microsoft Word and Excel.

• Exceptional verbal and written communication skills.

• Capability to manage multiple projects simultaneously and collaborate with various teams.

• Successful completion of required CMS vetting, identity verification, background investigation, security, privacy, and access-authorization processes.

• Ability to maintain eligibility for CMS system access and complete necessary security and privacy training.

• Compliance with CMS and HSAG policies regarding the handling of sensitive information.

• Master’s degree is preferred.

• Hands-on experience in Tableau development is preferred.

• Experience with Microsoft SQL Server, SSIS, SSAS, Power BI, and Databricks is preferred.

• Experience in healthcare, Medicare, claims, quality improvement, or other regulated data is strongly preferred.

🏝️ Benefits

• Full-time salaried exempt position.

• Remote work arrangement.

• Opportunity to contribute to healthcare improvements and give back to the community.

• Opportunities for professional growth and development of future leaders in healthcare data science and quality improvement.