Data Analyst - Medicare/Medicaid

About A1M

A1M Solutions is a woman-owned small business driven by the aspiration to provide value to our customers, employees, partners, and community while remaining aligned to our guiding principles of foundational values, deliberate focus, and empathetic connection.

A1M’s mission is to preserve and improve government healthcare programs that are lifelines for underserved people in the United States, including people in poverty, elderly people, members of ethnic and racial minorities, immigrants, and refugees. We look for projects with nation-wide impact at the intersection of policy, data, and user experience design.

Besides building useful and usable digital services, A1M helps teams improve their agile, user-centered design practices – or helps them get started. Our goal is not just to build sustainable public services, but also to leave our teaming partners and customers more skilled and more confident in the future.

Role Overview

A1M Solutions is seeking a Data Analyst with strong experience working with large healthcare datasets—particularly CMS data, Medicare Part B and Part D, and the Integrated Data Repository (IDR). This role focuses on performing complex data extraction, analysis, and interpretation to support a federal healthcare client’s program integrity, evaluation, and operational decision-making needs.

The ideal candidate brings deep analytical expertise, strong SQL and Python skills, and a consultative mindset. You will work closely with auditors, investigators, evaluators, product teams, and other stakeholders to translate business questions into structured analyses and deliver clear, actionable insights.

Key Responsibilities

• Conduct ad hoc analytics related to prescription drugs, Durable Medical Equipment (DME), and other Medicare/Medicaid program areas.
• Build complex SQL queries to access, extract, and analyze data from large and complex data systems, including CMS IDR.
• Transform, cleanse, and validate datasets using SQL or Python.
• QA code and analytical outputs developed by team members.
• Develop a deep understanding of client business objectives by eliciting and analyzing requirements.
• Translate business questions into structured analytical approaches.
• Present findings clearly to both technical and non-technical stakeholders.
• Document analytical processes, methodologies, and outcomes.
• Demonstrate understanding of relational databases, data architecture, and data modeling.
• Create conceptual models, entity relationship diagrams, and business process visualizations.
• Apply basic dashboarding and data storytelling principles using tools such as Tableau or Power BI.
• Leverage subject matter expertise in Medicare, Medicaid, and healthcare analytics.
• Maintain coding standards, accuracy, and attention to detail.
• Apply Agile values and practices when collaborating with teams.
• Active participation in client virtual meetings—including being on camera—is an essential function that helps strengthen trust and open communication.

Qualifications Required

• Bachelor’s degree.
• 5+ years of experience in IT, data analysis, or a related field.
• Prior experience working with CMS data, including CMS IDR, Medicare Part B & Part D.
• Intermediate to advanced SQL and Python skills.
• Experience using data visualization tools (e.g., Tableau, Power BI).
• Strong analytical and problem-structuring skills.
• Excellent verbal and written communication.
• Ability to obtain and maintain Public Trust clearance.
• Must reside and have worked in the United States for 3 of the past 5 years.
• Must have permanent U.S. work authorization.
• Must reside outside New York State.
• Flexibility to collaborate with partners primarily operating in Eastern Time.

Preferred

• Experience with cloud analytics platforms (Google Cloud, AWS, Azure).
• Knowledge of statistics or experience with statistical analysis.
• Experience helping clients make data-driven decisions.
• Intermediate experience with Excel and PowerPoint.

This is a full-time, remote position.

The project-based rate compensation will range from $95,000- $110,000 depending on experience.

Equal Employment Opportunity

A1M Solutions is building a culturally diverse and pluralistic organization committed to working in a multicultural environment where differences are valued and respected.  Women, people of color, LGBTQ+ individuals, people with disabilities, members of ethnic minorities, foreign-born residents, and veterans are strongly encouraged to apply.

A1M Solutions is an equal-opportunity employer. Applicants will not be discriminated against because of race, color, creed, sex, sexual orientation, gender identity or expression, age, religion, national origin, citizenship status, disability, ancestry, marital status, veteran status, medical condition or any protected category prohibited by local, state or federal laws.

As a federal contractor and subcontractor, we certify that we do not operate any programs promoting DEI that violate any applicable Federal anti-discrimination laws.

EEOC: Know Your Rights: Workplace Discrimination is Illegal - Optimized for Screen Readers