Leads the team this role joins
Hires for this team
On the team, can refer you
From your own Gmail and LinkedIn.
About the role
This is a hybrid senior technical role in Etobicoke, Ontario, for an experienced data professional who acts as the technical authority on ADP Canada's databases, tables, fields, business rules and data models. The engineer reviews and rationalizes data assets, checks that business logic is built correctly, and removes redundant or obsolete structures. The role works closely with BI Data Stewards to keep technical data documented and aligned with business needs.
What you’ll do
- Analyze and maintain enterprise data structures, including databases, tables, views, fields and relationships.
- Set and enforce data governance standards and controls.
- Build and maintain logical and physical data models.
- Find ways to simplify and standardize data assets across platforms.
- Support enterprise metadata and data lineage.
- Profile data, assess quality and recommend remediation plans.
- Confirm business rules are implemented correctly and resolve gaps between documented and actual logic.
- Review backend data environments for design, performance and scalability.
- Document data assets with the BI Data Steward and advise on data dictionaries, metadata repositories and glossaries.
What they’re looking for
- 8+ years in database administration, data engineering, data architecture or data governance.
- Experience with enterprise databases and data platforms.
- Experience supporting analytics, reporting and data transformation work.
- Advanced SQL and database design skills.
- Strong understanding of relational databases and data modeling.
- Knowledge of data governance frameworks and data quality practices.
- Experience with ETL, ELT, data warehouse and BI environments.
- Understanding of metadata management and data lineage.
- Bachelor's degree in computer science, information systems, data management or a related discipline.
- Strong analytical and problem-solving skills, with attention to detail.
Nice to have
- A master's degree is preferred.
What’s on offer
- Base salary range of CAD 110,200 to 160,200 per year. In Ontario, the range is stated as total compensation, including vacation pay and target bonus.
- Medical, dental, vision, life insurance, matched retirement savings and a wellness program.
- Short and long-term disability, charitable contribution match, holidays, personal days, vacation and paid volunteer time off.
- Ongoing training, development and a tuition reimbursement program.
- Membership of one of ten Business Resource Groups.
Skills
Questions about this role
Where is this job located?
The role is in Etobicoke, Ontario, Canada, on a hybrid basis.
What salary does it pay?
The posted range is CAD 110,200 to 160,200 per year.
Do I need a degree?
A bachelor's degree in computer science, information systems, data management or a related discipline is required. A master's degree is preferred.