Skip to content

Open nowFirst seen 30 hours ago

RQ08428 - Database Administrator - Intermediate

Rubicon Path638 open roles

Where
Toronto, ON, Canada
Get the CV for this job

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

Your applicationOpen nowRQ08428 - Database Administrator - IntermediateRubicon Path · Toronto, ON, Canada
  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 Rubicon Path'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.

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

Share of postings closed within
  1. 2.0%1 day
  2. 4.3%3 days
  3. 11.5%7 days
  4. 18.1%14 days
  5. 35.6%30 days
  6. 44.6%60 days
This job: first seen 30 hours ago

The posting

Description

Lead the development and delivery of functional and ministry-specific analytics to support evidence-based decision-making and produce actionable insights. Work closely with client groups to assess current data analytics and reporting capabilities, gather future-state requirements and identify further opportunities for improvement. Facilitate decision-making and manage client expectations. Own the execution of analytics initiatives including end-to-end reporting and data set delivery. Participate in documentation, development, testing

Work with functional area experts, Data Architects and ETL Developers and stakeholders to understand complex business issues and develop appropriate Business Intelligence solutions. Design methods to capture, structure, transform and process data to be used to generate models. Build data models that provide information which is accurate, easy to understand and unbiased. Communicate complex quantitative analysis in a clear and precise manner, providing useful visuals and summaries. Provide interpretation, advice, and expertise to client groups and other stakeholders, including direction on how to transform analytics into actionable information and proactive insights that support decision making.

General Skills

  • Excellent analytical, problem-solving and decision-making skills, verbal and written communication skills, interpersonal skills and teamwork skills
  • Outstanding consulting and relationship management skills, with proven ability to elicit requirements, develop/consult on options and solutions, and provide effective guidance
  • Adept at communicating to both technical and non-technical audiences
  • Experience with a range of analytical methods, techniques and tools such as, but not limited to: statistical analysis and modelling, data mining, machine learning and algorithms, natural language processing, and other related disciplines at the specified experience level
  • Ability to manipulate and analyze complex, high-volume data from structured and unstructured sources
  • Experience developing data extraction, transformation, and load functionality for large relational and multi-dimensional data stores
  • Experience designing high quality interfaces to present information in a meaningful way to end users
  • Broad understanding of data management, financial and business analysis, database architecture, and information visualization
  • Proficiency in query languages and experience constructing complex query statements
  • Experience in one or more programming or scripting languages
  • Strong investigative and logic skills. Proficiency in mathematics and statistics
  • Awareness of emerging Business Intelligence trends and directions
  • Experience with analytical software such as R,
  • Proficiency with desktop analysis software including Microsoft Excel, Access, VBA, Power BI

The general scope of work for the Database Administrator involves:

· Assisting with the transformation/cleaning of data from a legacy database into a new data warehouse

· Determine appropriate data structure for remaining relevant legacy data

· Develop mapping and transformation rules to align the two databases

· Create data dictionary for new data

· Develop connections with multiple other government databases and develop system to maintain the connection so that it does not go out of date

· Supporting Power BI visualization and report building

  • · Develop and test any automated data validation tools deemed necessary

SkillsExperience and Skill Set Requirements

Database Skills - 70%

  • Experience with one or more database technologies
  • Proficiency with SQL and experience writing SQL scripts
  • Experience designing data architecture for new databases
  • Experience in monitoring and enforcing database rules
  • Experience cleaning, transforming and joining data
  • Experience is creating and applying data standards
  • Experience with dimensional data models
  • Subject matter expert in database design of data warehouse or data marts.

Communication Skills - 25%

  • Experience in developing documentation on data standardization and requirements
  • Demonstrated consulting and relationship management skills, with proven ability to elicit requirements, develop/consult on options and solutions, and provide effective guidance
  • Strong verbal and written communication skills; with both technical and non-technical audiences
  • A demonstrated team player with a track record for meeting deadlines

OPS Experience - 5%

  • Previous public sector experience in an organization of equivalent size and complexity to the Ontario Public Service.

MUST HAVES:

  • Experience with one or more database technologies
  • Proficiency with SQL and experience writing SQL scripts
  • Experience designing data architecture for new databases
  • Experience in developing documentation on data standardization and requirements

Subject matter expert in database design of data warehouse or data marts.

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 Rubicon Path'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 Rubicon Path'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

    Rubicon Path'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.

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.