Business Intelligence Developer - Analytics
About the role
Join EvergreenHealth’s Analytics team and help transform data into meaningful insights that support patient care, operations, and strategic decision-making. In this role, you’ll partner closely with clinical and business leaders to design and deliver innovative analytics solutions, leveraging Epic tools (Reporting Workbench, SlicerDicer, Radar, Cogito) and non-Epic platforms.
Responsibilities
- Epic Cogito Caboodle custom development experience
- Certifications in Epic Cogito, Caboodle, Cogito Tools Admin highly desired, with verifiable build experience
- Demonstratable expert level SQL skills including windows functions in SQL
- Adept at creating and maintaining SQL stored procedures, views, and queries to extract and report on Clarity and Caboodle datasets
- Experience with query tuning and optimization
- Excel at building, maintaining, and troubleshooting Reporting Workbench templates and reports, creating dynamic filtering, utilizing extensions and rules to drive reporting and dashboard content
- Familiarity with Cognitive Computing Models and Predictive Analytics Models that are part of Epic’s suite of tools
- Experience troubleshooting missing data, Caboodle warnings and error logs, understanding backfill/resets, and investigating data lineage
- Develop custom Data Models, DMC’s, and Radar content using both Cogito SQL Templates and SQL based content
- Familiarity with Epic’s main application workflows (Ambulatory, Acute, OpTime, etc.)
- Understanding of Nova and Epic Upgrades, completing notes as needed
- Conduct peer reviews and provide coaching on coding best practices
- Great communication skills are a must, in support of transparent dialogue with operational partners, regardless of technical acumen
- Provide training and support to end users on BI tools and reports
- Partner with teammates to optimize queries, act as data stewards and SME’s for one another and the organization, and encourage cross team collaboration in support of all operational goals
Qualifications
- Associate Degree in Computer Science, Business Systems, Health Information Management, or other related field, or equivalent education/experience
- 4 years of related experience
- Advanced knowledge of relational database design and analysis
- Experience working with and developing queries using SQL (or equivalent languages)
- Experience building and supporting Business Intelligence solutions, including ETL development and data discovery
- Experience with data visualization tools like Tableau, Power BI, or similar BI tools and dashboard/scorecard development
- Ability to understand data structures that could benefit the entire data model
- Ability to present solutions to multidisciplinary teams and organizational leadership groups
- Well-developed written and verbal communication skills, including ability to communicate complex technical issues to a non-technical audience
- Strong quantitative and analytic skills
- Proven attention to detail and ability to think creatively and work collaboratively in a rapidly-changing environment
Skills
- SQL
- Data Modeling
- BI Tools
- Dimensional Data Models
- Reporting Workbench
- Cognitive Computing Models
- Predictive Analytics Models
Benefits
Choices that care for you and your family At EvergreenHealth, we appreciate our employees’ commitment and contribution to our success. We are proud to offer a suite of quality benefits and resources that are comprehensive, flexible, and competitive to help our staff and their loved ones maintain and improve health and financial well-being. Medical, vision and dental insuranceOn-demand virtual health careHealth Savings AccountFlexible Spending AccountLife and disability insuranceRetirement plans (457(b) and 401(a) with employer contribution)Tuition assistance for undergraduate and graduate degreesFederal Public Service Loan Forgiveness programPaid Time Off/VacationExtended Illness Bank/Sick LeavePaid holidaysVoluntary hospital indemnity insuranceVoluntary identity theft protectionVoluntary legal insurancePay in lieu of benefits premium programFree parkingCommuter benefits View a summary of our total rewards available to you as an EvergreenHealth team member by clicking on the link below. EvergreenHealth Benefits Guide