Talent.com
RQ08428 - Database Administrator - Intermediate
RQ08428 - Database Administrator - IntermediateRubicon Path • Toronto, ON, CA
RQ08428 - Database Administrator - Intermediate

RQ08428 - Database Administrator - Intermediate

Rubicon Path • Toronto, ON, CA
30+ days ago
Job type
  • Full-time
Job description

RQ08428 - Database Administrator - Intermediate

About the job RQ08428 - Database Administrator - Intermediate

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

Scope of Work

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
  • 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
  • Skills Experience and Skill Set Requirements

    Database Skills - 70%

  • Experience with one or more database technologies
  • Proficiency with SQL and experience writing SQL scripts
  • 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 in developing documentation on data standardization and requirements
  • Subject matter expert in database design of data warehouse or data marts.

    #J-18808-Ljbffr

    Create a job alert for this search

    Database Administrator • Toronto, ON, CA

    Similar jobs
    Senior Database Developer / Administrator

    Senior Database Developer / Administrator

    Reelcruit • Toronto, Canada
    Full-time
    About the job Senior Database Developer / Administrator Our client, an independent financial firm, is one of Canadas leading multi billions dollars investment managers. They deliver customized multi...Show more
    Last updated: 1 day ago • Promoted
    Senior Database Engineer

    Senior Database Engineer

    Greenlots • Toronto, Canada
    Full-time
    Shell Recharge Solutions is a leader in delivering the new electric mobility future through innovative software, infrastructure, and professional services that empower utilities, cities, fleets, tr...Show more
    Last updated: 4 days ago • Promoted
    24 / 7 Systems & Operations Administrator (Intermediate)

    24 / 7 Systems & Operations Administrator (Intermediate)

    Akkodis group • North York, Canada, CA
    Full-time
    Senior Systems Administrator (Virtualization, Storage, and Data Protection) • • • •Location : • • You will be based in our Toronto office and will work in a hybrid model. Work with peers in Infrastructure ...Show more
    Last updated: 2 days ago • Promoted
    Database Reliability Engineer

    Database Reliability Engineer

    Orion Health group • Toronto, Canada
    Full-time
    Do you want to work for a company that is innovating and making a difference to the health and wellbeing of people all over the world? We’re not about selling meaningless, unnecessary products for ...Show more
    Last updated: 19 hours ago • Promoted • New!
    Database Developer (Snowflake)

    Database Developer (Snowflake)

    Apex Systems • Toronto, Canada
    Temporary
    Get AI-powered advice on this job and more exclusive features.This range is provided by Apex Systems.Your actual pay will be based on your skills and experience — talk with your recruiter to learn ...Show more
    Last updated: 1 day ago • Promoted
    Database Developer

    Database Developer

    VLink Inc • Toronto, Canada
    Full-time
    VLink, founded in 2006, is a leading global provider of software engineering services with next‑gen technologies and best‑in‑class talent. North America‑Europe to APAC, with expansion plans in the M...Show more
    Last updated: 1 day ago • Promoted
    SRE II DBA — Oracle Cloud & Automation

    SRE II DBA — Oracle Cloud & Automation

    Loblaw Companies Limited • Toronto, Canada
    Full-time
    A major Canadian retail employer is hiring an SRE II, Database Administrator for its Brampton location.The successful candidate will be responsible for monitoring system health and enhancing reliab...Show more
    Last updated: 1 day ago • Promoted
    Cloud Administrator

    Cloud Administrator

    Technical Standards & Safety Authority • Toronto, Canada
    Full-time
    The Technical Standards and Safety Authority (TSSA) is deeply committed to safety and passionate about making Ontario a safer place to live, work, and play. Our unified team - what we proudly call O...Show more
    Last updated: 1 day ago • Promoted
    Senior SAP Basis & HANA Administrator – Hybrid Cloud

    Senior SAP Basis & HANA Administrator – Hybrid Cloud

    Parkland Corporation • Toronto, Canada
    Full-time
    A leading energy company in Calgary is seeking an experienced SAP Basis Administrator to support and evolve a large-scale, hybrid SAP landscape. This role focuses on system reliability, performance ...Show more
    Last updated: 1 day ago • Promoted
    Cloud Database Engineer II - Scale & Innovate with Aurora

    Cloud Database Engineer II - Scale & Innovate with Aurora

    CNSC • Toronto, Canada
    Full-time
    Join a forward-thinking company as a Software Development Engineer, where you'll play a crucial role in building hyper-scale database services in the cloud. This innovative firm is looking for passi...Show more
    Last updated: 1 day ago • Promoted
    Senior Database Lead : Raiser's Edge & Grants Management

    Senior Database Lead : Raiser's Edge & Grants Management

    Children's Aid Foundation of Canada • Toronto, Canada
    Full-time
    A charitable organization in Toronto is seeking a Senior Manager, Database to oversee data management, integrity, and reporting for fundraising efforts. The role requires strong leadership in managi...Show more
    Last updated: 9 days ago • Promoted
    SAP Basis Administrator

    SAP Basis Administrator

    Capgemini • Toronto, Canada
    Full-time
    Capgemini is a global business and technology transformation partner.Join us and help the world’s leading organizations unlock the value of technology and build a more sustainable, more inclusive w...Show more
    Last updated: 9 days ago • Promoted
    Database Administrator

    Database Administrator

    Hays • newmarket, ON, ca
    Full-time
    Job Description : CockroachDB installation, administration, and support- create design documentation and runbooks, and advise / coach other te...Show more
    Last updated: 1 hour ago • Promoted • New!
    Senior PostgreSQL DBA - HA, Performance & Automation

    Senior PostgreSQL DBA - HA, Performance & Automation

    Galent • Toronto, Canada
    Full-time
    A premier tech firm in Toronto is seeking a Senior PostgreSQL System Administrator with 5–7 years of experience in managing large-scale PostgreSQL environments. This position involves leading databa...Show more
    Last updated: 1 day ago • Promoted
    PostgreSQL Senior Database Administrator (DBA)

    PostgreSQL Senior Database Administrator (DBA)

    Marsh • Toronto, Canada
    Full-time
    PostgreSQL Senior Database Administrator (DBA).Marsh McLennan’s Database Services team is growing rapidly, and we have an exciting opportunity for a creative and inquisitive Senior Database Adminis...Show more
    Last updated: 1 day ago • Promoted
    Senior SQL Database Developer

    Senior SQL Database Developer

    Global Relay • Toronto, Canada
    Full-time
    Get AI-powered advice on this job and more exclusive features.For over 20 years, Global Relay has set the standard in enterprise information archiving with industry-leading cloud archiving, surveil...Show more
    Last updated: 1 day ago • Promoted
    Cloud-Native Database Reliability Engineer

    Cloud-Native Database Reliability Engineer

    Achievers • Toronto, Canada, CA
    Full-time
    Be among the first 25 applicantsAbout AchieversAchievers offers more than just a thank you program.Our employee recognition and rewards software inspires employees to recognize everyone, every day,...Show more
    Last updated: 2 hours ago • Promoted • New!
    Senior Database & ETL Developer (Ongoing)

    Senior Database & ETL Developer (Ongoing)

    TGT Solutions Inc. • Toronto, Canada
    Part-time
    Systems Integrator focused on helping organizations “Profit Through Technology®” since 1996.As a proud Canadian company, we are a team of innovative professionals experiencing exponential growth.Ab...Show more
    Last updated: 1 day ago • Promoted