Data Engineer

Venture outside the ordinary - TMX Careers

The TMX group of companies includes leading global exchanges such as the Toronto Stock Exchange, Montreal Exchange, and numerous innovative organizations enhancing capital markets.  United as a global team, we’re connecting cross-functionally, traversing industries and geographies, moving opportunity into action, advancing global economic growth, and propelling progress. Through a rich exchange of ideas, meaningful collaboration, and a nimble operating model, we're powering some of the nation's most critical systems, fueling capital formation and innovation, bringing increased opportunity to business visionaries, product ingenuity to consumers, and career exploration to our team.

Ready to be part of the action?

We are hiring! If you are a seasoned and motivated Data Engineer this is the perfect opportunity to join our growing team of Datalinx Squad & Enterprise Data and Advanced Analytics. Self-directed and comfortable supporting multiple teams, systems and products across a full spectrum of technologies. The role will focus on Datalinx product enhancements and application support.

This role will report to: the Head of Enterprise Data & Analytics

Key Accountabilities:

• Provide subject-matter expertise in delivering the technical design, development, and implementation of complex technical solutions and ongoing sustainment of Datalinx Applications

• Collaborating with cross-functional teams and business partners to understand and analyze  requirements

• Assemble large, sophisticated data sets that meet functional / non-functional business requirements.

• Write clean, efficient, and well-documented code using relevant programming languages and frameworks

• Administration and management of all AWS services, such as S3 buckets, RDS databases, EC2 instances, EMR, VPC network, Security Groups, Cloud Formation stacks, CloudWatch, Managed Airflow, Simple Notification Services, etc.

• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AWS ‘big data’ technologies.

• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, performance, etc.

• Practice established development disciplines such as good code management, branching and merging of code in a GIT repository.

• Have relevant and highly developed professional and technical skills; experienced level of knowledge in field of expertise and strong knowledge of business/context

• Collaborate with external and internal clients, manage expectations and handle queries

• Be available for on-call and off business hours support on a rotation basis

Must haves:

• University degree, College diploma or relevant job experience in Computer Science, Statistics or Mathematics

• 5-8 years of overall IT experience and 4+ years in Perl programming language

• Good understanding of data warehousing and data modeling techniques

• Big Data technologies including Spark, Hive, Presto, etc.

• Experience in performance tuning for Spark jobs, Hive tables required

• Strong knowledge of AWS cloud technology and Hadoop implementation on AWS including S3, EC2 and EMR

• Experience in programming languages like python, scala

• Proficient in Oracle SQL,  PL/SQL and Database programming, Unix shell scripting

• Strong knowledge of Oracle, Postgress databases

• Experience with development using Agile methodologies

• Experience in Crystal report 2+ years and Java programming 4+ years

• Excellent interpersonal and communication skills

• Excellent analytical and problem solving skills; strategic thinker

• Strong analysis / design experience

• Meticulous attention to detail

• A self-starter with ability to follow through on projects assigned

Nice to haves:

• Good knowledge in Capital Markets business

• Experience in Crystal report

• Experience in Java programming

Note: Hybrid role - 2 days in the Toronto Downtown Office

In the market for…

Excitement - Explore emerging technology and innovation, as well as ventures and digital finance that shape the future of global markets! Experience the movement of the market while grounded in the stability of close to 200 years of success.

Connection - With site hubs in some of the world’s most multicultural cities, we leverage our size and structure to create rich connections and belonging while experiencing powerful global impact through our work.

Impact - More than a platform, we use our talents to power mission-critical systems that drive global economic advancement, innovation, and growth. As well, our employee-led Team Impact spreads social good via our giving strategy.

Wellness - From empathetic leadership to a culture of flexibility and balance, we believe wellness at work creates the maximum yield and a stronger “we”. Plus, with a cloud-first and hybrid workstyle, as well as generous time-off and leaves, we support a life well lived! 

Growth - From a growth mindset in our work, to expansion in our business, TMX is home to action-takers energized by the achievement of ambitious growth.

Ready to enrich your career with impactful work, leaders who truly care, and the flexibility and programs to help you thrive as part of #TeamTMX ? Apply now.

TMX is committed to creating and sustaining a collegial work environment in which all individuals are treated with dignity and respect and one which reflects the diversity of the community in which we operate. We provide accommodations for applicants and employees who require it.