Enterprise Reporting Lead

Peoples Group - Toronto, ON (30+ days ago)

Apply Now

About Peoples Group:
Peoples Group is a boutique Financial Institution with offices located in Vancouver, Calgary, Toronto and Montreal that has been in the Canadian marketplace for over 30 years.

Our focus is on exceeding our customer’s expectations by providing exceptional customer service backed by extensive product knowledge and experience. We believe that people come first, everyone has strengths, and work should be inspiring, challenging, and fun.

When we opened our doors in 1985, our specialty was the origination of Residential and Multi-family mortgage products and the provision of short and long term guaranteed investment products. Since then, we have significantly grown our team and product line to provide innovative solutions for our clients, backed by years of industry expertise and rates which are consistently among the best in Canada.

About this Job:
The Enterprise Reporting Lead will have the opportunity to conceptualize, design and build the Peoples Payment Solutions and Peoples Card Services Enterprise Reporting Solution used daily by internal staff. The Lead will help define the technical roadmap of the team, providing thought leadership.

Sound like you? Here’s what you’ll need to demonstrate:

Strong written and verbal communication and the ability to manage various requests in a professional manner.

Customer focus (may be internal or external)

Follow up with customers to ensure their requests have been addressed. Work closely with clients on sensitive issues to rectify problems or improve their experience.

Problem solving

Investigate major challenges to improve effectiveness.

Job specific responsibilities

In an ever-changing business environment, you will be agile in seizing opportunities to pioneer ways to meet and exceed your responsibilities:

Enterprise Reporting (40%)

Design, deliver and run an AWS based data lake solution
Design and build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources.
Maintain, develop, and enhance data quality procedures and controls.
Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
Work closely with the business and technology teams to meet objectives
Exploring new innovations and technologies for future projects.
Interfaces with industry on current trends in business and information technology.
Provide feedback to the business about projects and initiatives that affect or need to be supported by the current operating environment

Leadership (30%)

Manage a small team of report writers, ETL developers and contractors to build, maintain our reporting solution
Assigning features and tasks to team members during projects and for post-production support.
Mentoring of peers on best practices, technological approaches, etc.
Assemble large, complex data sets that meet functional / non-functional requirements. Ingest data sets provided to team.
Design and develop automated tests to ensure solution quality, security, reliability and performance
Create and document data models to host client data for relational data, dimensional data, NoSQL, graph, unstructured data.

Operational (20%)

In conjunction with the other support teams, ensures the stabilization of current applications and the introduction of new items as appropriate.
Provide design and support operational reporting application support structure that meets the defined IT service levels and standards, and to meet or surpass business and customer expectations.
Support the information systems operation according to internal standards, external accrediting agency standards and legal requirements.

Compliance, Risk Management (10%)

Develop reporting and analytic solutions following industry best practices in regards to security and application architecture
Adhere to Peoples Payments and Peoples Group guidelines

Desired Skills:
You’ll have the following experience:
Bachelor’s degree in Engineering, Computer Science, or equivalent
Proven track record on delivery big data solutions, preferably a data lake
Minimum 5 years’ experience with ETL development
Minimum 5 years’ experience with SQL, multiple RDBMS
Minimum 3 years’ experience in Python
Minimum 1 year hands on experience in AWS – S3, Lambda, Glue
Experience with data governance tools in relation to data catalogue, on development
Experience within Financial Services industry (or other related industry/sector) and asset
Solution-focused, takes initiative to work effectively within established guidelines
Strong organizational, time-management and analytical skills
Able to multi-task and flourish in a fast-paced, deadline-driven work environment
Strong interpersonal relationship building and listening skills
Proven ability to work both independently and collaboratively within a team environment
Excellent written / verbal communication and professional maturity

The people you’ll work with:
In this role, you will have the opportunity to work closely with various teams across the company including Issuing Operations and Risk, Acquiring Risk, Administration, Accounting, as well as Peoples Group Enterprise teams. Through Project and cross corporate initiatives, you will also have the opportunity to directly contribute to the success of your colleagues and interact with the wider Peoples Group team.

If you are interested in joining our dynamic team, please submit your resume today.