Senior Data Engineer - Snowflake/Azure (Hybrid)

Your Moneris Career - The Opportunity

As the Senior Data Engineer, you will create data collection, extraction, and transformation frameworks for structured and unstructured data. You will develop data infrastructure systems (e.g. data warehouses, data lakes) including data access points; prepare and manipulate data using Kafka, Talend, MS SQL, Azure Data Factory and other data pipeline tools.

You will also organize data into formats and structures that improve reuse and efficient delivery to businesses and analytics teams and system applications, integrate data across data lake, data warehouse and systems applications to ensure the delivery of information across the enterprise and be accountable for efficient architecture and systems design.

Location: You will be based in our Toronto office, balancing in-office collaboration with remote flexibility.

Reporting Relationship: You will report to the Manager, Data Engineering.

Posting Type: Replacement Position.

Salary Range: The expected base salary range for this role is $106,202 - $148,682.

Total compensation may also include variable or discretionary incentive components, including but not limited to bonuses and commissions. Individual job offers are determined by various factors, including experience, education, skills, certifications, and other business needs.

Your Moneris Career - What you'll do

• Lead the architecture, design and implementation of complex data architecture and integration solutions including best practices for the full development life cycle, coding standards, code reviews, source control management, build processes, testing, and operations.

• Build and evolve the data service layer and engage the team to bring together components for an outstanding customer offering. Experienced in assessing overall data architecture and integrations and making ongoing improvements to the solution offering.

• Engage with partners to establish clear needs and links to solutions, including setting up prototypes, and involving multiple parties in design sessions.

• Develop Data Pipelines using modern tools.

• Create efficient load processes including logging and handling of exceptions, notification to support, and overall visibility operations.

• Perform database monitoring, collaborate with database administrators to optimize database performance.

• Lead the analyses of database entities, relationships, and attributes to determine efficient design solutions according to needs.

• Collaborate with company partners to ensure adherence to standards for code, design, documentation, testing and deployment.

• Collaborate with data governance and strategy to ensure data lineage is well understood and constructed in a way to highlight data reuse and simplicity.

• Assess new opportunities to simplify the data operation with new tools, technologies, file storage, management, and process. Use team context and experience to evaluate these opportunities and bring them forward to team members for assessment and implementation.

Your Moneris Career - What you bring

• Minimum of 7-10 years of experience working in data engineering and/or building and managing data platforms and/or in an R&D environment building proof of concept data solutions for the business

• Minimum of 4 years of experience in Architecting data solutions (either leading this or being in a support role and growing into a role to lead this)

• Ideal candidate will have experience in an R&D style environment where you are given a problem from the business, you ideate potential solutions and create a proof of concept/MVP to evaluate the potential solutions. Once it has been agreed on by the business, it can then be productionized

• Ability to design and engineer moderately complex enterprise solutions.

• Proficient in data management, governance, data design and database architecture.

• Experience manipulating, processing and extracting value from large, disconnected datasets.

• Proficient in data modelling, data integrations, data orchestration, and supporting methodologies.

• Strong stakeholder communication - updating on progress, understand problem and build requirements from that, ability to propose solutions and convince other stakeholders

Nice-to-have...

• Demonstrated proficiency in Snowflake, Talend, DBT, Kafka, Active Batch, Azure DataBricks, Python, SQL

• Design and maintain scalable, event-driven data ingestion patterns to ensure near real-time data availability in the Lakehouse/Warehouse.

• Knowledge of Business Intelligence, Analytics and Reporting

• Build Dashboards and Data Visualizations (PowerBI, Collibra)

• Experience working with DevOps pipelines (Git, Maven, Gitlab, Jenkins), continuous integration/delivery, automated testing (unit, functional, performance)

Your Moneris Career - What you get

• Comprehensive Total Rewards Program including bonuses, flexible benefits starting from day 1, and your choice of either a health spending account (HSA) or personal spending account (PSA).

• RRSP matching & defined contribution pension plan.

• Learning & development programs and resources including unlimited free access to Coursera and an Educational Assistance Program.

• Holistic approach to your well-being, with an Employee Assistance Program for you and your family, access to 24/7 virtual health care, wellness events and a supportive workplace culture.

• A workplace committed to investing in Diversity, Equity and Inclusion (DEI) through various initiatives including, employee inclusion groups (EIGs), mentorship, DEI learning and workshops, educational events, and various resources including an internal DEI website and newsletter.

• Company-wide paid year-end closure & personal time off (including religious, personal, and volunteer days).

Find out more about the work perks and benefits you get as a Moneris employee at Moneris.com/careers.

AI Disclosure: We may use AI-enabled tools to screen, select, and assess applications. All AI outputs are reviewed and validated by our recruitment team.

#LI-Hybrid

#TECH-IND

Note: We welcome and encourage applications from Indigenous peoples, people of colour, people with disabilities, people of all genders, sexual orientation and intersectional identities.

We acknowledge that people from equity-deserving groups (including racialized individuals, women, gender diverse individuals, individuals with disabilities, neurodivergent individuals, members of 2SLGBTQIA+ communities and those born outside of Canada) are less likely to apply for jobs unless they feel they meet all the requirements posted. At Moneris, we believe candidates bring experience to their work in many ways. We encourage you to apply and share, in the application form, the transferrable experience you bring, and how this will support your success in this role.