# Enterprise Data & Business Intelligence Developer — Allegheny College

- Location: Meadville, PA
- Posted: Oct 28, 2026
- Status: open (checked Nov 21, 2026)
- Apply (employer's site): https://alleghenycollege-ibwwjb.fa.ocs.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1/job/364
- Employer record: https://visajobs.io/company/allegheny-college.md

## Sponsorship history
- Tier: Employer history only
- With this exact title: 0

## 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, 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, dashboa

> History, not a promise: past H-1B filings do not mean an employer will sponsor you or a given role. Data: U.S. DOL OFLC LCA disclosure (FY2024–FY2026 for role counts, certified LCAs) and the USCIS H-1B Employer Data Hub. Not legal advice. Methodology: https://visajobs.io/methodology
