This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more.
Role Description
This role involves designing, building, and maintaining advanced Excel-based tools, including:
• Complex formulas
• Pivot tables
• Dashboards
• Trackers
• Structured datasets
Additional responsibilities include:
• Developing and managing detailed project management trackers, calendars, and workplans to monitor deadlines, deliverables, dependencies, and responsibilities.
• Tracking tasks across multiple teams, ensuring accountability and timely completion of deliverables.
• Supporting federal and state policy initiatives through preparation and coordination of reports, submissions, and documentation for government agencies.
• Interpreting grant requirements, federal funding opportunities, contracts, and reporting standards to ensure compliance with funding requirements.
• Tracking grant milestones, deliverables, and reporting cycles.
• Collecting, cleaning, validating, and organizing large datasets to support reporting and analysis.
• Preparing clear status updates, trackers, and summaries for internal leadership and external stakeholders.
• Coordinating inputs from cross-functional teams and consolidating information for reporting and leadership review.
• Proactively identifying risks related to timelines, data quality, or compliance and escalating appropriately.
Qualifications
• Bachelor’s degree required.
• Minimum 6 years of experience working in health care policy or programs.
• 3–4 years of experience in a fast-paced consulting environment.
• 3–4 years of experience in project management.
• Advanced proficiency in Microsoft Office products, particularly Excel (complex formulas, pivot tables, dashboards, and structured data management).
• Strong written and verbal communication skills.
• Highly organized and detail-oriented, with demonstrated reliability in managing multiple projects and deadlines simultaneously.
• Understanding of federal and/or state grant management activities, including milestones, deliverables, and reporting cycles.
Requirements
• Master’s degree (ideal qualifications).
• Working knowledge of behavioral health policy.
• Experience in data science, quantitative research, implementation science, applied research, survey instrument design and implementation, and analysis.
• Experience with STATA and/or R Studio.
• Experience managing federal, state, or philanthropic grants for behavioral health initiatives and projects.
Benefits
• Generous leave program, including company holidays, vacation, sick, parental, and volunteer leave.
• Employer-matching 401(k) retirement plan.
• Health, vision, dental insurance with generous employer premium contributions, and Flexible Spending Account plans.
• Short and long-term disability insurance plans.
• Home office and cell phone stipends, charitable donation matching, and other benefits.
Location
Aurrera Health Group is a fully remote organization and candidates from all areas of the country are encouraged to apply. Occasional travel to company events, meetings, and client sites may be required, but the primary workstation for this position will be remote. As a national firm, the Aurrera Health Group team works across four time zones. This position must be available to work Pacific or Mountain Time hours.
Compensation
Aurrera Health Group offers competitive salaries based on industry standards and experience, skills, and responsibility. The starting pay range for this position is $80,000 to $100,000 per year, with an opportunity for an end-of-year bonus.
Why Join Us?
• Dedicated to Health Policy: Our core mission is improving health coverage and care quality.
• Meaningful Work: Create real, sustainable change in healthcare policy.
• Supportive Culture: Collaborate with inclusive professionals who share a passion for social impact.
Ready to Apply?
Please attach both of the following:
• Resume (required)
• Cover Letter (required)
Explain why you are interested in Aurrera Health Group. Describe how your experience aligns with—or is transferable to—this role.
Important: Applications lacking both a complete resume as described above, and a tailored cover letter will be considered incomplete and will not be reviewed.