Data Architect - Vice President

Citi; Mississauga; On-site; CAD 100,000 - 130,000; Full time

Job summary

A leading financial services company is seeking a Data Architect in Mississauga. This senior role requires designing and implementing data models, overseeing data warehousing strategies, and ensuring data governance. The ideal candidate should have over 6 years of experience in software development, proficiency in data modeling and warehouse technologies, and strong leadership skills. You will lead a team, collaborate with stakeholders, and remain updated on industry trends to provide innovative data-driven solutions. This position offers a unique opportunity to impact major business priorities and lead within a dynamic technology environment.

Qualifications

• 6+ years of professional experience in software development.
• Experience in finance industry is preferred.
• Expertise in various data modeling techniques, including relational, dimensional, and NoSQL.
• Strong understanding of data warehousing concepts and experience with data warehouse design and implementation.
• Proficiency in designing and implementing Extract, Transform, Load (ETL) processes.
• Extensive knowledge of various DBMS platforms, such as SQL Server, Oracle, and MySQL.
• Familiarity with big data technologies like Hadoop, Spark, and NoSQL databases.
• Experience with various BI tools and technologies including Tableau, Power BI, and MicroStrategy.
• Understanding of data governance principles and best practices.
• Experience with cloud-based data platforms like AWS, Azure, and GCP.

Responsibilities

• Design and implement data models that meet business requirements.
• Develop data warehousing strategies to support business intelligence and analytics.
• Define and enforce data quality standards and security protocols.
• Collaborate with data scientists, engineers, and business analysts.
• Research and recommend appropriate data management technologies.
• Manage the process of migrating data from legacy systems.
• Monitor and optimize data infrastructure performance.
• Stay up to date with developments in data management technologies.

Skills

Software development

Data modeling techniques

Data warehousing concepts

ETL processes

AI principles

Various DBMS platforms

Big data technologies

Business intelligence tools

Data governance principles

Cloud computing

Communication and collaboration

Education

Bachelor’s degree or equivalent experience

Master’s degree

Tools

SQL Server

Oracle

MySQL

Hadoop

Spark

Tableau

Power BI

MicroStrategy

AWS

Azure

GCP

Job description

We are seeking a highly skilled and experienced Data Architect (Applications Development Technology Lead Analyst - C13) to join our Mississauga location. This senior-level position is responsible for delivering on major business priorities within the Client Delivery Platforms by establishing and implementing new or revised application systems and programs in coordination with the Technology team. The overall objective of this role is to lead applications systems analysis and programming activities.

This role will play a critical part in designing, developing, and maintaining data pipelines within and across our applications. You will lead a team of talented engineers, providing technical guidance and mentorship, and ensuring the successful delivery of high-quality solutions. This position requires a deep understanding of data technologies, strong leadership skills, and a passion for data-driven decision-making.

Key Responsibilities

• Design and implement data models: Develop conceptual, logical, and physical data models that meet business requirements.
• Develop data warehousing strategies: Design and implement data warehouses and data lakes to support business intelligence and analytics.
• Establish data governance policies: Define and enforce data quality standards, access controls, and security protocols.
• Collaborate with stakeholders: Work with data scientists, engineers, and business analysts to understand data needs and translate them into technical solutions.
• Evaluate and select data management tools: Research and recommend appropriate data management technologies and tools.
• Oversee data migration and integration: Manage the process of migrating data from legacy systems to new platforms.
• Performance tuning and optimization: Monitor and optimize data infrastructure performance to ensure efficient data access.
• Stay up to date with industry trends: Keep abreast of the latest developments in data management technologies and best practices.
• Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.

Skills & Qualifications

• 6+ years of professional experience in software development.
• Experience in finance industry is preferred.
• Data Modeling: Expertise in various data modeling techniques, including relational, dimensional, and NoSQL.
• Data Warehousing: Strong understanding of data warehousing concepts and experience with data warehouse design and implementation.
• ETL Processes: Proficiency in designing and implementing Extract, Transform, Load (ETL) processes.
• Sound understanding of AI principles and how to architect data solutions to incorporate AI tools and techniques.
• Database Management Systems (DBMS): Extensive knowledge of various DBMS platforms, such as SQL Server, Oracle, and MySQL.
• Big Data Technologies: Familiarity with big data technologies like Hadoop, Spark, and NoSQL databases.
• Business Intelligence: Experience with various BI tools and technologies including Tableau, Power BI, MicroStrategy, etc.
• Data Governance: Understanding of data governance principles and best practices.
• Cloud Computing: Experience with cloud-based data platforms like AWS, Azure, and GCP.
• Communication and Collaboration: Excellent presentation, communication and interpersonal skills to effectively collaborate with stakeholders.

Education

• Bachelor’s degree/University degree or equivalent experience
• Master’s degree preferred

This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.

Equal Opportunity Employer

Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.
If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity, view Accessibility at Citi. View Citi’s EEO Policy Statement and the Know Your Rights poster.