Data Engineer

Position Title: Data Engineer

Department: Data Management

Location: Toronto

Status: Permanent Full-Time (Hybrid)

Day in the life of:

We are seeking a highly motivated and experienced Data Engineer to join our growing team. In this role, you will play a critical part in designing, building, and scaling our next-generation data platforms. The successful candidate will be responsible for setting up and maintaining data pipelines for ingestion and consumption, ensuring data integrity, and optimizing data workflows across on-premise systems and Azure-based resources. 

Core Responsibilities:

• Architect, design, and implement high-performance data pipelines and ETL processes. 
• Develop and maintain data infrastructure and platforms using Azure technologies, ensuring scalability, reliability, and security. 
• Work closely with stakeholders across business and technology teams to understand requirements and translate them into technical solutions. 
• Stay abreast of industry trends and emerging technologies, identifying opportunities to enhance our data and analytical capabilities. 
• Champion and implement best practices for data engineering, including data modeling, data quality, pipeline optimization, SDLC management, and performance tuning, within a collaborative team environment. 

Key Skills and Competencies:

Must-haves

• Degree in computer science, information sciences, or equivalent relevant experience 
• 5+ years of experience in data engineering, with a proven track record of building and scaling data-intensive applications. 
• Deep understanding of data warehousing concepts, dimensional modeling, and ETL best practices. 
• Proven ability to drive data initiatives to align technical solutions with business needs. 
• Strong proficiency in SQL and Python and at least one other language like Java, or Scala and experience working with large-scale datasets. 
• Hands-on experience with SQL Server based data technologies such as SSIS, SSRS, SSAS, and Azure based technologies such as DevOps for CI/CD, Azure Data Factory, Azure Databricks, Unity Catalog. 
• Experience with the Azure Cloud Platform, including data storage, processing, and analytics services. 
• Familiarity with data modeling tools and techniques. 
• Experience with data visualization tools such as PowerBI (with deployments spanning an on-prem server and the cloud service). 
• Experience collaborating in cross-functional teams of business stakeholders, data scientists / analysts, and software engineers to define and implement data strategies that support analytical and operational needs. 

Nice to Haves

• Experience in Capital Markets or Financial Services is an asset. 
• Experience with data governance and data privacy best practices is an asset. 
• Passion for data and a strong desire to solve complex problems. 

What we offer:

• Competitive base salary in alignment with market
• Performance based bonus
• Hybrid work environment
• Employer paid Health Benefits and Spending Account that offer flexibility to meet your individual or family needs as of day one.
• Defined Contribution Pension Plan with company matching that starts on your first day of employment.
• Paid flex days and sick days
• Vacation days
• Maternity Leave Of Absence /Paternity Leave Of Absence top up
• Paid continuous learning and continuing development including designations.

Why the Canadian Investment Regulatory Organization (CIRO):

Our purpose and our impact: 

With offices across Canada - from Vancouver to Montreal, our mission is to promote healthy capital markets by regulating fairly and effectively so that investors are protected and confident investing in their futures. As a regulator, we understand that we are all investors. Therefore, a career with us is a career with purpose, protecting our future. 

Culture and Working Environment:

Life at CIRO is purpose and performance- driven. We foster an inclusive culture where teamwork, a forward-thinking attitude, and integrity are at the core of everything we do. This creates an environment where employees thrive, grow, and are empowered to learn and contribute their best. 

Joining CIRO means becoming part of a dynamic and transparent organization that values accountability and is committed to maintaining the highest standards of regulatory oversight in the financial industry. 

Looking for a career where you can safeguard the integrity of Canadian markets? Join CIRO and be part of the team that secures our financial future. 

Our Commitment: 

CIRO is an equal opportunity employer and is committed to providing employment accommodation in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act, 2005 (AODA). CIRO will provide accommodation to job applicants with disabilities throughout the recruitment process. Should you require accommodation, please contact Human Resources. 

CIRO is a pan-Canadian organization that oversees all investment dealers and trading activity in marketplaces across Canada. This position requires the ability to communicate with employees in CIRO regional offices and other CIRO stakeholders across Canada. Accordingly, proficiency in both official languages of Canada (French and English) is needed. Due to the frequent interactions with internal and external English-speaking members, clients, representatives, firms, Canadian provincial and territorial securities regulators, and employees situated outside of Quebec, the position requires a fully bilingual candidate. 

While we appreciate receiving applications, only those applicants who closely meet the position requirements will be contacted. 

#LI-HYBRID #hiring