FREE ACCESS
5,000–10,000 jobs/day
See all jobs on JobTailor
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Freelance Data Specialist, SQL, Python
WiredPeople, Inc.Freelance Data Specialist with expertise in SQL and Python for WiredPeople. Analyze WellSky platform, automate reporting, and create ERDs to support data-driven decisions.
Tech Stack
Tools & technologiesPandasPythonSQL
About the role
Key responsibilities & impact- 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.
Requirements
What you’ll need- 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.
Benefits
Comp & perks- 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.
ATS Keywords
✓ Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
SQLPythonEntity Relationship DiagramsData Dictionarydata extractiondata transformationdata formattingschema mappingcomplex joinswindow functions
Soft Skills
trainingcommunicationproblem-solvinganalytical thinking