Job Description
Job DescriptionDescription:
POSITION SUMMARY:
The candidate will play a crucial role in supporting the organization's scalable data infrastructure. This position is responsible for designing, building, and maintaining automated data pipelines that integrate clinical, financial, and operational datasets to support seamless data flow. The role supports enterprise reporting, analytics, and performance tracking across the healthcare system. The ideal candidate will possess strong technical skills in SQL, Excel, and workflow automation, as well as a deep understanding of healthcare data, financial metrics, and data validation processes.
ESSENTIAL FUNCTIONS:
Data Engineering & Pipeline Management
- Design, develop, and maintain robust ETL pipelines that integrate data from EMR systems, legacy databases, and financial data sources.
- Automate ingestion, transformation, and validation workflows using tools such as KNIME and SQL.
- Build and optimize backend data models to support clinical and financial reporting needs.
Reporting & Analytics Support
- Develop advanced Excel models and Power BI datasets to support business operations and care management.
- Support the integration of finance and operations metrics into enterprise dashboards.
- Monitor and optimize the performance of reporting tools to ensure the timely delivery of actionable insights to stakeholders.
Quality & Governance
- Implement reusable logging, validation, and error-handling processes to improve data integrity.
- Ensure compliance with HIPAA and data security standards.
- Maintain thorough documentation and audit trails for data pipelines and reports.
Compliance & Confidentiality
- Maintain compliance with HIPAA and all applicable state and federal billing regulations.
- Protect the confidentiality and integrity of all patients’ financial data.
- Adhere to Pediatrica Health Group’s policies and procedures for ethical billing practices.
Collaboration & Stakeholder Engagement
- Partner with analysts, clinicians, finance, and IT teams to identify reporting needs and streamline data processes.
- Participate in cross-functional initiatives to enhance enterprise data access, reduce manual reporting, and drive decision-making efficiency.
Requirements:
KNOWLEDGE, SKILLS & ABILITIES
- Advanced knowledge of healthcare data structures (patients, claims, encounters, billing, quality metrics).
- Strong SQL skills with experience in performance tuning and query optimization.
- Proficiency in workflow automation tools (KNIME preferred).
- Expertise in Excel, including Power Query, pivot tables, and data modeling.
- Familiarity with Azure or other cloud-based data environments.
- Knowledge of HIPAA compliance and healthcare data security.
- Strong analytical mindset with attention to detail and a drive for process improvement.
EDUCATION & EXPERIENCE
- Expert in Computer Science, Data Science, Information Systems, or related field required.
- Minimum 3 years of experience in data engineering, reporting development, or business intelligence roles.
- Experience working with healthcare data and payer reporting preferred.
- Background in integrating financial and operational data for analytics and reporting.
SUPERVISORY RESPONSIBILITIES
- None
WORKING CONDITIONS
- General office working conditions in a corporate environment.
- Some standing, sitting, and light lifting may be required.
PHYSICAL DEMANDS
The physical demands described here are representative of those that must be met by an associate to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential function.
While performing the duties of this job, the associate will be required to stand, walk, sit, use hands to finger, handle, or feel objects, tools, or controls, reach with hands and arms, climb stairs, balance, stoop, kneel, crouch, or crawl, and talk or hear. The associate must occasionally lift and or move up to 15 pounds. Specific vision abilities required by the job include close vision, distance vision, peripheral vision, depth perception, and the ability to adjust.
Frequent travel is required, often up to several hours of driving per day. Ability to travel to, attend, and conduct presentations as needed. Manual dexterity is required to use desktop computers and peripherals. Exposure to variable weather conditions is likely.
WORK ENVIRONMENT
The work environmental characteristics described here are representative of those that must be met by an associate to successfully perform the essential functions of their job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. The noise level in the work environment is usually moderate.
TRAVEL
Minimal travel may be required for training or cross-location support.
SAFETY HAZARDS OF THE JOB
Minimal Hazards