Sr. Azure Data Engineering Specialist -Databricks and Synapse

Category: Analytics and Emerging Digital Technologies
Main location: Canada, Ontario
Alternate Location(s): Canada, Alberta,
Canada, Manitoba,
Canada, New Brunswick,
Canada, Saskatchewan,
Canada, Quebec,
Position ID: J0524-1102
Employment Type: Full Time

Position Description:

This role can be situated within proximity to a CGI office

Are you an experienced Azure Data Engineering professional interested in working in a talented and collaborative team developing Cloud, Data and AI solutions for leading global clients? Do you regularly find yourself in conversations on disparate and dispersed data sources and feel the need to create a robust data engineering infrastructure to sort that mess out? If you have that technical expertise of building pipelines and enabling data engineering or ETL in organizations, a genuine flair for solving problems, and the mindset to collaborate with diverse clients and team members alike, we're looking for you.

**Expertise in Azure Databricks and Synapse experience is mandatory for this role**

Your future duties and responsibilities:

• Delivering on areas of data preparation and transformations and ETL or ELT development on Azure - Azure Data Factory (ADF), Synapse, Azure Databricks, Azure Data Lake (ADLS), Azure SQL database, Azure SQL Datawarehouse
• Building Streaming Data pipelines with Databricks
• Working in a business environment with large-scale, complex and big data datasets and dispersed data sources
• Using SQL or Advanced SQL and Python skills as necessary
• Gathering client requirements, coding and building Data Engineering pipelines in Azure
• Implementing proof of concepts to show value and then package and scale to full data engineering scale on both on-prem and cloud environments
• Strategically collaborating with the clients to explore data sources and build Power BI dashboards with Azure Data Engineering
• Supporting and collaborating with the other Data Engineers or Data Scientists in the team with technical knowledge

Required qualifications to be successful in this role:

• Azure Databricks and Synapse experience is mandatory
• Building streaming pipelines on Azure experience is mandatory
• Total 5-7+ years’ experience in Data Engineering is required to apply to this role
• 3 years or more in Azure Data Engineering
• Data analysis, storage, data pipelines, and orchestration
• Expert Python and SQL skills
• Experience working on Big Data

Nice to Have Qualifications

• Experience in data engineering with ML projects
• Experience with data pipeline and workflow management tools eg. Airflow, Jenkins etc.
• Experience working with Spark/ Hive/HDFS
• Experience in building strong Power BI Dashboards with DAX queries, Power Apps, Power Automate, and Logic Apps


  • Azure Data Lake

What you can expect from us:

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 recognize the richness that diversity brings. We strive to create a work culture where all belong and collaborate with clients in building more inclusive communities. As an equal-opportunity employer, we want to empower all our members to succeed and grow. If you require an accommodation at any point during the recruitment process, please let us know. We will be happy to assist.

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