Freelance Data Specialist, SQL, Python
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Freelance Data Specialist with expertise in SQL and Python for WiredPeople. Analyze WellSky platform, automate reporting, and create ERDs to support data-driven decisions.
Responsibilities:
- 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.
Similar Jobs
Lead Backend Developer
Backend Lead Developer for a personalization engineering team at Serverless Guru. Designing backend architecture and building cloud-native APIs for large enterprise hospitality platform.
Senior Software Engineer, Ruby, React
Senior Software Engineer at Software Mind focusing on designing scalable and high-performing software solutions. Collaborating with a multicultural team to deliver quality technology solutions.
Java Back-End Developer, Junior
Java Back-End Developer responsible for back-end coding and collaboration. Join Compass UOL's mission in AI transformation.
Java Backend Developer, Junior
Java Backend Developer building REST APIs and supporting existing features at Compass UOL. Focusing on technical solutions, code quality, and collaboration in the team.
Staff Backend Platform Engineer
Senior Backend Platform Engineer designing and operating production backend systems powering Conversica's next-gen AI platform, focusing on integrations, data ingestion, and messaging infrastructure.
Mid-level Java Developer – Support
Software Developer handling support and issue resolution for insurance systems in Brazil. Collaborating with a qualified team to ensure efficient operations and ongoing system stability.
Senior Backend Software Engineer, Node.js, Java
Senior Backend Software Engineer developing backend services and APIs using Node.js and Java. Aiming for high-quality standards and efficiency in contact center environments.
Senior Full-Stack Developer, .Net, React
Senior Full-Stack Developer designing and maintaining web solutions for a German automotive manufacturer. Collaborating with teams to deliver scalable and secure applications in cloud environments.
Senior Revit API Developer
Revit API Developer developing Revit add-ins and desktop applications integrating with the Stratus platform for MEP contractors. Working on production-ready tools and collaborating within an AI-forward engineering team.
Senior Full-Stack Developer – Python, React
FullStack Developer at Neogrid focusing on software solutions for retail and industry. Leading projects using Python and React with a commitment to diversity.
Senior Software Engineer – React, Node.js
Senior Software Engineer responsible for shipping outcomes across full stack using React, Node.js, and Python services. Capture business objectives and mentor teams while developing responsive, accessible interfaces.
Senior Software Engineer, Elixir
Senior Software Engineer in a tech-driven company focusing on Elixir and AI-assisted workflows. Own complete project outcomes and mentor teams while ensuring customer trust through design and implementation.
Senior C++ Engineer
Senior C++ Engineer developing SONiC software for large data centers at Arista Networks. Collaborating on networking solutions and mentoring junior engineers in a dynamic environment.
Mid-Level Intelligent Automation Analyst – Python, Generative AI, Autonomous Agents
Analista de Automação Inteligente desenvolvendo automações de processos com Python e IA na Experian. Participando da transição para arquitetura baseada em Inteligência Artificial Generativa e Agentes Autônomos.
Senior Software Engineer, AI – Backend
Senior Software Engineer building AI-driven cloud platforms for healthcare. Designing scalable systems to support IoT devices and improve health outcomes.
Mid-Level Java Developer
Mid-Level Java Developer at GDIT delivering software solutions for government clients in an Agile environment. Collaborating with a skilled team to advance software systems and applications.
Java Fullstack Developer
Java Fullstack Developer focusing on microservices and backend solutions for a data consultancy. Utilize tools like Spring Boot, Docker, and Kubernetes to enhance client operations.
Entry-Level Application Backend – Release Observability
Backend Engineer contributing to release and observability systems at Yelp. Working in a collaborative remote environment to deliver solutions for millions of users.
Chief Architect
Chief Architect responsible for defining technical architecture for Employ's product landscape. Leading technical direction toward a unified, AI-enabled platform with a remote-first team.
Senior Linux Server Engineer
Linux System Administrator maintaining and deploying Linux systems for GDIT. Responsible for system integrity, security, and support for IT infrastructure.