Report Developer

Staff - Non Union

Job Category
M&P - AAPS

Job Profile
AAPS Salaried - Information Systems and Technology, Level C

Job Title
Report Developer

Department
Reporting Team | Integrated Service Centre | Finance and Operational Excellence | VP Finance and Operations

Compensation Range
$6,551.00 - $9,418.83 CAD Monthly

The Compensation Range is the span between the minimum and maximum base salary for a position. The midpoint of the range is approximately halfway between the minimum and the maximum and represents an employee that possesses full job knowledge, qualifications and experience for the position. In the normal course, employees will be hired, transferred or promoted between the minimum and midpoint of the salary range for a job.

Posting End Date
June 6, 2024

Note: Applications will be accepted until 11:59 PM on the Posting End Date.

Job End Date

This role will be hired in the ISC and will be expected to initially support the Student Completion project for a time period of up to 18 months. Upon completing the defined tasks included in that project, this role will transition to ISC.  Once in ISC, the role will focus on the ongoing sustainment and continuous improvement of reports in Workday ecosystem.

At UBC, we believe that attracting and sustaining a diverse workforce is key to the successful pursuit of excellence in research, innovation, and learning for all faculty, staff and students. Our commitment to employment equity helps achieve inclusion and fairness, brings rich diversity to UBC as a workplace, and creates the necessary conditions for a rewarding career. 

Job Summary

The University of British Columbia ("UBC") is a global centre for teaching, learning and research, consistently ranked among the top 20 public universities in the world and recently recognized as North America's most international university. UBC is a diverse environment, with almost every industry vertical represented from healthcare, education, food and beverage, legal, media, real estate, etc. and with more than 70,000 members of the community UBC's service providers need to be able to meet a variety of stakeholder needs with both robust and mature operational capabilities combined with the agility and innovation required to meet the ambitious objectives laid out in its new Strategic Plan: Shaping UBC's Next Century.

The Integrated Service Centre ("ISC") maintains, continuously improves and enhances the systems and processes that support operational functions of UBC, including human resources and finance (and student services, in the future). Team members within this unit will work cross-functionally with other departments/units across UBC. The vision for the ISC is to provide integrated services that create an enriched user experience for UBC faculty, employees and students.  

The Report Developer designs, develops, and executes complex reporting for the ISC to support decision-making across the university. This role enables product users to develop and generate simple reports. The position understands user reporting needs and ensures that the product is extracting proper data and being used as intended.

Organizational Status
Dual reporting to the Application Sustainment Senior Manager (ISC) and Manager, EDBI within the Chief Data Office (CDO). Works in partnership on a team accountable for the continuous improvement of the ISC product. Frequently engages across the ISC to understand reporting requirements; designs and develops reports leveraging reporting best practices and standards as defined by data governance.
Work Performed

1) Supports ISC teams in designing, developing and executing reports for team members across the ISC. 

- Provides subject matter expertise on report development including Service Centre incidents and problems related to reporting.
- Reviews and responds to Service Centre requests for reports using variety of tools for development and testing; coordinates releases over the application lifecycle.
- Performs data validation to ensure data is usable for reporting and analytics.
- Leverages data access framework to inform the release of data and/or reports to the community. Translates requirements into dashboards/reports as needed. 

2) Provides input and support for continuous improvement related to report management within the ISC.

- Resolves technical issues related to report creation, data manipulation and report calculations.
- Participates/facilitates the development of business terms for reporting and analytics.
- Identifies opportunities to best leverage data to produce insightful information.
- Develops and maintains application / data glossary and data dictionary.
- Provides input to enable effective project planning and continuous improvement goals.
- Enforces UBC IT data management, data governance and integrated reporting practices are being applied and used for continuous improvement.

3) Develops and fosters effective partnerships across the organization, including the broader UBC community.

- Partners across the ISC to align work, priorities and practices and to determine if product reporting changes meet business needs and is operating as designed.
- Partners with stakeholders to gather reporting requirements following business analysis best practices.
- Partners with Functional Analysts to interpret requirements, confirm reporting development needs, and identify the best tool to fulfill the business requirements following UBC reporting architectural principles and governance. 
- Builds and fosters good working relationships with related stakeholders to achieve product reporting objectives and goals.
- Partners with UBC IT to define and guide reporting needs, processes, and interdependencies.

4) Advocates for a partnership that moves UBC's practices from "system of record" to "platform of engagement" through collaborative and innovative efforts.

- Solicits feedback fostering an agile, innovative, and collaborative transformation experience.
- Partners with relevant stakeholders to resolve issues related to engagement, adoption, sustainment, and continuous improvement.

5) Actively promotes best practices in the security and privacy of personal information and data; makes recommendations to improve processes and procedures where necessary.

6) Performs other related duties as required.

Consequence of Error/Judgement
Contributes to the broader Application Sustainment team and UBC's IT strategies. Supports decision-making regarding report development within an existing large, complex and campus-wide product. Focusing on partnerships and product delivery will ensure optimal functionality and customer satisfaction in support of ISC's strategic goals.
Supervision Received
Reports to the Application Sustainment Senior Manager (ISC) and Manager, EDBI within the CDO. Work in partnership on a team with wide latitude across the ISC. Work is reviewed in terms of quality, achievement against objectives, and focus on collaboration and innovation.
Supervision Given
Acts a mentor or coach to peers as required.
Minimum Qualifications
- Willingness to respect diverse perspectives, including perspectives in conflict with one’s own
- Demonstrates a commitment to enhancing one’s own awareness, knowledge, and skills related to equity, diversity, and inclusion
Preferred Qualifications

Undergraduate degree in a relevant discipline.   Relevant Disciplines include: Bachelor's degree in Computer Science or Management Information Systems  Minimum of three years experience or the equivalent combination of education and experience.    Knowledge of data concepts, databases and an understanding of UI/ Visualization concepts is required to succeed in this position. Experience working with Workday, especially with regards to reporting: a working knowledge of data sources and university objectives related to finance, HR or student Information defining calculated fields and/or configuring reports in Report Writer and/or BIRT is preferred. ITIL is an asset. Experience working in complex, academic environments is preferred (and specifically within UBC).
Demonstrated understanding of IT and operational processes and requirements that support the data within a complex, unionized environment.
- Proven ability to identify, clarify, and resolve testing issues and risks, escalating them as needed.
- Proven ability to write complex SQL purposed to combine, transform or calculate data as per reporting requirements.
- Demonstrated experience with reporting tool sets including BIRT, Crystal Reports, Tableau, Power BI or other form layout-based report development tools.
- Experience working a variety of software including Jira, Confluence and ServiceNow.
- Demonstrated ability to work in an innovative, and fast-paced environment. 
- Experience working on cross-functional teams and communicating to a diverse audience (technical and non-technical). 
- Demonstrated ability to work in a collaborative and inclusive manner, fostering equitable experiences and a respectful environment through reflection, empathy, sensitivity, and curiosity towards differences across teams.
- Excellent interpersonal skills including active listening, written and verbal communication, and conflict management.
- Demonstrated willingness, ability, and enthusiasm to learn new processes, methodologies or technologies. 
- Strong systems analysis, complex problem-solving, deductive reasoning, and reporting skills. - Collaboration: Participates willingly by supporting team decisions, assisting other team members, and doing his/her share of the work to meet goals and deadlines. Informs other team members about client-related decisions, group processes, individual actions, or influencing events. Shares all relevant and useful information.
- Communicating for Results: Speaks and writes to peers in ways that support transactional activities. Shares information and asks questions prior to acting. 
- Problem Solving: Asks questions and looks for data that helps to identify and differentiate the symptoms and root causes of every day, defined problems. Suggests remedies that meet the needs of the situation and those directly affected. Resolves problems and escalates issues appropriately. - Accountability: Asks questions and provides feedback in an effort to clarify mutual expectations. Seeks advice on tasks and responsibilities when needed.
- Business Process Knowledge: Identifies and documents processes within area of responsibility. Seeks guidance on aspects of process that are out of immediate scope. Drafts procedures that comply with the process.
- Information Systems Knowledge: Aware of the primary uses of technology by customers, learning the systems of the enterprise and the customers affected. Responds to day-to-day requests for technical support in areas of primary usage. Escalates questions and problems to relevant technical expert groups.