|Posting Number: CPM-8259|
|Position Title: Senior Enterprise Data Warehouse Analyst - BI|
|Department: University Information Technology|
|Salary Grade: G|
|Hiring Salary Range: $90,596 - $101,920|
|Maximum of Salary Range: $124,569|
|Duration: Continuing Full-Time|
|Hours: 8:30 am - 4:30 pm|
The Senior Enterprise Data Warehouse Analyst - Business Intelligence (the incumbent) supports the planning, policy formulation and decision-making activities at York University by designing and developing the Business Intelligence (BI) layer of the Enterprise Data Warehouse (EDW). The purpose of the EDW is to provide a comprehensive, accessible and authoritative store of information assets for senior level decision-making. The incumbent will develop information assets to assist in government reporting, government lobbying, union negotiations, strategic initiatives, organizational performance, workload analysis, organizational changes, and comparative data from other universities. The data are referenced both at the detailed individual level and the aggregated organizational level and all intermediary levels. The incumbent performs all work required to make the informational assets accessible and informative to the senior management of the University. This includes identifying and analyzing business requirements, translating requirements to technical specifications, designing and developing solutions using appropriate development tools, ensuring that the systems are available and functioning efficiently, troubleshooting production problems, working closely with senior analysts of source systems, facilitating consensus between various system stewards, developing custom modules and systems, and modifying and upgrading software. The incumbent is responsible for the final resolution of all technical problems related to the BI layer of the EDW. The incumbent serves as a university expert on all aspects of the BI layer of the EDW, including development of security architecture to protect the highly confidential and strategic nature of the data. In addition, the incumbent will research, recommend and participate in developing strategic direction and initiatives for BI applications within the university, communicate with client groups and coordinate technical design sessions to ensure that the university's business needs are met.
University degree or equivalent in Computer Science, Institutional Research or related field.
7-10 years of progressive experience in the IT field including system design and development working specifically with Oracle databases and PL/SQL. Experience with the system development lifecycle, promotion from development to production, data conversion, metadata repositories, data profiling, data quality analysis, thorough understanding of relational database technology and star schema design. Preferred experience in higher education sector, with data warehouse systems and business intelligence applications. Experience with OBIEE+ is highly desirable. Preferred experience with Institutional Research and Performance Management. Experience working in a supervisory capacity, preferably in a unionized environment.
Formal training in and/or advanced knowledge of PL/SQL and Oracle environment and OBIEE+. Advanced knowledge of desktop applications, entity relationship diagrams and experience with ERwin. Working knowledge of unix and job scheduling. Knowledge of applicable data privacy practices and laws. Good understanding of the organizationís goals and objectives. Exceptional analytical, conceptual and problem-solving abilities. Superior communication, negotiation, presentation and facilitation skills in order to manage client relationships and their competing interests, priorities and perspectives. Effective motivational and diplomatic skills appropriate to large and complex organizations. Excellent customer service and interpersonal skills to assist clients in defining business needs, resolving problems, raising data quality concerns, promoting system adoption across the organization. Ability to deal with technology vendors in negotiation and acquisition of software, equipment and services. Knowledge and experience with standard project methodologies, tools and techniques. Ability to work under and deliver to deadline constraints across multiple demands. Proven ability to exercise good judgment and maintain a high level of confidentiality because of the academic, social, financial or environmental considerations associated with the solutions being addressed by the data warehouse.
|Cover Letter Required: Yes|
Thank you for your interest in a career with York University. To apply, please ensure that:
- You have submitted a complete application package (application form*, resume and covering letter) . When emailing your application package, ensure that you have attached the resume, cover letter, and application form to your email.
- A complete application package has been submitted for each job posting you are applying for.
- You have quoted the appropriate posting number on your application form and in the subject line of your email. Please keep the posting number and position description for future reference or inquiries.
- Your application package is submitted in one of the following formats: Microsoft Word (.doc), or Adobe (.pdf). If you do not have access to the above programs, you may submit your resume and covering letter in plain text format (.txt). Please note the application form cannot be saved in this format.
Applications are to be submitted to: firstname.lastname@example.org.
Only those selected for an interview will be contacted. York University is committed to Employment Equity and encourages applications from all qualified candidates.
York University offers accommodation for applicants with disabilities in its recruitment processes. If you are contacted by York University regarding a job opportunity or testing, please advise if you require accommodation.