About this role

Analyze the underlying schema of the WellSky platform
Identify primary/foreign keys and map the complex relationships between clients, caregivers, services, and demographic data
Create clear, comprehensive Entity Relationship Diagrams (ERDs) and a functional Data Dictionary for future internal use
Translate business requirements into complex SQL queries to extract accurate datasets
Develop clear Standard Operating Procedures (SOPs) and runbooks
Conduct in-person and virtual handoff training sessions with staff

5+ years of experience writing complex SQL queries (CTEs, window functions, complex joins)
Building Python data scripts (Pandas, SQLAlchemy, etc.)
Prior experience working with EHR, EMR, or case management platforms
Specific experience with the WellSky platform is highly preferred
Exceptional ability to translate non-technical business needs into technical database requirements
Proven experience reverse-engineering databases, schema mapping, and creating ERDs using tools like Lucidchart, Visio, or DbSchema
Understanding of best practices for handling sensitive healthcare data and PII

Freelance Data Specialist, SQL, Python

Key skills