Data Specialist

Dive into the underlying schema of the WellSky healthcare case management platform Identify primary and foreign keys and map relationships between clients, caregivers, services, and demographic data Create Entity Relationship Diagrams (ERDs) Build a functional Data Dictionary for internal teams Translate business requirements into complex SQL queries and Python scripts Extract, automate, and deliver accurate datasets Develop clear Standard Operating Procedures (SOPs) Run virtual and in-person training sessions for non-technical team members Explain technical roadblocks to business leaders in accessible language Requirements 5+ years of experience writing complex SQL queries, including CTEs, window functions, and complex joins Experience building scalable data scripts in Python, including Pandas and SQLAlchemy Prior experience with EHR, EMR, or case management platforms is a major advantage Experience with WellSky is a bonus Proven experience reverse-engineering relational databases and mapping schemas Experience using Lucidchart, Visio, or DbSchema Ability to translate non-technical requests into technical queries Ability to explain technical roadblocks to business leaders without jargon Solid understanding of data compliance and best practices for handling sensitive PII and healthcare data Must be located within commuting distance of Tallahassee, Florida for periodic in-person collaboration Core Competencies Demonstrates expertise in SQL query writing, Python scripting, and data management within healthcare case management platforms. Proficient in translating business requirements into technical solutions while ensuring compliance with data handling best practices. Highest-signal resume keywords Complex SQL Query Writing Python Scripting with Pandas and SQLAlchemy Entity Relationship Diagram (ERD) Creation Data Compliance and Best Practices Experience with EHR or EMR Systems ATS Optimization Keywords Hard Skills SQL Query Writing Python Scripting Data Dictionary Development Entity Relationship Diagrams (ERDs) Database Reverse Engineering Data Extraction and Automation Complex Joins CTEs and Window Functions Data Mapping Standard Operating Procedures (SOPs) Soft Skills Technical Communication Training and Facilitation Problem-Solving Translating Technical Concepts Industry Keywords Healthcare Data Case Management EHR EMR PII Compliance Tools & Technologies WellSky Lucidchart Visio DbSchema #J-18808-Ljbffr Jobtailor