Senior Data Architect

 

Description:

You are as unique as your background, experience and point of view. Here, you’ll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll have new and exciting opportunities to make life brighter for our Clients - who are at the heart of everything we do. Discover how you can make a difference in the lives of individuals, families and communities around the world.

What will you do?
 

  • To present ideas, expectations, and information in a concise, well-organized way using excellent judgement, technical insight, and to think out of the box.
  • Provide technical and data leadership to the application development group, IT, and the enterprise.
  • Develop and maintain conceptual, logical and physical data models.
  • Create & maintain data architecture, data management standards and conventions, data naming standards, and metadata standards.
  • Develop and implement standards and processes for ensuring data quality.
  • Collaborate with domain and enterprise architects for delivery in compliance to strategic enterprise direction.
  • Contribute to analysis, solution design, development and implementation of operational and data warehouse projects.
  • Perform high level and detailed design activities and create specifications for operational and data warehouse projects.
  • Participate in ETL design, strategy and associated processes.
  • Validate and comply with the defined data architecture.
  • Be conversant with and cognizant of the future direction of systems, impact to the enterprise and how future and current systems can be exploited for the benefit of the enterprise.
  • Recognize and identify potential areas where existing policies and procedures require change, or where new ones need to be developed, especially regarding future business expansion.
  • Provide input and consulting support on projects and road maps for compatibility with the enterprise vision.
  • Work closely with key client and IT stakeholders in understanding business needs and recommend solutions.
  • Understand business requirements and translate them to the enterprise data and process models.
  • Lead logical data model workshops with business users to derive at a logical data model that correctly reflects the business.
  • Setup the physical data model including all physical database configurations such as indexes, tablespaces, table partitions, table constraints, relationships, etc.
  • Generate DDL script from data modelling tool and to ensure the script’s proper function.
  • Coordinate with database administrators the physical construction of databases for projects and maintenance.
  • Understand RDBMS concepts especially in the area of database optimization.
  • Contribute to database tuning and performance enhancement at a server and database level.
  • Stay current on assessments of technology for the business.
  • Fulfill departmental requirements in terms of providing work coverage and administrative notification during periods of personnel illness, vacation, or education.
     

 

Organization Sun Life
Industry IT / Telecom / Software Jobs
Occupational Category Senior Data Architect
Job Location Ontario,Canada
Shift Type Morning
Job Type Full Time
Gender No Preference
Career Level Experienced Professional
Experience 10 Years
Posted at 2023-11-07 12:03 pm
Expires on 2024-12-24