Freelance SQL & Python Data Specialist at WiredPeople, Inc. | Torre
Freelance SQL & Python Data Specialist
Report
warning

Heads-up

The job you’re trying to post already exists in Torre:

WiredPeople, Inc.

Freelance SQL & Python Data Specialist

WiredPeople, Inc.
Emma
Emma
You'll architect critical data insights, automating scalable reports to drive informed organizational decisions.
Emma highlights
This highlight was written by Emma’s AI. Ask Emma to edit it.
Freelance
Recurrent
Provide your expected compensation while applying
location_on
Remote (anywhere)
Match
skeleton-gauges
You have opted out of job matches in .
To undo this, go to the 'Skills and Interests' section of your preferences.
Review preferences
Shared by
Emma of Torre.ai
 about 10 hours ago

Requirements and responsibilities

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 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 Key ResponsibilitiesDatabase 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.Required Skills & ExperienceAdvanced 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. Specific experience with the WellSky platform is highly preferred.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 P
Closes in:
0
days
0
hours
0
min
0
sec
Optionally, you can add more information later (benefits, pre-screening questions, etc.)

Thank you

Thank you

check_circle

Payment confirmed

Torre Hunt

Torre Hunt

A member of the Torre team will contact you shortly

In the meantime, continue adding information to your job opening.