Electrical Safety Authority
The Electrical Safety Authority is seeking an IT Data Architecture Specialist
to join and support our growing IT Team.
About the Job
The IT Data Architecture Specialist will design and implement data solutions including complex relational databases and data warehouses. They will be called upon to provide expertise, recommendations and solutions in the areas of data modeling, data management and data quality. They will apply enterprise data governance principles and guide others for adhering; establish and implement processes for governing the identification, collection, and use of corporate metadata ensuring accuracy and validity. Work with software engineers, application vendors, and managed service providers to ensure enterprise Data warehouse solutions are reliable, scalable, flexible and low maintenance. Create, deliver and manage solutions to the business including reports, tools and processes to allow users to generate reports.
Job Type: Full-time, Permanent
- Competitive Salary
- Defined Benefit Pension Plan
- Dental Care
- Disability Insurance
- Employee Assistance Program
- Extended Health Care
- Life Insurance
- Vision Care
- Wellness Program
The ESA is one of Ontario’s leading employers. If you choose to join our team, you will be entering a safety and development focused environment where we will care about YOU as a member of our team and as an individual. We take care of our team members with an industry-leading benefits package and a defined-benefit pension plan, not to mention our competitive salaries.
We will help you build on your strengths, appreciate your diversity, provide opportunities for your development and challenge you to be your best. We will make sure you are clear on your accountabilities and have the right resources, systems and tools to achieve and succeed in your role.
The IT Data Architecture Specialist, needs to have a solid understanding of and ability to apply data governance principles and be able to guide others.
You understand and have experience in the areas of Data Modeling, Data Management and Data Quality. When you see the letters ETL you know it means Extract, Transform, Load. You know have a solid grasp of metadata management using best of breed data management and metadata management tools.
You need to be able to lead end-to-end design, build, process, and methods supporting enterprise-wide design, implementation, and documentation of data modeling & architecture solutions. You can oversee the expansion of existing data architecture and the optimization of data query performance via best practices. Evaluate data management platforms and solutions.
You can design, develop and maintain the Enterprise Data Model including the conceptual, logical, and physical data models for databases, operational data store, data warehouse, data marts, and data lakes on target platform
Procedure and Documentation Development
You will establish and steward the processes and procedures required to maintain traceability between all data sources and business interactions. Work with Business Analysts and others to document analytic requirements and translate them into technical solutions.
You have experience creating end-to-end blueprints for data warehouse projects.
Data is great, but the layperson needs to have access to it as well. You have the proven ability to communicate both with your IT teammates but also with non-technical individuals, whose approval or buy-in is essential to your projects.
Bachelor’s degree in information technology, Business administration, or equivalent. A Masters’s degree is an asset.
6 years of progressively responsible experience in data architecture and development.