Enterprise Data & Business Intelligence Developer at Allegheny College in Meadville, PA

Job description

The Enterprise Data & Business Intelligence Developer is responsible for the technical implementation, configuration, development, and ongoing support of Allegheny College's enterprise business intelligence and analytics environment, with an initial emphasis on Oracle Fusion Data Intelligence (FDI). This position serves as a primary technical resource for implementing and administering FDI, including data integration, data modeling, semantic model extensions, reporting development, platform configuration, and data validation. Working within Information Technology Services (ITS), the position ensures that enterprise data is accurately integrated, securely managed, and accessible through reliable and scalable reporting and analytics solutions. The position collaborates closely with functional departments, Institutional Effectiveness, and enterprise systems teams to translate business and institutional reporting requirements into effective technical solutions. Responsibilities include developing integrations across Oracle Fusion Cloud ERP, HCM, OSM, and other institutional systems; extending enterprise analytics capabilities; and supporting the modernization of institutional reporting and data management practices. In addition to implementation responsibilities, the position supports the long-term sustainability, performance, security, and continuous improvement of the College's business intelligence environment. The successful candidate will combine strong technical development skills with an understanding of enterprise systems, data architecture, and collaborative problem-solving to support operational effectiveness and data-informed institutional decision-making. Business Intelligence Development & Data Management Design, develop, and maintain business intelligence solutions, including reports, dashboards, data visualizations, data sets, and analytical tools. Develop and maintain data warehouse structures, data models, and data sets to support enterprise reporting and analytics. Write and optimize SQL queries and develop ETL/data integration processes to extract, transform, and integrate data from multiple enterprise systems. Support reporting and analytics across enterprise applications, including Oracle Cloud and other institutional systems. Validate data and reporting results to ensure accuracy, completeness, consistency, and alignment with source systems and established business rules. Troubleshoot and resolve data, reporting, integration, and dashboard issues and implement sustainable solutions. Evaluate and improve existing reporting and data processes to increase efficiency, automation, usability, and reliability. Business Analysis, Reporting & Analytics Work with departments across the College to gather requirements, understand business processes, identify data needs, and translate business questions into effective reporting and analytical solutions. Develop standardized and ad hoc reports, dashboards, and analyses that support operational needs and institutional decision-making. Analyze institutional and operational data to identify trends, patterns, relationships, and opportunities for improvement. Consult with functional users to interpret data and determine appropriate reporting and analytical approaches. Collaborate with users to establish and maintain consistent definitions, business rules, and data standards for institutional reporting. Provide consultation, training, and support to users in the effective use and interpretation of reports, dashboards, and institutional data. Support Institutional Effectiveness reporting and modernization. Enterprise Data & BI Strategy Collaborate with ITS and functional areas to establish priorities for business intelligence, reporting, data integration, and analytics initiatives. Participate in projects involving enterprise applications, system implementations, data integrations, reporting, and institutional data initiatives. Develop and maintain documentation for data sources,