Enterprise BI Developer – Oracle Fusion & Data Intelligence

Allegheny College

Meadville (Crawford County)

On-site

USD 90,000 - 120,000

Full time

10 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Allegheny College is seeking an Enterprise Data & BI Developer to lead the technical implementation and ongoing support of the college’s BI/analytics environment, with initial focus on Oracle Fusion Data Intelligence (FDI).

The role collaborates with ITS, Institutional Effectiveness, and enterprise systems teams to translate business requirements into scalable data solutions, build integrations across Oracle Fusion Cloud ERP, HCM, OSM, and other systems, and advance modernization of reporting

Qualifications

Bachelor’s degree in Computer Science or related field.
Minimum of 4-7 years experience required; 7-10 years experience preferred.
Proficiency in Microsoft Office and Google Suite of Products.
Relational databases, analytical data modeling, advanced SQL, and query optimization.
Knowledge of data reconciliation, quality controls, semantic models, and reporting design practices.

Responsibilities

Design, develop, and maintain BI solutions: reports, dashboards, data visualizations, data sets, and analytical tools.
Develop and maintain data warehouse structures, data models, and data sets for enterprise reporting.
Write and optimize SQL queries; develop ETL/data integration to extract, transform, and integrate data.
Support reporting across enterprise applications, including Oracle Cloud.
Validate data and reporting results for accuracy and consistency.
Troubleshoot data, reporting, integration, and dashboard issues; implement sustainable solutions.
Collaborate with departments to gather requirements and translate them into reporting solutions.
Develop standardized and ad hoc reports and analyses for operational needs.