Title Database Administrator
Office location - Toronto, ON
Rate - $65/HR

Description

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

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 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.