Role Overview
ProCo is hiring a Data Analyst to own clean, reliable data for our Analytics team. You’ll pull data from healthcare systems, clean and reconcile it, segment it, and automate the manual work along the way.
What You Will Do
Extract and consolidate data from EHR, practice management, billing, payroll and GL systems using SQL and system exports. Join and consolidate multi-source data into single, reliable datasets. Clean, match and reconcile data to fix gaps, duplicates, mismatched codes and inconsistent definitions.
Why It Might Be a Fit
You will have direct coaching from the Director, hands-on exposure to our new data warehouse, and a path to Senior Data Analyst or Business Analyst.
Requirements
- 1–3 years of hands-on experience in a data analyst, reporting analyst or data role
- Solid SQL: multi-table joins, filtering and aggregations (CTEs and window functions a plus; we’ll teach the rest)
- Advanced Excel: pivot tables, XLOOKUP/INDEX-MATCH, Power Query
- An automation mindset, with examples of turning a manual process into a repeatable one
- Coachable and eager to learn, with high attention to detail
- Clear written and verbal communication about data and its limits
- Bachelor’s degree in information systems, data analytics, statistics, economics, finance, business or a related field
Benefits
- Medical, dental and vision insurance
- 401(k)
- Paid time off
To apply for this job please visit recruiting.paylocity.com.
Follow us on social media