Sr Support Engineer, Data & Analytics Operations - 1603

Job Title: Sr Support Engineer, Data & Analytics Operations

Duration: 6 months (Possibility of Extension/Conversion)

• Location:
• Toronto - Sheppard/North York (Atria). Preference for North York, but Waterloo is acceptable - preferred location
• Work Arrangement: Hybrid - expected onsite once per month for town halls and monthly team events (subject to change).
• Work Hours: Monday-Friday, flexible between 8:00-4:00, 8:30-4:30, or 9:00-5:00. Start time must be no later than 9:00 AM.

*Must be eligible for Reliability Clearance (Should have been in Canada for 5 years)

The Senior Support Engineer is a member of the Data & Analytics Operations Support team, which is responsible for supporting production applications within the Data & Analytics platform both on premise and in the Cloud.

The support that this team is responsible for is two-fold with concentration on core legacy applications to maintain and support processes in multiple Data Warehouses, Business Intelligence, Data Integration applications as well as be part of the exciting new world of Cloud technologies.

Our team is responsible for safeguarding our client’s data, making sure it is available and current when Advisors and Clients need it therefore, this role required 24x7 support on a rotational basis and is subject to Over Time.

In this role, to protect the data in which we support, we require Reliability Clearance Certification which is granted through the Government of Canada. This includes Enhanced Security Background checks and fingerprinting by the RCMP.

If you have a background or education in Computer or Data Science, Engineering, Software Development or IT Application/Technical support, this role may be for you.

Must Have Skills:

1. 4+ Years of experience with the following Cloud technologies is required:

· Big Data solutions preferably using Amazon Web Services (AWS) or equivalent Public Cloud

· AWS or equivalent Cloud Certifications

· AWS Glue, Lambda, Redshift, and Python/R

· Hive/Athena, EMR, S3 and querying in Linux and SQL Servers

· ETL Tools; Informatica (IICS) on premise or Cloud (IDMC)

· Very large data sets, ability to build programs that leverage distributed computing

· DevOps tooling; BitBucket, CICD Pipeline, Ansible, Jenkins

· GitHub Copilot

· SQL Scripting

2. 4+ Years of experience with the following Datawarehouse & Analytics technologies is required:

· Datawarehouse (DW) and Business Intelligence (BI) environments

· ETL Tools: Informatica PowerCenter/Informatica Intelligent Data Management Cloud (IDMC)

· Databases: Microsoft SQL Server, Oracle, DB2, flat files

· Knowledge/Experience in Windows and Unix

· SQL Scripting

· SAP technologies: Universe Designer, Web Intelligence, Crystal Reporting

Nice to have Skills

1. Generative AI

2. Agentic AI

3. Mainframe technologies; TSO, ZEKE, JCL, COBOL

Operations Lead Support:

• Work with stakeholders, business leaders to influence, impact, and deliver on operational improvements, incidents, assignments & solutions that are complex and strategic in nature.
• Act as Operations Lead as part of project/development teams to:
• Schedule implementation of changes to meet overall schedule of the project and mitigate risk of customer experience impacts due to changes
• Lead, monitor, identify and implement operational improvements
• Develop an understanding of the business applications supported as well as the business direction

Day to Day Competencies:

· Maintain and support end-to-end application operations

• Perform performance tuning for queries, applications, and resources across the technology stack
• Use excellent analytical skills to dive into the processes we support to resolve complex data discrepancies or job failures
• Monitor and support jobs and application performance
• Monitor, identify and implement operational improvements

· Ensure compliance with Incident, Problem and Change Management policies and processes

• Deploy enhancements to production using DevOps tooling

· Ensure appropriate prioritization and resolution of defects in accordance with agreed upon SLA

· Provide on-going communication to key stakeholders to ensure they are aware of significant changes in a timely manner

• Provide technical documentation that includes design and operational support documentation
• Deliver innovative solutions by leveraging data and technology

· Engage, influence and work collaboratively with Project Teams, Operation teams and vendors

· Develop an understanding of the business applications supported as well as the business direction

• Strong inclination to proactively share knowledge and expertise with others to build the support engineering community and capability in the broader company around data
• Provide coaching and advice to less experienced engineers and other Sr. Engineers.
• Lead and deliver Innovative solutions and projects from conception to delivery by leveraging Data and Technology
• Utilize excellent communication skills to engage, influence, negotiate and collaborate with Project Teams, Operation teams and vendors

Interview Process

· 1 interview - virtual