This job board retrieves part of its jobs from: Emploi Étudiant | Toronto Jobs | Work From Home

Tech jobs every day in Canada!

To post a job, login or create an account |  Post a Job

   Canadian Tech jobs   

Website updated every day with fresh jobs in the IT industry

previous arrow
next arrow
Slider

Data Warehouse ETL Designer (COGNOS, OBIEE, ETL, SQL, ORBIT)

Teamrecruiter.com Inc

This is a Contract position in Toronto, ON posted November 21, 2020.

“The start date of this job is flexible and in order to find the best candidate the job may remain open much longer than the date mentioned on this posting…or you may be asked to start sooner than the expected start date if you are able to do so” URGENT: Please read the job description below.

If this interests you, please send a MS-Word version copy of your updated resume (ASAP) along with your salary expectations, first available date and a telephone contact number Please mention the job title above in the subject line The recruiter in charge of this role is Dhruv If you do not think you are a match for this opportunity, but know someone who is, feel free to forward this email to them and you will be eligible for a referral bonus upon a successful hire.

One of our government clients is looking for a Data Warehouse ETL Designer (COGNOS, OBIEE, ETL, SQL, ORBIT) Length: Contract term is 4 months with a possibility of extension Location: Toronto, ON (Remote) Background
– ORBIT corporate reporting is used extensively for management reporting, fiscal plan rollups, and internal briefings, and is based on legacy versions of Oracle Essbase / Dodeca running on Windows 2003 in Kingston Data Centre (KDC).

– Windows 2003 is the Operating System which hosts the existing corporate reporting datastore.

Support for Microsoft Windows 2003 ended globally in July 2018; no service packs or patches are available.

This has introduced considerable risk
– if security issues cannot be remediated locally, the service will be subject to removal from the Ontario Government network as per CSB policy.

– Providing a stable, modern, expandable reporting data warehouse capable of meeting current and future needs is a foundational component to ORBIT reporting modernization.

– A modern reporting data warehouse can be used in conjunction with any front-end reporting tool and will be used to inform an assessment in the selection of a reporting platform.

– This phase of work is a critical step to modernizing and remediating the technology risks associated with the existing ORBIT reporting application.

Role: Providing technical leadership to the ORBIT update/enhancement project Responsibilities: Undertakes the design of hosting technology solutions based on the client’s service specifications, standards, policies, best practices and cost models, in order to meet client application business requirement and project/initiative deliverables.

The scope of work is as follows
– Design and develop a modern, nimble SQL Reporting Data Warehouse capable of meeting current and future reporting needs.

This will include: Evaluation of data sources required to develop & deliver reports
– Determine reports required to validate data sources
– Validation of the Reporting Data Warehouse solution
– Assessment of reporting solution with findings to inform future MYP.

– Assessment and report rationalization.

Must haves:
– Experience Managing and leading a technical implementation, will be able to lead and support technical resourced in implementations and providing technical documentation
– Experience with COGNOS and OBIEE
– Significant ETL experience using SQL Assets:
– Experience with public sector budget processes or the ORBIT reporting system Experience and Skill Set Requirements Business Analysis
– 15%
– 10 years of experience in a business analyst capacity, with demonstrated work outlined clearly
– Experience conducting requirements gathering and developing documentation
– Experience with a wide range of methods, tools and techniques for business analysis such as, but not limited to: business functional modelling, business event modelling, business process mapping Business Intelligence skills
– 15% Experience with:
– Evaluating data sources
– Writing SQL code to extract and analyze data from multiple data sources
– Creating data models
– Develop data visualizations
– Document and organize information related to data structures, relationships, definitions and processes Experience with any of the following is preferred:
– Microsoft Business Intelligence
– COGNOS
– OBIEE Extract Transform Load (ETL)
– 15%
– Experience with ETL Scripting
– System Integration, Data level Data modelling
– 20%
– Experience with Data modelling, Information Architecture/Design
– Experience designing and developing enterprise level reporting data warehouse capabilities Ontario budget process
– 5%
– Knowledge and familiarity of Ontario budget process Please note that this is the most up to date version of job description available at this time
– During Client Interview you will receive additional information
– variance may apply Please visit the TEAMRECRUITER website to review other CAREER OPPORTUNITIES