We have an excellent 9 months contract opportunity for a Senior Data Architect in Ottawa/Toronto.
This is a Hybrid work model.
Must haves:
• Eligible for Reliability level Federal Security clearance is mandatory.
• 10+ years of progressive IT experience, 7+ years architecting and integrating data into an enterprise data warehouse.
• Enterprise data warehouse experience with Teradata or equivalent platform, must be hands-on and able to work with the Teradata Studio environment or directly with DDL.
• Strong SQL for data analysis and data profiling.
• Data modeling in erwin or similar tools
If you are available, please send your resume to [email protected] OR [email protected] OR [email protected] OR refer someone interested.
Job Posting Title: Data Architect – Senior
Description: Job Title: Data Architect – Senior
Seniority: Senior
Contract Length: 9 Months
Location: Mississauga, Ottawa, or Toronto – hybrid remote environment
SCOPE
The client is heading into peak season, the Data Analytics team is receiving an unprecedented number of requests for work packages. These requests require Impact Analysis and estimates for both Tower and CPC requests which require dedicated resources to work with the business, understand requirements, and delve into the code and database design. You will be learning client’s business areas while improving our ability to deliver project solutions.
DUTIES
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
• Work on technical debt projects and with the Assessment team, using our estimating template to ensure all intakes for ERP, NGTT, and Towers are completed in a timely manner so that funding can be secured, and the Product Teams on Data Analytics have visibility into the resources and timelines for the intakes.
SKILLS AND EXPERIENCES
• Understanding of Data Integration Frameworks and Patterns
• Expertise in data standards and data management skills including data modeling and information integration
• Solution design: workflow concepts and integration of data in a cross-application environment
• 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
Must have
• 10+ years of progressive IT experience, 7+ years architecting and integrating data into an enterprise data warehouse
• Enterprise data warehouse experience with Teradata or equivalent platform, must be hands-on and able to work with the Teradata Studio environment or directly with DDL
• Strong SQL for data analysis and data profiling
• Data modeling in erwin or similar tools
• Undergraduate degree in engineering, computer science, business, or equivalent (required), Graduate degree in Business Administration (MBA) (Asset)
Nice to have:
• Knowledge of data capabilities, functions, features and facilities of relevant application platforms (e.g. Client Vision, Frontier, SAP)
• Stored procedures
• Teradata Utilities
• On-prem to Cloud Migration
• Cloud-based data management tools