Business Intelligence Developer

Remote; San Francisco (CA); Remote; USD 86,000 - 137,000; Full time

Benefits offered by this job

Fully remote work arrangement

Competitive benefits package

Professional development opportunities

Job summary

A partner company is seeking a Business Intelligence Developer in the United States to design, develop, and maintain data infrastructure and reporting solutions for a national healthcare network. The role emphasizes advanced SQL, ETL processes, and Epic Cogito reporting tools, including Cogito SQL reports, Radar dashboards, and Reporting Workbench.

You will work with internal teams and external vendors to translate business needs into effective technical solutions, enabling data-driven decision

Qualifications

• 5+ years in IT or a related field.
• 5+ years experience developing complex SQL queries and database solutions.
• Epic Clarity Data Model certification is required.
• At least 3 years developing within the Epic Cogito suite is preferred.
• Experience with ETL and data integration.
• Knowledge of Epic Hyperspace reporting tools (Reporting Workbench, Cogito SQL, Radar).
• Ability to manage the full reporting lifecycle and remote collaboration.
• Authorized to work permanently in the United States.

Responsibilities

• Design, develop, and maintain database objects to support reporting and data integration.
• Write and optimize complex SQL queries for reliable data access.
• Develop automated data extraction and delivery via SFTP.
• Build Epic Cogito reports and Dashboard solutions (Reporting Workbench, Radar).
• Manage full reporting lifecycle from requirements to maintenance.
• Create scalable data structures and ETL processes.
• Perform QA testing and support UAT.
• Lead sessions with stakeholders and vendors to define solutions.
• Document technical solutions and procedures for maintenance.

Skills

SQL development

ETL processes

Data modeling

Epic Hyperspace

Cogito SQL reports

Radar dashboards

Reporting Workbench

SFTP data transfers

Education

Epic Clarity Data Model certification

Epic Cogito experience

Tools

Epic Hyperspace

Cogito SQL reports

Radar dashboards

Job description

This position is listed on behalf of a partner company, which manages all applications and next steps. Our partner is looking for a Business Intelligence Developer based in the United States.

The Business Intelligence Developer will design, develop, and maintain data infrastructure and reporting solutions that support informed decision-making across a national healthcare network.

This role combines advanced SQL development, database management, ETL processes, and custom business intelligence reporting.

You will build reliable data pipelines, scalable database structures, and reporting tools that transform complex information into actionable insights.

A key focus will be developing solutions within the Epic ecosystem, including Cogito reporting tools, dashboards, and Reporting Workbench.

Working closely with internal teams, healthcare network members, and external vendors, you will translate business needs into effective technical solutions.

This is a fully remote opportunity for an experienced BI professional who enjoys solving complex data challenges and contributing to technology that supports healthcare access and quality.

Accountabilities:

• Design, develop, and maintain database objects, including tables, stored procedures, functions, and views, to support reporting, analytics, and data integration requirements.

• Write, optimize, and troubleshoot complex SQL queries to ensure reliable data access and efficient reporting performance.

• Develop secure and automated file extraction and delivery processes, including data transfers through SFTP.

• Build and maintain custom reporting solutions within Epic Hyperspace, including Reporting Workbench, Cogito SQL reports, Radar dashboards, and related Cogito configuration elements.

• Manage the full reporting development lifecycle, from requirements gathering and solution design through development, testing, documentation, maintenance, and troubleshooting.

• Develop scalable data structures and dependable ETL processes to support business intelligence and data integration needs.

• Conduct automated and manual quality assurance testing, support user acceptance testing, and ensure reporting solutions meet defined requirements.

• Lead working sessions with network members, third-party vendors, and internal teams to understand reporting needs and design appropriate technical solutions.

• Document technical solutions, development processes, and system procedures to support ongoing maintenance and knowledge sharing.

• Perform additional responsibilities and projects as assigned.

Requirements:

• At least 5 years of experience in Information Technology or a related field.

• A minimum of 5 years of hands-on experience developing complex SQL queries and database solutions.

• Current Epic Clarity Data Model certification is required.

• At least 3 years of experience developing custom solutions within the Epic Cogito suite is preferred.

• Strong knowledge of database objects, including tables, stored procedures, functions, and views.

• Experience designing, developing, maintaining, and troubleshooting ETL processes and data integration solutions.

• Familiarity with Epic Hyperspace reporting tools, including Reporting Workbench, Cogito SQL reports, Radar dashboards, and related components.

• Ability to manage the full reporting lifecycle, including requirements analysis, technical design, development, testing, documentation, and ongoing support.

• Strong analytical and problem-solving skills, with the ability to translate business requirements into practical technical solutions.

• Effective communication and collaboration skills, including the ability to lead technical discussions with internal stakeholders and external partners.

• Ability to work independently and efficiently in a remote home-office environment with reliable high-speed internet and a distraction-free workspace.

• Willingness to undertake nationwide travel when required by business needs.

• Candidates must be legally authorized to work permanently in the United States. Employment visa sponsorship and transfers are not available.

• Candidates should be prepared to complete a pass/fail computer literacy assessment and a competency assessment as part of the selection process.

Benefits:

• Annual base salary range of $85,697–$137,116, with the final offer determined by relevant skills, certifications, education, experience, training, responsibilities, internal equity, and market conditions.

• Comprehensive employee benefits package; specific coverage and plan details are available through the employer's careers website.

• Fully remote work arrangement, with employees working from home across the United States.

• Opportunities for professional development and continuous skill growth.

• Support for work-life balance and employee well-being.

• Opportunity to contribute to healthcare technology initiatives that improve access and outcomes for rural and medically underserved communities.

• Potential nationwide travel based on business requirements.