Enterprise Data & Business Intelligence Developer
Alleghenycollege-Ibwwjb Cx · Meadville, Pennsylvania, United States
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, data models, business rules, reports, dashboards, integrations, and technical processes.
- Identify opportunities to expand the use of institutional data and business intelligence to improve decision-making and operational effectiveness.
- Monitor emerging business intelligence, analytics, data management, and reporting technologies and recommend solutions that may benefit the College.
- Contribute to the development of data governance, reporting standards, and practices that promote reliable and consistent use of institutional data.
Data Security, Support & Other Duties - Maintain appropriate data security, privacy, access controls, and governance practices when working with institutional data.
- Provide ongoing support and maintenance for business intelligence applications, reports, dashboards, and data processes.
- Respond to and resolve reporting and data-related requests and issues.
- Maintain awareness of changes to enterprise systems and their potential impact on reporting and data solutions.
Education and Credentials
- Bachelor’s degree in Computer Science or related field required
- Minimum of 4-7 years experience required; 7-10 years experience preferred
- Proficiency in Microsoft Office and Google Suite of Products
Required Knowledge
- Demonstrated knowledge of relational databases, analytical data modeling, advanced SQL, and query optimization.
- Understanding of enterprise analytics implementation, data integration, ETL/ELT, system testing, change management, and technical documentation.
- Knowledge of data reconciliation, quality controls, semantic models, and reporting design practices.
- Understanding of information security, role-based access, privacy, and governance principles, including FERPA.
- Ability to learn Oracle Fusion Cloud ERP/HCM data structures, FDI configuration, and higher-education reporting requirements.
Skills and Abilities
Required Skills
- Strong advanced SQL development, debugging, and data analysis skills.
- Experience developing enterprise BI reports, dashboards, datasets, and data models.
- Ability to design, test, document, and troubleshoot data integration and transformation processes.
- Ability to reconcile analytical outputs against source systems and resolve discrepancies with functional data owners.
- Strong analytical, organizational, problem-solving, documentation, and time-management skills.
- Ability to manage multiple technical assignments within project timelines and collaborate across functional boundaries.
- Ability to communicate technical concepts effectively to administrators, faculty, staff, business owners, and technical colleagues.
Required Abilities- Ability to independently implement and maintain complex analytics configurations while working with vendors and functional teams.
- Ability to analyze existing reporting processes and build secure, scalable, maintainable solutions.
- Ability to prioritize, troubleshoot, and resolve integration, reporting, data-quality, and platform issues.
- Ability to deliver accurate technical work and maintain complete implementation and support documentation.
- Ability to facilitate technical requirements and testing discussions among diverse stakeholders.
- Ability to adapt to changing Oracle releases, implementation milestones, and institutional priorities.
- Ability to maintain confidentiality and exercise sound judgment with sensitive financial, employee, and student information.
Computer Skills
Required skills in Advanced Reporting/Analytics Tools such as Entrinsik Informer, Oracle Fusion Data Intelligence, R, Python, Oracle Integration Cloud.
Preferred skills in Enterprise Applications such as Colleague (Unidata) and Oracle Cloud experience.
Preferred skills in Project Management/Collaboration Tools such as Asana.
Education and Credentials
- Bachelor’s degree in Computer Science or related field required
- Minimum of 4-7 years experience required; 7