Report Developer

University of British Columbia - Vancouver, BC (30+ days ago)

Apply Now

Job Posting

Job ID:
37553

Location:
Vancouver - Point Grey Campus

Employment Group:
Management&Professional (AAPS)

Job Category:
Information Systems & Tech

Classification Title:
Info.Sytems&Technlgy, Level C

Business Title:
Report Developer

VP/Faculty:
VP Finance and Operations

Department:
Integrated Service Centre

Salary Range:
$66,787.00 (minimum) - $80,176.00 (midpoint) - $96,212.00 (maximum)

Full/Part Time:
Full-Time

Ongoing:
Yes

Desired Start Date:
2020/06/22

Funding Type:
Budget Funded

Closing Date:
2020/06/11

Available Openings:
2

Guiding principle: "Midpoint" of the hiring salary range means the individual possesses full job knowledge, qualifications and experience.

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.

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.

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.

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.
.
Equity and diversity are essential to academic excellence. An open and diverse community fosters the inclusion of voices that have been underrepresented or discouraged. We encourage applications from members of groups that have been marginalized on any grounds enumerated under the B.C. Human Rights Code, including sex, sexual orientation, gender identity or expression, racialization, disability, political belief, religion, marital or family status, age, and/or status as a First Nation, Metis, Inuit, or Indigenous person.

All qualified candidates are encouraged to apply; however Canadians and permanent residents will be given priority.