RQ08032 - Database Administrator - Intermediate
RQ08032 - Database Administrator - Intermediate
Posted on :
12-10-2024
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Description:
- Lead the development and delivery of functional and ministryspecific analytics to support evidencebased decisionmaking and produce actionable insights.
- Work closely with client groups to assess current data analytics and reporting capabilities gather futurestate requirements and identify further opportunities for improvement.
- Facilitate decisionmaking and manage client expectations.
- Own the execution of analytics initiatives including endtoend 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 problemsolving and decisionmaking 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 nontechnical 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 highvolume data from structured and unstructured sources
- Experience developing data extraction transformation and load functionality for large relational and multidimensional 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
Requirements
Experience and Skill Set Requirements:
Must Haves:
- Experience with one or more database technologies
- Experience designing data architecture for new databases
- Experience in monitoring and enforcing database rules
- Experience is creating and applying data standards
- Experience in developing documentation on data standardization and requirements
Skill Set Requirements:
Database Skills:
- 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:
- 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 nontechnical audiences
- A demonstrated team player with a track record for meeting deadlines
OPS Experience:
- Previous public sector experience in an organization of equivalent size and complexity to the Ontario Public Service.
Experience and Skill Set Requirements: Must Haves: Experience with one or more database technologies Experience designing data architecture for new databases Experience in monitoring and enforcing database rules Experience is creating and applying data standards Experience in developing documentation on data standardization and requirements Skill Set Requirements: Database Skills: 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: 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: Previous public sector experience in an organization of equivalent size and complexity to the Ontario Public Service.
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
