Business Intelligence Developer II
Role details
Job location
Tech stack
Job description
Operations, Caregiving Orthodontics Data Modeling Data Extraction Vision Insurance Business Valuation Medical Prescription Healthcare Analytics Business Requirements Business Intelligence Full Stack Development Epic EMR Certification Artificial Intelligence Business Transformation SQL (Programming Language) Operational Performance Management Copayment Collection And Processing, * Design, build, and maintain BI solutions using Epic reporting tools
- Develop and optimize reports and dashboards (Reporting Workbench, Slicer Dicer, and related tools)
- Work with Epic data models, including Clarity, Caboodle, and Cogito
- Write and optimize complex SQL queries for data extraction and analysis
- Partner with clinical, operational, and IT stakeholders to deliver data-driven solutions
- Ensure data accuracy, integrity, and performance across deliverables
- Support ongoing reporting enhancements and requests, Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools. Related Jobs Make Ready Technician Aerotek Kansas City, MOOn-Site Plumbing Aviation Painting Cleanliness Construction Detail Oriented Time Management Health Advocacy Apartment Maintenance Valid Driver's License Artificial Intelligence Discounts And Allowances Employee Assistance Programs Drywall (Installation And Repair) +0 Lead Superintendent Actalent Overland Park, KSOn-Site Procore Visionary Operations Leadership Management Innovation Coordinating Construction Shop Drawing Communication Team Building Problem Solving Quality Control Project Scoping Project Closure Microsoft Office Safety Standards Project Schedules Safety Procedures Performance Review Quality Management Artificial Intelligence Engineering Design Process +0 Technician Aerotek De Soto, KS*On-Site Dollies Aviation Machinery Hand Tools Pallet Jacks Adaptability Detail Oriented Lifting Ability Health Advocacy Material Handling Loading And Unloading Manufacturing Processes Artificial Intelligence
Requirements
We are seeking a skilled Business Intelligence Developer II to join a growing BI team. In this fully remote role, you will support impactful healthcare data initiatives that drive improved patient outcomes and operational performance. The ideal candidate has strong experience with Epic reporting, data modeling, and SQL, and excels at turning complex data into actionable insights., Required:
- Epic certification in Cogito, Clarity, Caboodle Data Modeling, or equivalent experience
- Experience building reports in Epic tools (e.g., Workbench, Slicer Dicer)
- Strong SQL skills
- Experience in healthcare data/analytics environments
- Ability to translate business requirements into technical solutions
Benefits & conditions
This is a Permanent position based out of Kansas City, MO. Pay and Benefits
The pay range for this position is $79000.00 - $109000.00/yr.
Health, Life and Disability Benefits Benefit Who pays and who is eligible? Health Insurance Meritain (Aetna) - Similar to PPO
- Coverage includes core vision benefit through VSP
- Prescription coverage through Ventegra
- Mosaic and the caregiver share the cost of premiums.
- Caregiver pays co-pays and/or deductibles.
- Full- and part-time caregivers with base hours of at least 32 hours per pay period and all caregivers who work an average of 30 hours per week during the measurement period, regardless of FTE or status, are eligible the first of the month following 30 days of employment or eligible status. Vision Insurance - Signature Buy-Up
- The Signature Buy-Up is for caregivers who want to increase their vision benefit coverage for themselves and their family, using a VSP provider.
- The program offers caregivers:
- $10 co-pay for annual well-vision exam
- $250 allowance towards frames and contacts
- $25 co-pay for single vision lenses, or lined bi- or tri-focals.
- The caregiver pays for this benefit.
- Full- and part-time caregivers with base hours of at least 32 hours per pay period are eligible the first of the month following 30 days of employment or eligible status. Dental Insurance Mosaic offers two programs, Base Plan and a Signature Buy Up Plan, through Delta Dental of Missouri.
- Base Plan:
- 100 percent coverage for routine care (two exams, X-rays and two cleanings)
- $1,000 individual maximum per benefit year for restorative and major services
- $50 per person/$150 for family deductible per benefit year
- Signature Buy Up Plan:
- 100 percent coverage for routine care (two exams, X-rays and two cleanings)
- $1,500 individual maximum per benefit year for restorative and major services
- $1,500 orthodontic lifetime maximum per eligible person; NEW for 2022, adult orthodontic included
- $50 per person/$150 for family deductible per benefit year
- Mosaic and the caregiver share the cost of premiums.
- Full- and part-time caregivers with base hours of at least 32 hours per pay period are eligible the first of the month following 30 days of employment or eligible status. Flexible Spending Account (FSA)
- Medical
- Dependent Care (daycare) Caregivers may set aside earnings on a pre-tax basis and can be reimbursed for out-of-pocket medical expenses and/or dependent-care (daycare) expenses. Caregivers receive a debit card to use for medical charges (e.g., co-pays, prescriptions, etc.).
- Caregiver elects to contribute on a pre-tax basis.
- Mosaic pays all administrative fees.
- Full- and part-time caregivers with base hours of at least 32 hours per pay period are eligible the first of the month following 30 days of employment or eligible status. Health, Life and Disability Benefits (Cont.) Benefit Who pays and who is eligible? Life Insurance
- Caregivers
- Spouse
- Dependent
- Basic Life and Accidental Death and Dismemberment (AD&D) For Life and AD&D, the payout amount is equal to one times the caregiver's annual salary rounded to the next thousand (maximum $50,000).
- $5,000 is available for spouses.
- $2,000 is available for eligible dependents.
- Mosaic pays for this benefit.
- Full-time caregivers with base hours of at least 60 hours per pay period are eligible the first of the month following 30 days of employment or eligible status.
- Eligible dependents are live birth - 26 years old Supplemental Life and AD&D - Caregiver
- Full-time caregivers can purchase supplemental life insurance and AD&D in $10,000 increments up to $750,000. Caregivers can enroll in up to $300,000 as Guaranteed Issue, any amount more than this they must complete an Evidence of Insurability (EOI) and receive carrier approval.
- Part-time caregivers are eligible to purchase supplemental life insurance in $10,000 increments up to $100,000; however the elected amount cannot exceed five times a caregiver's salary.
- Caregivers who are enrolling for the first time in an amount of $300,000 or more or who are increasing their supplemental coverage must complete an EOI questionnaire.
- The caregiver pays for this benefit.
- Eligible the first of the month following 30 days of employment or eligible status. Supplemental Life - Spouse and Dependents
- Full-time caregivers can enroll their spouse in supplemental life insurance in $10,000 increments up to $150,000. Spouses can enroll in up to $50,000 as Guaranteed Issue, any amount more than this they must complete an (EOI) and receive carrier approval.
- Caregivers can enroll their eligible dependents, 1 day - 6 months old in supplemental life up to $2,000 and dependents 6 months old - 26 years old up to $10,000.
- Part-time caregivers can enroll their spouse up to $50,000.
- Caregiver must be enrolled in supplemental life and the spouse's and/or dependent's benefit cannot be more than 50 percent of the caregiver's benefit.
- The caregiver pays for this benefit.
- Eligible the first of the month following 30 days of employment or eligible status. Short-Term Disability Workplace Type