Survey Data & Reporting Analyst

SCH SERVICES INC • Full-time • Remote (United States) • $75.60k - $110k / year • 15h ago

This is a remote role; however, we only operate in the following states: AZ, CA, CO, CT, FL, GA, IL, ID, IN, MA, MI, MN, MO, NJ, NY, NC, OH, PA, SC, TX, VA, and WI.

SullivanCotter partners with health care and other not-for-profit organizations to understand what drives performance and improves outcomes by developing and implementing integrated workforce strategies. Using our time-tested methodologies and industry-leading research and information, we provide data-driven insights, expertise, and solutions to help organizations align business strategy and performance objectives – enabling our clients to deliver on their mission, vision, and values.

JOB SUMMARY

The Survey Data & Reporting Analyst sits within the Survey business unit at SullivanCotter. In this role, you will actively participate in survey data collection, data validation, benchmark and report creation, and analysis of various health care compensation surveys. Working with leadership, you will participate in initiatives that standardize technical processes and methodology enhancements.

PRIMARY ACCOUNTABILITIES

Participate in data cleaning processes across multiple phases for compensation and custom surveys utilizing in-house and statistical software; may also assist in process definition and training
Collaborate with analysts and survey managers to produce compensation and survey reports and analyses
Provide guidance and support to internal and external clients and survey participants regarding survey processes and analysis
Provide in-depth quality assurance to compensation reports per formatting, analysis, and content guidelines
Create and/or audit workflows, analyses, charts, and dashboards, using Alteryx, Databricks and Tableau.
Participate in the identification or improvement of existing workflows, automation or streamline opportunities, and build solutions
Assist with ad hoc survey reports, analyses, and projects
Collaborate with team members and management to create and standardize training materials for new and existing processes
Identify and define opportunities for efficiencies in day-to-day survey operations by leveraging software and programming solutions
Ensure compliance with deliverable reporting requirements by performing quality data audits and analysis.
Participate in cross-functional efforts for standardization and optimization
Lead complex reporting projects using Alteryx, Databricks, and Tableau with consideration for designing scalable solutions on the cloud
Build and refine data models that reduce technical debt and support efficient migration from legacy tools to modern cloud infrastructure.
Understanding of ETL processes and data warehousing best practices, with an eye towards data model integrity and performance optimization.
Independently collaborate and lead, with surveys team; the production of compensation survey reports
Conduct and train others in standard in depth data cleaning using in-house and statistical software
Assure reporting calculations and methodologies are executed in accordance to documented specifications as approved by the Survey Governance Committee
Oversee ad hoc analytics and one-off projects within the designated survey
Delve into data to identify discrepancies, patterns, and insights. Concisely present findings to multiple stakeholders; and identify/execute on solutions for streamlining the continuous improvement of data practices
Assist management with administrative duties (e.g., interviews, job descriptions, etc.)
Mentor and train more junior analysts

KNOWLEDGE, SKILLS AND ABILITIES

Minimum Required Qualifications

BA or BS in a related field or equivalent experience. Preferred education fields are finance, economics, statistical research, research methodology, or other like areas.
5+ years of knowledge and experience in statistical analysis, survey, or data analytics.
Technical knowledge and experience working with Excel, Word & PowerPoint
Programming experience with SQL
Experience interfacing with internal/external counterparts
Experience participating in / leading analytic projects
Experience creating standard operating procedures and other business documentation
Other skills and abilities:
- Proficiency in creating, summarizing, and presenting ideas or analytical findings in a business-friendly and user-friendly language
- Self-starter with demonstrated ability to successfully execute on or lead complex project deliverables in a very driven and changing organization.
- Ability to learn and individually contribute as required by each job level; a lead is an advanced-level contributor and recognized as a subject matter expert
- Regularly shows flexibility, adaptability, and the ability to work under tight deadlines or changing needs
- Organizational skills and ability to work independently. Consistently manage time and execute tasks per established deadlines in a high-pressure environment
- Able to respond to client inquiries quickly and concisely with high service level
- Consistently performs with a high degree of critical thinking, analytical foresight, and attention to detail
- Collaborative team-player, able to work in a virtual and matrixed team-based environment and develop and maintain relationships
- Able to consistently execute or lead multiple projects simultaneously and maintain high-quality work
- Excellent written and oral communication skills
- Mentors more junior analysts within the team and through cross-functional workgroups/initiatives

Preferred Qualifications

Experience with Alteryx, R or Python
Experience with Tableau or Power BI
Experience with Databricks or other cloud-based solutions
Experience with ETL processes
Experience with JSON
Experience with Azure DevOps
Knowledge of health care industry

BENEFITS AND PERKS

Competitive total compensation package
Medical and dental coverage at no premium cost for employees
401(k) and profit-sharing retirement plans
Flexible spending accounts
Generous paid time off (PTO)
Company-paid holidays
Gender-neutral parental leave
Bereavement and pet leave
Continuing education and professional accreditation sponsorship
Life and AD&D insurance
Short- and long-term disability
Employee assistance program
Mental health support program
Additional perks

Reflected below is the base salary range offered for this position. Actual salaries may vary depending on factors including but not limited to academic achievements, skills and experience. The range listed is just one component of the compensation package offered to candidates.

$75,600 - $110,000 annually

Our Values in Action: How We CARE
We live our values daily through four commitments:

Connect: Collaborate selflessly to support others, advance ideas, and solve problems using critical thinking.
Act: Bring integrity and respect to every interaction—no exceptions.
Reach: Commit to continuous learning and knowledge sharing that strengthens teams and clients.
Embrace: Foster inclusion and belonging so everyone can thrive and contribute.