Big Data Engineer

Job description

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 seeking a seasoned and motivated Big Data Engineer to join our growing Enterprise Data and Advanced Analytics Platform team. The ideal candidate is an expert data pipeline builder and data wrangler who thrives on optimizing data systems and architecting them from the ground up. You are a self-directed professional, comfortable supporting the diverse data needs of multiple teams, systems, and products across a full spectrum of cutting-edge technologies. This role reports to: Senior Manager, Data & Analytics & Enterprise Data Architect Job Location: Hybrid (2-3 days in office) - based in Toronto, ON. Key Accountabilities Architect & Maintain Pipelines: Design, construct, and manage robust, large-scale, and efficient data pipeline architectures to meet complex functional and non-functional business requirements. Process Optimization: Drive continuous internal process improvements by automating manual tasks, optimizing data delivery, and re-designing infrastructure for enhanced scalability and performance. Cloud Infrastructure Management: Administer and manage a comprehensive suite of AWS services, including S3, RDS, EC2, EMR, VPC, Security Groups, CloudFormation, CloudWatch, Managed Airflow, and SNS. Data Ingestion & ETL: Develop optimal infrastructure for Extract, Transform, and Load (ETL) operations from disparate data sources using SQL and AWS ‘big data’ technologies, with a focus on both bulk and streaming data. Engineering Excellence: Adhere to development best practices, ensuring meticulous code management, branching, and merging within GIT repositories. Operational Support: Provide on-call and off-business hours support on a rotational basis to ensure system reliability. Collaboration & Mentorship: Act as an effective team player and mentor to junior staff through technical reviews and brainstorming sessions, while expertly managing stakeholder expectations and inquiries. Must Have(s) Education: University degree, College diploma, or equivalent experience in Computer Science, Statistics, or Mathematics. Experience: 5-8 years of overall IT experience, with 4+ years specifically focused on Big Data technologies (Spark, Hive, Presto, etc.). AWS Expertise: Strong technical proficiency in AWS cloud technologies, specifically S3, EC2, and EMR. Data Platforms: Proven experience working with Snowflake. Programming: Proficiency in Python, Scala, Shell Scripting, or Java. Data Modeling: Solid understanding of data warehousing and data modeling techniques. Performance Tuning: Hands-on experience in performance tuning for Spark jobs and Hive tables. Agile Delivery: Experience working within Agile development methodologies. Soft Skills: Meticulous attention to detail, excellent analytical problem-solving skills, and superior interpersonal communication abilities. Nice to Have(s) Domain Knowledge: Good understanding of the Equity Markets business. DevOps Tools: Experience with Terraform or Ansible. Streaming: Experience with Kafka. Machine Learning: Experience designing technology stacks tailored for machine learning. Strategy: A strategic mindset with the ability to multitask in a fast-paced environment. Salary Range: 100,000/year - 120,000/year CAD. Please note that the salary range included is a guideline only. The salary offered may vary based on factors, including, but not limited to, the successful candidate’s relevant knowledge, skills, and experience. The recruiting efforts for this role are intended to fill a vacant position. 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. Please note that our company is not currently sponsoring work permit applications and the applicant must be authorized to work in the country where this position is located. 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 .