Freelance Data Specialist, SQL, Python

Job not on LinkedIn

🕒 3 days ago

Apply Now

Find Similar Remote Jobs

Receive Emails For Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

WiredPeople, Inc.

WebsiteLinkedInAll Job Openings

11 - 50 employees

🎯 Recruiter

🔒 Cybersecurity

🏛️ Government

Recruitment • Cybersecurity • Government

WiredPeople, Inc. is a company that specializes in providing smart and flexible strategies for talent procurement in the public health, IT, and cybersecurity sectors. They connect teams in need of extra personnel with highly skilled professionals ready to join their workforce, addressing the specific challenges faced by public health organizations, IT departments, and cybersecurity firms. WiredPeople offers fast and adaptable hiring solutions, particularly beneficial for government agencies looking to access exceptional talent in these industries.

📋 Description

• 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

• 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

• 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.