Freelance SQL & Python Data Specialist

WiredPeople, Inc. • Tallahassee, FL

1d

About The Position

WiredPeople is seeking a highly skilled freelance Data Specialist with deep expertise in SQL, Python, and relational database architecture. Familiarity with the WellSky platform 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.

Requirements

• Advanced SQL & Python: 5+ years of experience writing complex SQL queries (CTEs, window functions, complex joins) and building Python data scripts (Pandas, SQLAlchemy, etc.).
• Database Architecture: Proven experience reverse-engineering databases, schema mapping, and creating ERDs using tools like Lucidchart, Visio, or DbSchema.
• Healthcare/Case Management Data: Prior experience working with EHR, EMR, or case management platforms.
• Business Acumen: 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.
• Compliance: Understanding of best practices for handling sensitive healthcare data and PII.

Nice To Haves

• Specific experience with the WellSky platform is highly preferred.

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.
• Process Automation: Utilize Python to automate data extraction, transformation, and formatting processes.
• Handoff & Training: 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.

What This Job Offers

• Career Level: Mid Level
• Education Level: No Education Listed