Business Intelligence Developer

OCHIN; Oregon; Hybrid; USD 90,000 - 130,000; Full time

Job summary

OCHIN, Inc. is a 100% remote health IT nonprofit based in Oregon, hiring a Business Intelligence Developer to design, develop, test, and maintain data pipelines and reporting across Epic Cogito and Cogito build elements.

The role requires strong SQL and data modeling skills and interaction with members and vendors. The position collaborates across the BI team to deliver reliable data solutions and supports the full project lifecycle, including requirements gathering, design, development, QA, and

Qualifications

• Minimum five years of experience in Information Technology or related field.
• Minimum five years of experience with complex SQL development.
• Current Epic Clarity Data Model certification.
• Minimum 3 years of experience with custom development within the Epic Cogito suite.

Responsibilities

• Design, build, and maintain database objects and complex SQL queries to support reporting, analytics, and data integration needs.
• Develop custom reporting solutions within Epic Hyperspace, including Reporting Workbench and Cogito SQL reports, Radar dashboards, and Cogito build elements.
• Execute the full reporting lifecycle: design, development, testing, documentation, maintenance, and troubleshooting.
• Lead sessions with OCHIN members, vendors, and staff to design and develop technical solutions for reporting and analytics.

Skills

IT experience

SQL development

Tools

Epic Cogito

Job description

All Jobs > Business Intelligence Developer

Full-time

Description

MAKE A DIFFERENCE AT OCHIN

OCHIN is a nonprofit leader in health care innovation and a trusted partner to a growing national provider network, delivering the clinical insights and tailored technologies needed to expand patient access, strengthen care teams, and improve the health of rural and medically underserved communities.

We are hiring for a number of new positions to meet increasing demand. When you choose to join OCHIN, you have the opportunity to continuously grow your skills and do meaningful work to help fulfill our vision of good health and well-being for everyone.

At OCHIN, we value the unique perspectives and experiences of every individual and work hard to maintain a culture rooted in our values.

Founded in Oregon in 2000, OCHIN employs a growing virtual workforce of more than 1,200 skilled professionals, working remotely across 49 states. We offer a generous compensation package and are committed to supporting our employees’ entire well-being by fostering a healthy work-life balance and opportunity for professional advancement. We are curious, collaborative learners who strive to live our values every day. OCHIN is excited to support our continued national expansion and the increasing demand for our innovative tools and services by welcoming new talent to our growing team.

Position Overview:

The Business Intelligence Developer designs, develops, tests, documents, maintains, and troubleshoots database objects, ETL processes, and custom reporting solutions across a broad suite of Business Intelligence and data integration tools. This role is responsible for implementing reliable data pipelines and scalable data structures, as well as creating and optimizing various reporting products for business users. The developer actively supports the full project lifecycle, including gathering and defining requirements, solution design, solution development, automated and manual quality assurance testing, and user acceptance testing phases of projects.

Essential Functions:

• Design, build, and maintain database objects such as tables, stored procedures, functions, and views, and develop complex SQL queries to support reporting, analytics, and data integration needs including the secure and automated delivery of file extracts via SFTP.


• Develop custom reporting solutions within Epic Hyperspace, including Reporting Workbench and Cogito SQL reports, Radar dashboards, and all associated Cogito build elements.


• Responsible for the execution of full reporting lifecycle; from design, development, testing, documentation, maintenance, troubleshooting, and documentation of processes and systems.


• Lead working sessions directly with OCHIN members, third party vendors, and/or staff to design and develop technical solutions that fit reporting and analytic needs.


• Other duties as assigned.

Requirements

• Minimum five years of experience in Information Technology or related field required.


• Minimum five years of experience with complex SQL development required.


• Current Epic Clarity Data Model certification required.


• Minimum 3 years of experience with custom development within the Epic Cogito suite preferred.

Hiring Process

During the selection process, candidates will be prompted to complete a pass/fail computer literacy assessment and a competency assessment. These assessments help us better understand each candidate’s strengths, preferences, and work style and are one of several tools used in the selection process.

Work Location and Travel Requirements

OCHIN is a 100% remote organization with no physical corporate office location. Employees work remotely from home, and many of our positions also support our member organizations on-site for new software installations. Nationwide travel is determined based on OCHIN business needs. Please inquire during the interview process about travel requirements for this position.

Work from home requirements are:

• Ability to work independently and efficiently from a home office environment


• High Speed Internet Service


• It is a requirement that employees work in a distraction free workplace


• Travel may be required nationally based on business requirements for OCHIN


• In alignment with OCHIN’s mission and commitment to protecting our workforce and the communities we serve, OCHIN strongly encourages all workforce members, especially those whose role involves travel and in-person engagement, to remain up to date on immunizations, including but not limited to COVID-19 and influenza vaccinations.

We offer a comprehensive range of benefits. See our website for details: https://ochin.org/careers

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.

Base Pay Overview

OCHIN uses broadened pay ranges to support equitable and market-aligned compensation practices. The final offer will be based on a variety of factors, including relevant skills, certifications, education, experience, training, responsibilities, internal equity, and market data.

Work Authorization

Candidates must be legally authorized to work in the United States on a permanent basis at the time of application. This position is not eligible for employment visa sponsorship now or in the future. OCHIN does not provide sponsorship for employment-based visas or transfers of existing employment-based visas.