Data Warehousing and B.I. Analyst (Appendix D/Temporary Assignment to January 31, 2015)
Reporting to the Associate Director, BI Research, the incumbent designs, develops, implements and supports computerized business intelligence solutions for the College's enterprise and administrative application systems through the application of systems design/analysis and programming techniques of the highest order.
• Designs, analyzes and supports Business Intelligence, Strategic and Management decision support systems that operate through our Enterprise Data Warehouse (EDW), related data marts, and reporting solutions • Works in alignment with all Business Units, adhering to our BI Strategic plan to develop and support a wide variety of Business Intelligence solutions. • Responsible for architecting data transformation & BI Reporting solutions, understanding of Star-schema data structures, customizations to the user interface, performance tuning, and navigation. • Installs, upgrades, configures and administers Cognos products, creates data Cubes and reporting off of Cubes. • Works with end-users to build reports from concept to implementation and creates technical specifications. • Understands business problems by analyzing the effectiveness of the existing systems and performing analysis activities in order to determine new application, system, logic, and programming requirements. • Designs the logic and procedures for new programs and/or existing programs which are required in order to solve business problems and provide more efficient machine operation. • Develops, codes, and tests programs to fulfil the specified requirements and effect changes, as required. • The incumbent assists the systems analyst and users to implement the solutions s/he develops. These solutions are usually included in a sub-system of the enterprise application software. This activity usually includes assisting in training and user-testing. • Interface with users in a support mode after system installation as directed by the systems analyst responsible for the sub¬system in which the installation occurred. • Performs system implementation duties such as writing user manuals and operating instructions for computer operator, providing orientation and consultation for user departments, and monitoring performance of systems and programs. • Supports clients by providing individual training on new system installations, responding to questions, assessing and resolving issues that arise. • Ensures efficient user utilization of mainframe systems by providing clear, written instructions on operations and maintenance • Maintains effective working relationships with departments across the college. • Monitors performance of programs after installation, and analyzes, identifies and troubleshoots issues encountered in production or reported by users. • Performs other related duties as assigned.
• Minimum three (3) year diploma/degree in Computer Programming and Analysis (or related field), combined with additional courses in Data Modeling , Data Mart Designing and COGNOS Server maintenance and report designing, (or related courses). • Five (5) years experience in analysis and programming in Data Warehouse, COBOL and Java programming languages. • Superb knowledge of the COGNOS, BI Modeling, COBOL, C, Java, and HTML programming languages, and the SQL data accessing language, preferably using the Oracle database. • Knowledge of the UNIX operating system environment; CICS screen programming techniques; and Netscape Application Server programming techniques and XML. • Advanced skills operating an IBM PC/compatible microcomputer using the Windows operating system to produce programs, documentation, and graphic presentations. • Ability to understand and efficiently apply complex analytical techniques of the highest order to business problems. • Excellent knowledge of structured programming techniques and principles and the ability to adapt them to changing requirements. • Experience is required in an IT client services role with exposure to client support including hardware and administrative software installation, troubleshooting and deployment. • Well-developed interpersonal, customer service and communication skills (verbal and written) to interact effectively with multi-cultural/racial/able students, staff and the public are required.
Hourly Wage Rate
Payband I: Start rate $31.56, Maximum rate $36.58
Weekly Hours of Work
37.5 hours (overtime as required). Monday to Friday: 8:00 AM to 4:00 PM
As soon as possible to January 31, 2015
September 6, 2013 External
September 12, 2013
Click on “Apply Now” below. Applications must be submitted online by the closing date and must include a covering letter and resume (as one document) in Word or pdf format.
Note: A skills assessment may be administered and proof of degrees, credentials or equivalencies from accredited regional or federal post secondary institutions and/or their international equivalents will be required at the time of interview.
Seneca College is committed to diversity and encourages applications from all qualified candidates, especially aboriginal persons, francophones, members of sexual minority groups, persons with disabilities, visible minorities and women.
We thank all applicants for their interest in this position, however only those selected for an interview will be contacted.