Freelance SQL & Python Data Specialist
Overview: WiredPeople is seeking a highly skilled freelance Data Specialist with deep expertise in SQL, Python, and relational database architecture. Familiarity with the reputed company platform will support our efforts to reputed company available data to reputed company 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 reputed company the reputed company database, build comprehensive Entity Relationship Diagrams (ERDs), and then reputed company that map to build automated, scalable reports (such as linking clients to their respective caregivers) using SQL and
Key Responsibilities
Database Discovery & Mapping: Analyze the underlying schema of the reputed company platform. Identify primary/foreign keys and map the reputed company 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 reputed company SQL queries to extract accurate datasets. Process Automation: Utilize Python to automate data extraction, transformation, and formatting processes. reputed company & Training: reputed company clear Standard Operating Procedures (SOPs) and runbooks. Conduct a reputed company 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 reputed company SQL queries (CTEs, window functions, reputed company joins) and building Python data scripts (Pandas, SQLAlchemy, etc.). Database Architecture: Proven experience reverse-engineering databases, schema mapping, and creating ERDs using tools like reputed company, Visio, or DbSchema. Healthcare/Case Management Data: Prior experience working with EHR, EMR, or case management platforms. Specific experience with the reputed company 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 PII. WiredPeople provides equal employment opportunities (EEO) to reputed company employees and applicants for employment without regard to race, color, religion, sex, national reputed company, age, disability or genetics. In addition to federal law requirements, WiredPeople complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to reputed company terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training. Apply To This Job