You are applying for a position through Medix, a staffing agency. The actual posting represents a position at one of our clients.
Job Summary
Our client is seeking a skilled Data Analyst with expertise in BI & Dashboard Development, Advanced SQL Querying, and integration with Healthcare and EMR data systems. The primary goal is to design reports and migrate legacy systems to Power BI, while ensuring data integrity across platforms.
Key Responsibilities
- BI & Dashboard Development: Design, build, and maintain reports, dashboards, and visualization solutions across BI platforms, focusing on migrating legacy MicroStrategy reports into Power BI.
- Advanced SQL Querying: Write, optimize, and troubleshoot complex SQL code—including stored procedures, views, cursors, window functions, and temporary tables—to support reporting and analytics.
- Data Warehouse & Platform Integration: Assist in overhauling data extraction pipelines from Epic Clarity into the data warehouse, and support the GuideHealth platform rollout by connecting data streams and guiding third-party integration teams.
- Healthcare & EMR Data Validation: Analyze, validate, and reconcile large datasets across Epic EMR, claims, and clinical systems to guarantee data integrity and accuracy.
- Stakeholder Engagement & Gap Analysis: Interface directly with clinical and operational leadership to elicit core requirements, conduct gap assessments between platforms, and refine reporting needs.
- Documentation & Knowledge Transfer: Maintain detailed technical documentation, mapping logic, and data definitions to ensure seamless hand-offs and workflow continuity.
Qualifications
- 5+ years of advanced hands-on experience with SQL, including writing, optimizing, and troubleshooting complex queries, stored procedures, views, cursors, window functions, temp tables, and begin/end statements.
- 3+ years experience with BI platforms with a strong preference for Power BI.
- 3+ years experience analyzing healthcare data, claims, and Electronic Medical Record (EMR) systems like Epic (Clarity).
- 3+ years experience with Advanced Excel functions such as Pivot Tables and analytical functions.
Skills
- Technical skills: SQL, Business Intelligence Tools (Power BI preferred)
- Soft skills: Effective communication, stakeholder engagement
Additional Requirements
- Work Location & Model: Hybrid work model, with on-site work in New Haven, CT. Initial schedule is 3 days/week on-site for the first 90 days, scaling down to 2 days/week thereafter. Standard hours start at approximately 8:30 AM.
- Target Start Date: Late August / Early September, to allow overlap prior to employee leave on September 14.
Benefits
- Paid Sick Leave (Medix provides paid sick leave according to state and local sick leave ordinances).
- Health Benefits / Dental / Vision (Medix offers 6 different health plans: 3 Major Medical Plans, 2 Fixed Indemnity Plans (Standard and Preferred), and 1 Minimum Essential Coverage (MEC) Plan. Eligibility for health benefits is based on verifying that an average of 30 hours per week during the first 4 weeks of the work assignment has been met. If you meet eligibility requirements and take action to enroll, you will be covered no earlier than 60 days into your assignment, depending on plan selection(s)).
- 401k (Eligible on the first 401k open enrollment date following 6 consecutive months on assignment. 401k Open Enrollment dates are 1/1, 4/1, 7/1, and 10/1).
- Short Term Disability Insurance.
- Term Life Insurance Plan.
Required Employment / Compliance Language
Medix is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability
*We will consider for employment all qualified Applicants, including those with criminal histories, in a manner consistent with the requirements of applicable federal, state, and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance (FCIHO), Los Angeles Fair Chance Ordinance for Employers (ULAC), The San Francisco Fair Chance Ordinance (FCO), and the California Fair Chance Act (CFCA).
Medix Overview:
With over 20 years of experience connecting organizations with highly qualified professionals, Medix is a leading provider of workforce solutions for clients and candidates across the healthcare, scientific, technology, and government industries. Through our core purpose of positively impacting lives, we’re dedicated to creating opportunities for job seekers at some of the nation's top companies. As an award-winning career partner, Medix is committed to helping talent find fulfilling and meaningful work because our mission is to help you achieve yours.
*This position is subject to a background check based on its job duties, which may include patient care, working with vulnerable populations, access to financial and confidential information, driving, working with heavy machinery, or working in a warehouse or laboratory environment. Due to these job duties, this position has a significant impact on the business operations and reputation, as well as the safety and well-being of individuals who may be cared for as part of the job position or who may interact with staff or clients.
