BI Developer / Report Writer
Apex Systems LLC
Boston, United States of America
2 days ago
Role details
Contract type
Temporary contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
IntermediateJob location
Remote
Boston, United States of America
Tech stack
ETL
SQL Server Integration Services
Freeform SQL
Sql Optimization
Epic Clarity
Epic Caboodle
Job description
- Design, build, and optimize reports and dashboards using Epic Clarity and Caboodle
- Analyze existing Clarity queries and determine the most effective approach to replicate logic in Caboodle, including:
- Single Caboodle queries
- Caboodle expansions
- Use of legacy Caboodle dbo structures when appropriate
- Partner with revenue cycle stakeholders to support patient billing analytics and reporting
- Support and enhance ETL architecture, including downstream data availability and performance
- Write and optimize complex SQL queries to support reporting and analytics initiatives
Requirements
- Epic Certifications:
- Clarity
- Caboodle (Development and/or Admin)
- Cogito Systems
- Epic Experience:
- 2+ years working with the Epic data model, including Clarity and Caboodle
- Technical Skills:
- 5+ years of advanced SQL experience
- Experience with ETL architecture and SSIS
- Strong understanding of Revenue Cycle / Patient Billing workflows and data concepts
- Hands-on, self-directed, and comfortable working in a fully remote environment
About the company
Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico. Apex uses a virtual recruiter as part of the application process. Click for more details.