EPIC Business Intelligence Developer, Sr

Cook Children's Health Care System; Fort Worth (TX); On-site; USD 90,000 - 130,000; Full time

Job summary

Cook Children's Health Care System is seeking a Senior BI Developer to design, develop and implement analytics tools and data solutions for clinical, financial and operational users.

The role focuses on self-service analytics, reports, dashboards and data warehousing within a healthcare setting, working with Epic, Workday and cloud platforms. Strong leadership, mentoring and project involvement are expected.

Qualifications

• Bachelor's degree in Computer Science, MIS or related field with 4+ years BI experience.
• Proficiency in SQL, Python or R for data analysis and modeling.
• Experience with BI tools (Power BI, Tableau, Crystal Reports) and ETL processes.

Responsibilities

• Design, develop and implement BI solutions including reports and dashboards.
• Gather requirements from clinical, financial and operational stakeholders.
• Mentor junior BI developers and participate in project management as needed.

Skills

SQL

Python

R

ETL processes

Education

Bachelor's degree in CS/IS

MIS/Info Systems degree

Tools

Power BI

Tableau

Crystal Reports

SSIS/ETL

Job description

Location: Medical Office Building-Fort Worth (750 8th Ave)

Department: IS Epic

Shift: First Shift (United States of America)

Standard Weekly Hours: 40

Summary

The Senior Business Intelligence (BI) Developer is an experienced data professional who designs, develops and implements analytics tools and data solutions. This individual comprehensively understands business data needs, gathers requirements, analyzes data and develops robust analytics solutions for advanced projects, self-service analytics and business user consumption. The Senior BI Developer interfaces with clinical, financial and operational business leaders, subject matter experts as well as Information Services applications teams to design reports, dashboards and analytics that accurately reflect business workflows and drive action. The Senior BI Developer plans, designs, architects, develops, tests and implements new BI solutions as well as troubleshoots, monitors and maintains existing BI solutions. Expertise writing relational and multidimensional database queries that meet performance objectives and business use cases. Expertise with data warehousing design and development methodologies. Strong experience with leading healthcare technology systems such as EMR (Epic), Claims processing (Epic), ERP (Workday), CRM, cloud based data platforms (Azure, Snowflake) etc. Will be seen as a leader and mentor less experienced BI Developers. This person is a key contributor on complex projects and may act as an informal project manager as needed. The individual identifies process improvement opportunities and writes recommendations, process documentation and best practices in a clear, concise manner.

Responsibilities

Responsibilities include designing, developing and implementing BI solutions; building reports, dashboards and analytics; gathering requirements from clinical, financial and operational stakeholders; ensuring solutions reflect business workflows; leading and mentoring junior BI developers; participating in project management as needed; identifying process improvements and documenting best practices; supporting existing BI solutions and troubleshooting issues.

Qualifications

• High school diploma or GED required.
• Bachelor's degree in Computer Science, Engineering, Management Information Systems (MIS), Business or related/relevant degree AND minimum of 4 years of experience as a BI Developer, Data Analyst, Business Analyst, Operations Analyst, Data Engineer, Database Developer, and/or Technical/Systems/Application Analyst OR Minimum of 6 years of experience as a BI Developer, Data Analyst, Business Analyst, Operations Analyst, Data Engineer, Database Developer, and/or Technical/Systems/Application Analyst
• Expertise with business intelligence tools: Microsoft BI stack, SAP Business Objects, TIBCO Spotfire, Tableau, Crystal Reports, etc.
• Expertise programming in SQL, Python, R, SAS or equivalent programming languages.
• Expertise writing relational and multidimensional database queries, database object development, optimization, etc.
• Strong experience in data warehousing design and methodologies.
• Demonstrated experience operating efficiently within the BI development lifecycle.
• Proven experience with business and technical requirements gathering, analysis, and verification.
• Strong experience in planning, designing, architecting, developing and supporting BI solutions.
• Strong experience debugging, monitoring, and troubleshooting BI solutions.
• Expertise creating and deploying highly visible reports/dashboards/analytics for business use.
• Experience leading and managing small scale data and technology projects.
• Experience mentoring and supporting junior level BI developers.
• Able to exercise independent judgment and take action. Excellent analytical, mathematical, and creative problem-solving skills.
• Excellent listening, interpersonal, written and oral communication skills. Logical and efficient, with keen attention to detail.
• Highly self-motivated and directed. Ability to effectively prioritize and execute tasks while under pressure.
• Must be available for support by pager or telephone 24 hours per day x 7 days per week.

Preferred

• Minimum of 2 years of experience in a healthcare, provider and/or managed care/insurance environment preferred.
• Minimum of 4 years of experience in information technology preferred.
• Holds current Epic certifications: Epic Cogito, Caboodle Data Model, Clarity Data Model, and at least one of the following - Clinical/Patient Access/Revenue Cycle Data Model
• Experience utilizing, developing and supporting Epic Cogito tools, including Radar Dashboards, Reporting Workbench Reports, Radar SQL Metrics, Crystal Reports, SlicerDicer, Analytics Catalog, registries, etc. preferred

Licensure, Registration, and/or Certification

• Epic certification may be required for the position based on area focus.
• Employee must hold or obtain Epic certification within six (6) months of employment (including one allowed test retake).
• Required Epic certifications for BI Developers supporting Epic include: Epic Cogito, Caboodle Data Model, Clarity Data Model, and one of the following: Clinical/Patient Access/Revenue Cycle Data Model.
• Preferred: The required certifications above as well as additional relevant Cogito certifications or proficiencies such as Clinical/Patient Access/Revenue Cycle Data Models, SlicerDicer Custom Build Badge, Radar SQL Metrics Badge, Cogito SQL Badge, Caboodle-Clarity Development, Cogito Tools Administration, and/or other relevant Epic application certification(s); Microsoft SQL certification, Python certification and/or BI/analytics tool certification (Power BI, SAS, etc) a plus.

About Us

Cook Children's Health Care System offers a unique approach to caring for children because we are one of the country\'s leading integrated pediatric health care delivery organizations. Patients benefit from the integrated system because it allows Cook Children's to use all of its resources to treat a patient and allows for easy communication between the various companies by physicians with a focus on caring for children and adolescents.

Cook Children's is an equal opportunity employer. As such, Cook Children's offers equal employment opportunities without regard to race, color, religion, sex, age, national origin, physical or mental disability, pregnancy, protected veteran status, genetic information, or any other protected class in accordance with applicable federal laws. These opportunities include terms, conditions and privileges of employment, including but not limited to hiring, job placement, training, compensation, discipline, advancement and termination.