Data Analyst, Data & Quality Improvement

Position Summary

The Data Analyst at the Camden Coalition plays a key role in advancing the organization’s mission to improve healthcare delivery through data-driven insights. This role combines technical and analytic expertise to support a wide range of projects, including regional Medicaid initiatives and internal program evaluation.

The Data Analyst will work extensively with the organization’s Redshift-based data warehouse to transform and analyze complex healthcare datasets, including claims and health information exchange (HIE) data. They will partner with both technical and non-technical stakeholders to develop metrics, generate insights, and deliver actionable analysis through reports, dashboards, and data products.

Projects in this role involve working with complex, longitudinal healthcare data to answer applied questions that inform program design, policy, and care delivery. This includes constructing cohorts (e.g., delivery-based populations), analyzing patterns of healthcare utilization over time (such as outpatient, ED, and inpatient use), evaluating Medicaid populations to understand coverage continuity and engagement, and supporting program evaluations through outcome definition and comparison group design. The work often requires integrating data from multiple sources, developing logic to link events across time, and creating analytically useful datasets from imperfect data. Success in this role requires comfort with ambiguity and the ability to translate findings into clear, actionable insights for diverse stakeholders. The role also encourages thoughtful and responsible use of AI tools (e.g., for research, code development, and workflow support) to enhance productivity while maintaining strong standards for data privacy, accuracy, and reproducibility.

This role is ideal for someone who enjoys working with complex data systems, developing a deep understanding of underlying data models, and translating data into meaningful insights that inform decision-making and improve outcomes.

DUTIES and RESPONSIBILITIES

• Partner with clinical, program, and operational teams to define analytic questions, develop metrics, and deliver actionable insights
• Write complex SQL queries to extract, join, and restructure data from large relational datasets in a Redshift environment
• Build a strong understanding of the organization’s data model, including claims, clinical, and program data sources
• Conduct analyses using R and/or Python to support program evaluation, population health analytics, and quality improvement efforts
• Develop dashboards, visualizations, and reporting tools (e.g., Tableau) to communicate findings to diverse audiences
• Ensure data quality and validity through thoughtful QA, validation checks, and documentation
• Contribute to the design and development of scalable analytic datasets and reusable data assets
• Create and maintain clear documentation of data definitions, logic, and analytic processes
• Support a culture of continuous learning, collaboration, and improvement across the data and program teams

Knowledge, Skills and Abilities

• Strong proficiency in SQL and experience working with relational databases 
• Experience using R or Python for data analysis, including data manipulation and basic statistical analysis
• Experience with data visualization tools (Tableau preferred)
• Ability to work with large, complex, and imperfect datasets and translate them into usable analytic outputs
• Strong analytical thinking and problem-solving skills, with attention to detail
• Ability to clearly communicate technical concepts and findings to non-technical audiences
• Experience or familiarity with healthcare data (e.g., claims, EHR, or HIE data) is a plus
• Prior experience manipulating, processing, and extracting value from large and messy datasets a plus

Non-Essential Functions

• Attend relevant training as necessary to maintain professional certification and/or knowledge.
• Adhere to Coalition’s guidelines and ensure the appropriate handling of sensitive information.
• May work non-traditional hours based on operational needs and to meet the needs of the community.
• Completes special projects specific to the function of the department or as needed for the department.
• Other duties as assigned within the scope of position expectations.

Education & Experience

Experience: 1-3 years of Data Analysis experience, preferably in a healthcare environment

Education: Bachelor’s degree in a quantitative or related field (e.g., data science, statistics, public health, economics, computer science); advanced degree a plus

Competencies

Communication: Uses effective oral and written communication to facilitate inclusive conversations within our diverse communities, including Coalition colleagues, partners, and consumers, while demonstrating empathic listening.

Growth Mindset: Views growth as important for personal and professional development; seeks out opportunities to expand skills, even if change is required; demonstrates curiosity and eagerness to learn.

Problem Solving: Can identify challenges; formulates and implements solutions drawing on the expertise and input of others; Makes decisions effectively and responsibly.

Relationship Building: Helps colleagues as needed, views responsibilities as shared. Represents the organization among external stakeholders, influences audiences, and communicates in a sophisticated way about the organization’s vision and work.

Workload Management: Breaks down a work task/project into process steps and executes them effectively, adjusting course as needed. Uses self-management techniques in order to continuously improve own behaviour and performance.

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• While performing the duties of this job, the employee will frequently stand; walk and sit in an office environment
• There will be occasional lifting up to 15-20 lbs.

Work Environment

The work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• The noise level in the work environment is usually moderate.
• Although work is primarily conducted at the Camden office, you will occasionally be required to travel for events in other locations within New Jersey or in other states.  
• Position is a hybrid which requires a minimum of in-person attendance two days each week at the Camden, NJ office. Currently, the Camden Coalition workforce is in the office on Tuesdays & Wednesdays. 

Nothing in this position description restricts management’s right to assign or reassign duties and responsibilities to this job at any time.

EEO Statement

We are an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to race, creed, color, religion, gender (including pregnancy), national origin, nationality, ancestry, age, familial status, marital/civil union status, domestic partnership status, affectional or sexual orientation, gender identity and expression, atypical hereditary cellular or blood trait, genetic information, liability for military service, disability status (mental or physical, including perceived disability, and AIDS and HIV status), protected veteran status or any other characteristic protected by law.