Jobs.ca
Jobs.ca
Language
CGI logo

Azure Data Solution Designer

CGI1 day ago
Hybrid
Toronto, ON
Mid Level
full_time

About the role

This role is hybrid and requires you to be at our / client office at a minimum of 5 days per month- subject to change at any time.

We are looking for a seasoned Azure Data Solution Designer to join a leading banking client in Toronto. In this role, you will lead the design of robust, scalable, data-intensive applications and platforms on the Azure data ecosystem, including batch and near-real-time processing. You will work closely with business SMEs, enterprise and solution architects, data engineers, QA teams, and cloud infrastructure teams to define end-to-end solutions across data ingestion, processing, storage and consumption layers.

This position requires strong hands-on familiarity with the Azure data stack, excellent communication skills, and the ability to guide engineering teams through design execution. You will ensure that your designs meet financial-industry-grade non-functional requirements such as performance, scalability, observability, security, resilience, and cost optimization.

Your future duties and responsibilities

  • Collaborate with business SMEs, product owners and architects to understand business processes and transform requirements into application and integration designs on the Azure data platform.
  • Define end-to-end solution designs for ingestion, processing, storage, and consumption layers leveraging Azure Data Lake, Azure Databricks/Spark, Azure Data Factory and Synapse.
  • Produce and maintain critical design artifacts, including high-level and low-level solution design documents, component and integration diagrams, data/process flow diagrams, and interface contracts.
  • Design source-to-target (S2T) mapping for data and control flows, ensuring business processes map clearly to technical components and operational jobs.
  • Work closely with data engineering teams to ensure designs translate correctly into Databricks jobs, ADF pipelines, error handling, scheduling and operational components.
  • Ensure all designs meet non-functional requirements including performance SLAs, scalability, resilience, recoverability, monitoring/alerting, governance, security and compliance.
  • Partner with cloud/platform teams on environment setup, identity and access, networking, and security required to support design implementation.
  • Review implementation details (code, pipelines, Spark jobs, configurations) to confirm alignment with design, standards and best practices.
  • Support SIT/UAT phases by clarifying design intent, defining test scenarios, and assisting with defect triage and issue resolution.
  • Contribute to design standards, reusable patterns, frameworks and shared components for the Azure data platform.

Required qualifications to be successful in this role

o Significant experience (7+ years) in solution or application design for data-intensive platforms (batch and near-real-time).
o Hands-on experience with Azure Data Lake, Azure Databricks/Spark, Azure Data Factory/Synapse.
o Strong understanding of ETL/ELT, API integration, messaging/event-driven patterns, and file-based ingestion.
o Experience designing end-to-end data flows across landing, curated and consumption layers in cloud data platforms.
o Proficiency in SQL, PySpark and Spark for collaborating with engineering teams and reviewing technical implementations.
o Strong understanding of performance, scalability, observability, reliability, security and cloud cost optimization.
o Familiarity with Azure security (IAM, MSI, Key Vault, RBAC, network isolation, data masking).
o Experience with modernization and migration initiatives (on-premises to Azure, ETL re-platforming).
o Strong leadership capabilities and ability to guide small development teams.
o Excellent communication and stakeholder management skills.

  • Preferred Qualifications

o Azure certifications (Solutions Architect, Data Engineer, Fundamentals).
o Financial-services or banking industry experience.
o Exposure to Data Mesh concepts, data product design or event-driven architectures.
o Experience with cloud cost management, monitoring/observability and large-scale data platform operations.
o Bachelor's degree in Computer Science, Engineering, Information Systems or related field.

#LI-GS!

Together, as owners, let’s turn meaningful insights into action.

Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…

You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.

Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.

You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

At CGI, we value the strength that diversity brings and are committed to fostering a workplace where everyone belongs. We collaborate with our clients to build more inclusive communities and empower all CGI partners to thrive. As an equal-opportunity employer, being able to perform your best during the recruitment process is important to us. If you require an accommodation, please inform your recruiter.

To learn more about accessibility at CGI, contact us via email. Please note that this email is strictly for accessibility requests and cannot be used for application status inquiries.

Come join our team—one of the largest IT and business consulting services firms in the world.

About CGI

IT Services and IT Consulting
10,000+

Insights you can act on to achieve trusted outcomes.

We are insights-driven and outcomes-focused to help accelerate returns on your investments. Across 21 industry sectors and 400 locations worldwide, we provide comprehensive, scalable and sustainable IT and business consulting services that are informed globally and delivered locally.

We value your opinions and welcome your comments and questions on our posts here on LinkedIn. Please keep a polite, professional and constructive tone. We remove comments containing objectionable language and derogatory views. We do not allow content that is unrelated to the subject, and we remove discriminatory and racist comments as well as spam and advertising.

Note that content on this page contains general information regarding CGI’s services and initiatives and should not be considered direct business advice. To engage in a discussion with one of our experts, please make a request through https://www.cgi.com/en/contact-us