BI Reports Analyst

Own the data products behind four federal Medicare collections the validated datasets and extracts that feed payment processes for roughly 17800 reporting organizations.

This position is contingent upon contract award.

The CMS Fee-for-Service Data Collection System (FFSDCS) is the mission system through which the Centers for Medicare & Medicaid Services collects statutorily mandated data from drug manufacturers clinical laboratories ground ambulance organizations and hospitals. You will own the reporting and analytics layer of that system: the validated datasets approved extracts and dashboards that turn raw submissions into something CMS analysts and downstream payment processes can rely on.

This is not a dashboard-decoration job. The outputs you build feed Medicare payment inputs so numerical accuracy and defensible data lineage matter more than visual polish. A significant part of the role is helping move the program off manual spreadsheet distribution and onto automated audited schema-versioned outputs.

• Four separate statutory collections: Average Sales Price drug manufacturer reporting Clinical Laboratory Fee Schedule private-payor reporting Ground Ambulance data collection and Off-Campus Hospital Outpatient acquisition data
• Approximately 17800 registered reporting users across those four collections
• High Value Asset FISMA Moderate application running in the CMS Cloud (AWS GovCloud)
• Platform stack: Java/Spring Boot microservices ReactJS Amazon Aurora Kubernetes
• Agile two-week sprints with production releases multiple times per month
• CMS-furnished tooling: JIRA GitHub Confluence Splunk New Relic Snyk SonarQube

Hybrid role. Baltimore Maryland area strongly preferred for proximity to the CMS Woodlawn campus. Eastern Time core hours in support of a Monday to Friday 9:00 AM to 6:00 PM ET service window. All work is performed within the United States.

• Design build and validate recurring and ad hoc reports extracts and data products from all four FFSDCS collections in CMS-approved structures and formats applying privacy and access controls to user-specific extracts
• Support modernization of output distribution: define data contracts with downstream consumers build automated extract-and-publish outputs and run parity validation proving automated outputs match legacy extracts before cutover
• Develop dashboards and self-service analytics in Amazon QuickSight covering operational performance submission-quality trends and program status reporting
• Build reporting-cycle exception analytics anomaly flags on statistically unusual submissions routed to subject matter expert review before data feeds downstream calculations with a human adjudicating every flag
• Write and tune complex SQL against Amazon Aurora; document data lineage transformations and validation logic
• Ensure report outputs conform to Section 508 accessibility standards

This position is contingent upon contract award. Candidates selected will receive a contingent offer and will begin the federal suitability and credentialing process which can take several weeks to several months. Employment begins only upon award and successful adjudication.

• U.S. work authorization and residence in the United States for at least three of the last five years a CMS background-investigation eligibility requirement
• Ability to obtain and maintain a CMS Public Trust suitability determination (e-QIP application fingerprinting favorable adjudication) prior to system access
• All work performed within the United States
• Completion of HHS/CMS security privacy and records-management training before performance and annually thereafter; signed non-disclosure agreement

• 5 years of business intelligence reporting or data analysis experience including expert-level SQL and delivery of production reporting for enterprise or government data systems
• Experience with data validation reconciliation and quality assurance in an environment where downstream consumers depended on numerical accuracy
• Hands-on experience with at least one modern BI platform Amazon QuickSight Tableau or Power BI and with documenting data definitions and lineage

Bachelors degree and 5 years of relevant experience.

• Healthcare pricing claims or rate-setting data experience
• Python or R for analysis
• AWS data services including Aurora Athena and Glue
• Section 508 document remediation
• Experience supporting federal data-governance requirements

Standard Employee Benefits.

50% Health Insurance Paid by Innosoft Paid Vacation 401K Match STD LTD and AD&D paid by Innosoft.

The salary range for this position is $100000 to $105000 annually. Actual compensation is determined by experience qualifications skills location and internal equity. This range reflects the anticipated base salary and does not include bonus benefits or other compensation.

Innosoft Corporation is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race color religion sex pregnancy sexual orientation gender identity national origin age physical or mental disability genetic information marital status protected veteran status or any other characteristic protected by applicable federal state or local law.

As a federal contractor Innosoft Corporation complies with its applicable equal employment opportunity and affirmative action obligations including Section 503 of the Rehabilitation Act of 1973 and the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA).

Reasonable accommodation. If you need a reasonable accommodation to complete any part of the application or interview process please contact and we will work with you.

Employment is contingent upon successful completion of a background investigation drug screening and reference checks in accordance with Innosoft Corporation policy.