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-10 years experience preferred
Proficiency in Microsoft Office and Google Suite of Products