23-17 Business Intelligence Developer (Manager 180) – Office of Institutional Research
West Chester University of Pennsylvania
Location: West Chester, Pennsylvania
Higher Education Institution
Join a vibrant campus community whose excellence is reflected in its diversity and student success. West Chester University of Pennsylvania’s Office of Institutional Research (OIR) invites applications for the position of Business Intelligence Developer.
West Chester University, a member of the Pennsylvania State System of Higher Education, is a public, comprehensive institution committed to offering high-quality undergraduate education, selected post-baccalaureate and graduate programs, and a variety of educational and cultural resources for its students, alumni, and citizens of southeastern Pennsylvania. The University offers more than 100 graduate and undergraduate programs in the sciences and mathematics, business and public management, arts and humanities, health sciences, education and social work, music, and interdisciplinary studies. WCU is a community of educators dedicated to developing graduates who succeed personally and professionally and contribute to the common good.
WCU proudly offers a positive and purposeful work environment; comprehensive employee benefits including health, vision, and dental insurance along with many wellness programs; a commitment to work-life balance including generous paid vacation, paid sick time, military leave and paid time off for most major holidays; and a University mission to support employee personal and professional growth including a tuition waiver for self and family members, training and development, and advancement opportunities.
Reporting to the Director of Data Management & Business Intelligence, the Business Intelligence Developer is responsible for collaborating with colleagues in the OIR and other campus constituents to support data management and reporting efforts to meet internal and external business needs. This position is vital to developing data sources, creating efficiencies for the OIR, and surfacing data to constituents university-wide leading to data-informed decision-making. This role is also essential to instilling a culture of data literacy and self-service business intelligence.
The Business Intelligence Developer is responsible for design, development, testing, and maintenance of existing and future data structures, BI environment, and dashboards. This person will understand down-stream impact of changes in operational processes and procedures that affect data and reporting and will respond accordingly. The person in this role must use multiple technologies and platforms (e.g., SAS, SQL, MS Access, MS Excel, Student Information and Customer Relationship Management systems) and use multiple data sources across those platforms to identify the appropriate instances, tables, and fields necessary to respond to business needs.
Communicate with personnel across campus to identify business requirements and appropriate data sources and translate them to Business Intelligence reporting solutions used to satisfy business or reporting needs.
Enhance and develop new BI reports, dashboards, and data visualizations using best practices (technical specification, project management documentation, version control, internal validity testing, end-user acceptance) that provide business intelligence objects to users that are clear, accessible, and user-friendly across various technology platforms and end user skill levels.
Integrate data from disparate data sources (SIS, RM, LMS, internal data stores) to build data structures and implement sound data warehousing techniques to populate and store data securely, accurately, and efficiently.
Perform data audits and data validation, build data integrity checks to identify data quality issues, and work with appropriate staff to resolve those issues as needed.
Develop documentation and instructional and training materials that will help constituents navigate BI solutions and consume information efficiently, including maintenance of a data dictionary to promote a culture of data literacy and data governance.
Provide appropriate levels of access to data and develop processes to notify end users of updates, edits, training, and process failures related to data and BI tools.
Enhance current reporting solutions and assist in identifying new reporting solutions that will create efficiencies for OIR staff and campus constituents.
Collaborate with OIR colleagues to determine and respond to data needs, changes to existing reports, and the creation of new reporting solutions. Review existing processes and work with OIR colleagues to implement automated business intelligence solutions and gain efficiencies.
Work with Advanced Data Analytics and OIR team members to ensure timely and accurate data submissions to meet regulatory reporting requirements.
Utilize programming skills to create queries to access, transform, and prepare data for modeling, analysis, and reporting purposes.
Stay informed of current business practices, data structure, and technology changes that may impact BI environment and respond by making appropriate adjustments.
Master’s degree in Computer Science, Information Systems, or related field and two years of work experience.
Two years of hands-on experience in an enterprise data environment with the following technologies/tools: SQL or SAS programming, data analysis, business intelligence, development of data structures, and data visualization software.
Knowledge of data governance.
Knowledge of creating technical specification/documentation.
Knowledge of enterprise reporting.
Knowledge of data warehouse (design/management) or relational databases.
Proficiency in SAS programming.
Proficiency in SAS Viya Visual Analytics, SAS Data Integration Studio, or SAS Data Management Studio.
Proficiency in Microsoft Access.
Proficiency in Microsoft Excel.
Experience working in higher education.
Ask about opportunities to work from home and alternate work schedules.
Review of applications will begin immediately and continue until the position is filled.
A skills test will be administered to candidates reaching the final interview stage.
Applicants must successfully complete the interview process to be considered as a finalist.
Developing and sustaining a diverse faculty and staff advances WCU’s educational mission and strategic Plan for Excellence. West Chester University is an Affirmative Action/Equal Opportunity Employer. Women, minorities, veterans, and persons with disabilities are encouraged to apply.
All offers of employment are subject to and contingent upon satisfactory completion of all pre-employment background checks.
West Chester University (WCU) of Pennsylvania is among the top regional comprehensive public universities in the nation, serving more than 17,500 students at the undergraduate and graduate levels with a national reputation for excellence, value, and student success. Founded in 1871 as an institute for teacher preparation, West Chester offers more than 118 undergraduate and 103 graduate programs in more than 50 fields of study. In addition to the main campus in West Chester, the University offers programs through its graduate center, the Philadelphia campus, and online. Five colleges and two schools comprise the University: Colleges of Arts and Humanities, Business and Public Management, Education and Social Work, Health Sciences, and the Sciences and Mathematics, as well as the School of Music, and the School of Interdisciplinary and Graduate Studies. Located in Chester County (25 miles from downtown Philadelphia) the area combines the best of enjoyable daily living with easy access to the full spectrum of country and city attractions. We are a community of educators dedicated to developing graduates who succeed personally and professionally and contribute to the common good.