Senior Data Architect

Contract
Ottawa
Posted 2 months ago

We have an excellent 9 Months contract opportunity for a Senior Data Architect in Ottawa.
Work would be done remotely until the pandemic situation normalizes.

Must Have:
• Reliability level Federal Security clearance is mandatory.
• Expertise in data standards and data management skills including data modeling and information integration
• Understanding of Data Integration Frameworks and Patterns
• Experience and Understanding of Client Management, Solution design.
• Familiar with System Development Life Cycle, design, and development of data delivery services within medium to highly complex application environments.

If you are available, please send your resume to bakul.jain@2iresourcing.ca OR deepti.gill@2iresourcing.ca OR refer someone interested

Description:
TITLE
Senior Data Architect

Job Posting Start Date: 12/13/2021
Job Posting End Date: 09/30/2022

DURATION AND POTENTIAL START DATE
• 9 Months
• Potential Start Date: Dec. 13th, 2021.

Site: Ottawa
Location: March Road

SCOPE
Working in the Data Analytics Team under Enterprise Architecture, the Data Architect provides consultation and expertise to drive the data architecture function.
– Integrate data from our source systems into our Teradata Data Warehouse ensuring best practices and standards are followed.
– Work with end users to understand business requirements and identify appropriate data solutions.
– Participate in the development, evolution and oversight of the overall vision for Information Lifecycle of the corporation and clients by collaborating with management, staff and stakeholders on data strategy, architecture, rationalization, quality and analytics to support strategic business initiatives

DUTIES
• Lead Data Solution definition: review design artifacts, develop POC solutions, determine, understand, and validate data and requirements with close collaboration with Data Governance, Business Stakeholders and Innovapost Partners
• Maintain and support data architecture framework, patterns and principles, naming conventions, datatype standards
• Provide Data Sizing estimates by providing data growth and volume estimates in a timely manner
• Contribute to project estimates by documenting Data Architecture deliverables, conditions for completion, and assumptions taken for the estimate
• Identify Domains, create Database Objects, Logical Data Models, Physical Data Models, generate DDL
• Responsible for Data Profiling of new proposed data as well as an understanding of existing data
• Responsible for all project design documentation for development initiatives including Project Briefings, Functional Designs, Technical Designs, Data Transformation rules, information required for Handover to Support
• Ensure the Delivery Teams are fully supported through the project lifecycle and fully understand the design of the solution
• Collaborates and provides guidance to the broader architecture community and delivery teams on data integration standards and best practices
• Support Data Governance: understand data governance rules, catalogue data, metadata management, impact assessments
• Work with our Business Partners and Support team(s) to triage data integrity issues
• Support software and hardware upgrades
• Collaborate with Data Governance to ensure the Safety and Soundness of our Data by ensuring proper security is in place according the Classification rules
• Metadata Management in accordance with DGO standards

SKILLS AND EXPERIENCES
Must Have:
• Expertise in data standards and data management skills including data modeling and information integration
• Understanding of Data Integration Frameworks and Patterns
• Client Management: consolidate business data requirements and translate into sound data architecture
• Data Management: design, development, and maintenance of enterprise level data systems
• Solution design: workflow concepts and integration of data in a cross application environment
• Considerable experience in a variety of Relational Databases and understands data at an Enterprise level
• Application development concepts: familiar with System Development Life Cycle, design, and development of data delivery services within medium to highly complex application environments
• Ability to understand the impact of a change at an Enterprise level (Impact Analysis)
• Sees the bigger picture and designs solutions with the Enterprise in mind, and not just at the Project level

Nice to have:
• Knowledge of data capabilities, functions, features and facilities of relevant application platforms (e.g. Client Vision, Frontier, SAP)
• Teradata expertise
• Stored procedures
• Teradata Utilities

Soft Skills:
• Team player
• Ability to communicate technical information to a non-technical audience
• Ability to prioritize conflicting priorities
• Ability to work in a fast-paced agile development environment

LOCATION OF WORK
Currently remote: official locations are Mississauga, Toronto, and Ottawa (March Road).
Contractors are asked to show proof of vaccination at the front door. Masks should be worn at all times while being inside the office and social distancing is encouraged.

HOURS OF WORK
37.5 hours/week

TRAVEL REQUIREMENTS (if applicable)

Apply Online

A valid email address is required.
A valid phone number is required.