Job Title: Freelance Data Specialist (SQL & Python)
Location: Hybrid (Tallahassee, FL area) — Must be located within commuting distance for periodic in-person meetings.
Overview:
WiredPeople is seeking a highly skilled freelance Data Specialist with deep expertise in SQL, Python, and relational database architecture. Familiarity with the WellSky platform (or similar healthcare case management systems) will support our efforts to leverage available data to make informed organizational decisions.
This is not just a standard report-writing gig. We need a systems-thinker who can reverse-engineer and map the relationships within the WellSky database, build comprehensive Entity Relationship Diagrams (ERDs), and then leverage that map to build automated, scalable reports (such as linking clients to their respective caregivers) using SQL and Python. Because this is a hybrid role that requires collaboration with various teams, the ideal candidate must be local to the Tallahassee area and capable of attending in-person meetings.
Key Responsibilities
Database Discovery & Mapping: Analyze the underlying schema of the WellSky platform. Identify primary/foreign keys and map the complex relationships between clients, caregivers, services, and demographic data.
Architecture Documentation: Create clear, comprehensive Entity Relationship Diagrams (ERDs) and a functional Data Dictionary for future internal use.
Advanced Report Development: Translate business requirements into complex SQL queries to extract accurate datasets.
Technical Translation & Handoff: Develop clear Standard Operating Procedures (SOPs) and runbooks. Conduct in-person and virtual handoff training sessions with staff, ensuring you can clearly and effectively relay technical information and database concepts to team members who are not well-versed in code or tech.
Required Skills & Experience
Advanced SQL & Python (Required): 5+ years of experience writing complex SQL queries (CTEs, window functions, complex joins) and building Python data scripts (Pandas, SQLAlchemy, etc.).
Healthcare/Case Management Data (Highly Preferred): Prior experience working with EHR, EMR, or case managem