Administrator / dba - Markham, ON, Canada - Altis Technology

Description

The Data Administrator is responsible for managing a variety of database-related tasks.

This role supports different departments within the organization by ensuring the provision of accurate, complete, and current data, reports, and information.

There is a strong focus on data integrity to ensure reliability. The Data Administrator extracts data from databases and creates useful reports for internal and external clients. This position also involves inputting and updating information into our database. Collecting, inputting, and maintaining data within our database system.
Performing accurate screening and cleaning of data sets to meet project goals and deadlines.
Processing weekly electronic cost files into the database and running reconciliation.

Monitoring and analyzing data quality in collaboration with the Manager and team to resolve any discrepancies through necessary corrections on a daily/weekly/monthly/quarterly basis.

Generating reports and verifying them to ensure data accuracy, completeness, and currency - flagging problems and coordinating with the Manager and team for resolutions.

Assisting with researching, investigating, and resolving a range of data issues quickly and professionally.
Extracting and distributing routine reports from the database for both internal and external use.

Responding to ad hoc report requests by gathering data requirements, extracting and manipulating data in Excel and/or Power BI/Tableau, and building custom reports for analysis purposes.

Providing training on Parklane software in person, online, and over the phone to both internal and external users (approximately 10% of the time).

Administering applications by creating usernames/passwords, applying login rules, setting security settings, setting up data transfers, and troubleshooting application issues.

Communicating with external and internal clients via telephone and email to clarify discrepancies and requests for information.
Creating and updating Excel spreadsheets, project plans, training, and instruction documents.
Sorting and organizing incoming correspondence, managing workflow, and prioritizing the workload.
At least 3-5 years of experience in Data Management and/or an Administrative role.
Minimum of 2 years' experience in data analysis, data processing, reporting, or a related role.
Proficient computer skills with Microsoft Office Suite.
Skilled in manipulating data in Excel, including VLOOKUP, basic formulas, and pivot tables.
Full understanding, respect, and compliance with confidentiality policies and procedures.
Knowledge of, or a strong ability to learn, the Parklane Software system.
Knowledge of WSIB practices, Power BI/Tableau also considered an asset.
Bilingual proficiency in both French and English is considered an asset.

be flexible when dealing with a variety of stakeholders and clients.