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.
Utilize Python to automate data extraction, transformation, and formatting processes.
Develop clear Standard Operating Procedures (SOPs) and runbooks.
Conduct a handoff training session with staff to ensure they can independently execute and maintain the reports you build.

5+ years of experience writing complex SQL queries (CTEs, window functions, complex joins) and building Python data scripts (Pandas, SQLAlchemy, etc.)
Proven experience reverse-engineering databases, schema mapping, and creating ERDs using tools like Lucidchart, Visio, or DbSchema.
Prior experience working with EHR, EMR, or case management platforms.
Specific experience with the WellSky platform is highly preferred.
Ability to translate non-technical business needs (e.g., "We need to see which caregivers are assigned to which clients in this county") into technical database requirements.
Understanding of best practices for handling sensitive healthcare data and PII.

WiredPeople provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics.

Freelance Data Specialist, SQL, Python

Key skills