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
Il y a plus de 30 jours
Type de contrat
  • Temps plein
Description de poste

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

    Créer une alerte emploi pour cette recherche

    Database Administrator • Toronto, ON, CA

    Offres similaires
    Senior Database Developer / Administrator

    Senior Database Developer / Administrator

    Reelcruit • Toronto, Canada
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 19 heures • Offre sponsorisée • Nouvelle offre
    Senior Database Engineer

    Senior Database Engineer

    Greenlots • Toronto, Canada
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 4 jours • Offre sponsorisée
    Database Architect - C$110,000 - C$120,000 A Year

    Database Architect - C$110,000 - C$120,000 A Year

    CI Financial • Toronto, Canada, CA
    Temps plein
    Database architect needed to design schemas, build data models, and optimize SQL queries in MS SQL Server.Voir plus
    Dernière mise à jour : il y a 19 heures • Offre sponsorisée • Nouvelle offre
    Senior SQL DBA — DR, Performance & Architecture

    Senior SQL DBA — DR, Performance & Architecture

    CAA South Central Ontario • Markham, York Region, CA
    Temps plein
    A prominent insurance company in York Region is seeking a Senior Database Administrator to ensure optimal database performance and security. This role involves designing and deploying databases, col...Voir plus
    Dernière mise à jour : il y a 12 jours • Offre sponsorisée
    Database Reliability Engineer

    Database Reliability Engineer

    Orion Health group • Toronto, Canada
    Temps plein
    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 ...Voir plus
    Dernière mise à jour : il y a 11 heures • Offre sponsorisée • Nouvelle offre
    Database Analyst

    Database Analyst

    Reliance Home Comfort • Toronto, Canada
    Temps plein
    Database Analyst Find Your Limitless with Reliance.By joining Reliance as a Database Analyst you’ll become an important team member and will be provided with the tools you need to succeed.We have a...Voir plus
    Dernière mise à jour : il y a 19 heures • Offre sponsorisée • Nouvelle offre
    Database Developer

    Database Developer

    Monex Canada • Toronto, ON, CA
    Temps plein +1
    Reports to : Senior Software Development Director / Chief Architect.Monex USA, a leader in foreign exchange (FX) and international business payments, was established in 1999 to provide corporate cli...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Database Developer

    Database Developer

    VLink Inc • Toronto, Canada
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 19 heures • Offre sponsorisée • Nouvelle offre
    SRE II DBA — Oracle Cloud & Automation

    SRE II DBA — Oracle Cloud & Automation

    Loblaw Companies Limited • Toronto, Canada
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 19 heures • Offre sponsorisée • Nouvelle offre
    Database Architect

    Database Architect

    Scotiabank • Toronto C6A, ON, Canada
    Temps plein
    Select how often (in days) to receive an alert : .Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. Contributes to the overall success of the EDL i...Voir plus
    Dernière mise à jour : il y a 10 jours • Offre sponsorisée
    Senior SQL Database Administrator (Sr. SQL DBA)

    Senior SQL Database Administrator (Sr. SQL DBA)

    freelance.ca • Toronto, Canada
    Temps plein
    Our client, a leading provider in the technology sector, is seeking a Senior SQL Database Administrator (Sr.SQL DBA, you will be part of the Platform Shared Services supporting cross-functional tea...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Senior Database Engineer

    Senior Database Engineer

    G Adventures • Toronto, ON, CA
    Temps plein
    G Adventures is the world’s largest small-group adventure travel company and we’ve been making epic travel memories happen on all seven continents for over 30 years. Our mission is simple : to change...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Cloud Database Engineer II - Scale & Innovate with Aurora

    Cloud Database Engineer II - Scale & Innovate with Aurora

    CNSC • Toronto, Canada
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 19 heures • Offre sponsorisée • Nouvelle offre
    Senior Database Lead : Raiser's Edge & Grants Management

    Senior Database Lead : Raiser's Edge & Grants Management

    Children's Aid Foundation of Canada • Toronto, Canada
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 9 jours • Offre sponsorisée
    Database Developer

    Database Developer

    freelance.ca • Toronto, Canada
    Temps plein
    We’re currently hiring for the position of.Database Developer with Java Experience.If you have relevant experience, we’d love to hear from you. Job Title : Database Developer with Java Experience .Th...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Database Reliability Engineer IV

    Database Reliability Engineer IV

    PagerDuty • Toronto, ON, Canada
    Temps plein
    NYSE : PD) is a global leader in digital operations management.Trusted by nearly half of both the Fortune 500 and the Forbes AI 50, as well as approximately two-thirds of the Fortune 100, PagerDuty i...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    AppOps DBA — Scalable DB Architect & Automation

    AppOps DBA — Scalable DB Architect & Automation

    Queer Tech • Toronto, ON, CA
    Temps plein
    A leading financial technology firm in Toronto is seeking a Database Administrator to design, implement, and manage robust database solutions. Ideal candidates will have 5-8 years of experience with...Voir plus
    Dernière mise à jour : il y a 2 jours • Offre sponsorisée
    PostgreSQL Senior Database Administrator (DBA)

    PostgreSQL Senior Database Administrator (DBA)

    Marsh • Toronto, Canada
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 19 heures • Offre sponsorisée • Nouvelle offre