Skip to content
CV Rocket
Get started
How it worksThe enginePricingBlogContactSign in

Open nowFirst seen 6 days ago

RQ03355 - Business Intelligence Specialist - Senior

Hire Level Consulting Inc.20 open roles

Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowRQ03355 - Business Intelligence Specialist - SeniorHire Level Consulting Inc.

  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on Hire Level Consulting Inc.'s own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

12.3% of postings close within 7 days. Measured by our own scanner across the market.

Share of postings closed within
  1. 2.1%1 day
  2. 4.5%3 days
  3. 12.3%7 days
  4. 19.7%14 days
  5. 35.6%30 days
  6. 58.0%60 days
This job: first seen 6 days ago

The posting

  • Job Title: RQ03355 - Business Intelligence Specialist - Senior
  • Submission Due: Mar 21 @ 3:30pm
  • Start Date: 2022-04-01
  • End Date: 2023-04-05
  • Total Duration: # Business Days 374.00
  • Max Extension Term(s): 1 Time
  • Office Location: Yonge Street, Toronto, ON

Description

The BI Intelligence Specialist will be required to provide the following:

· Prepare a detailed BI user requirement document

· Document the new requirements and complete analysis and design document

· Prepare the database design/structure document based on the requirement

· Design and build the dimensional data model for Data Warehouse and Data Mart

· Convert the user requirements into business model for Cognos BI

· Convert the business model into Framework Manager Models

· Build the security model for the BI implementation

· Create metadata, user groups and folder structure for BI objects

· Create use cases for each of the requirement

· Design, build, test predefined reports

· Create reports using Cognos Analytics V11.1.x

· Test, Debug and resolve BI reporting issues

· Document test cases to ensure expected functionality test is completed

· Deploy reports using COGNOS Framework Manager

· Develop SQL and PLSQL process and procedures to implement complex logic

· Assist with SQL tuning and optimization activities related to the Cognos reports

· Help to optimize the SQL and PL/SQL process for optimal report performance

· Prepare scripts and documentation for the data preparation process and regular performance check & monitoring

· Support user testing and system implementation

· Train SMEs or conduct demos on Ad hoc reporting

· Any other deliverables as assigned by the Project/Resource Manager.

· Knowledge transfer to HSC staff

NOTE​Assignment Type: This position is currently listed as "Hybrid" as consultants may be required to work partly in the

physical workplace and partly remotely. The details of this arrangement will be at the Hiring Manager's discretion.

Consistent with screening requirements already in place for OPS employees entering OPS workplaces, FFS Consultants

may be required to complete the Non-Employee COVID-19 Screening Form each time prior to entering an OPS

workplace.

Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional

funds will be added beyond the maximum contract value and any extension options included in the original SOW. HSC

may exercise its option(s) to extend an SOW beyond March 31, 2023 for up to one additional extension term of one

year. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2023 and be

upon the same terms, conditions and covenants contained in the SOW.

Must Haves: (Candidates without these skills will not be considered)

 In-depth knowledge and experience with Cognos report development, testing in Cognos Analytics v11.1.x (5+ years), must be minimum v10**

 Experience in Framework Manager modelling, database design/data model design, point-in-time architecture, and dimensional model (5+ years)

 Need to be comfortable with conventional data modelling

 Experience in Oracle 19 or higher including writing complex SQL/PL SQL queries and materialized views

Skills: Experience and Skill Set Requirements

Technical Skills – 35 points

· Experience in designing and developing Data Marts or Data Warehouses on a wide- range of data repositories

(relational and multi-dimensional data stores)

· Experience in Framework Manager modelling, database design/data model design, point-in-time architecture, and

dimensional model (5+ years)

· Excellent requirements analysis skills

· Demonstrated experience in working with Power Designer Tool to design logical and physical models, generating

scripts and applying model changes in various

· In-depth knowledge and experience with Cognos report development, testing and server management in Cognos

Analytics and Administration v11.1.x

· Knowledge of Power BI and Tableau

· Knowledge of BI architecture patterns, best practices, processes, and artefacts

· Experience with Agile/scrum and waterfall methodologies, using tools such as JIRA and Confluence

· Linux Experience

· Cloud Experience (Azure, AWS)

Core Skills and Experience – 30 points

· In-depth knowledge and experience with Cognos report development, testing in Cognos Analytics v11.1.x (5+ years)​

From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against Hire Level Consulting Inc.'s own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.

  3. We apply on Hire Level Consulting Inc.'s form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.

  4. Every reply, sorted

    Hire Level Consulting Inc.'s answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.

  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

Get the CV for this job
By hand5–10
With CV Rocket100
applications a day

Nearby

Live postings like this one

Same employer first, then the same role elsewhere.

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.