About Ascendion :

Ascendion is a full-service digital engineering solutions company. We make and manage software platforms and products that power growth and deliver captivating experiences to consumers and employees. Our engineering, cloud, data, experience design, and talent solution capabilities accelerate transformation and impact for enterprise clients. Headquartered in New Jersey, our workforce of 6,000+ Ascenders delivers solutions from around the globe. Ascendion is built differently to engineer the next.

Ascendion Engineering to elevate life

We have a culture built on opportunity, inclusion, and a spirit of partnership. Come, change the world with us:

• Build the coolest tech for world's leading brands
• Solve complex problems - and learn new skills
• Experience the power of transforming digital engineering for Fortune 500 clients
• Master your craft with leading training programs and hands-on experience

Experience a community of change makers!

Join a culture of high-performing innovators with endless ideas and a passion for tech. Our culture is the fabric of our company, and it is what makes us unique and diverse. The way we share ideas, learning, experiences, successes, and joy allows everyone to be their best at Ascendion.

About the Role:

Position: Data Engineer

Location: Toronto, ON

Summary:

This is a great opportunity to learn, grow and become a SME in data management and database optimization in cloud technology, becoming a key player on our infrastructure team. Join our growing organization and you will get the chance to be in the driver seat of innovation and change here at Payfare as we think about new ways to better leverage data in support of our increasing mandate.

As a data engineer, you will be joining a team of mixed background technologists. Our mandate is to provide flexible and stable platform solutions that empower our feature development teams to create the highest quality services for our customers. On an ongoing basis, we expand our developing, testing, and deploying reliability and resiliency features. All of this continues to require a strong backbone of database solution and design facilitating data ingestion / extraction in the most optimized way, while also ensuring data protection, integration, and ensuring data availability.

Reports To - Data Engineering Manager

Responsibilities and Duties

Strong MySQL experience enabling platform growth and scale.

Advanced expertise and experience on schema design improvements with both tactical and strategic lens to ensure data ingestion / extraction for our warehouse database, supporting current BI team, external reports, and operations teams.

Experience working in collaboration with development teams to optimize schema and queries for new features before they go out into production.

ETL and Data Lake management expertise required.

Knowledge and experience related to migrations from MySQL to PostgreSQL would be a definite PLUS.

Python/Go experience is not mandatory but highly desirable, to support current ETL ingestion scripts.

Proactively identify improvements to continually improve platform and data resiliency.

Analyze system problems including root cause determination and manage any needed recovery process to ensure a quick restoration of service without loss of data.

Strong attention to detail in all daily activities.

Qualifications and Skills

Diploma / Degree in Computer Science, Software Engineering or similar

3+ years of relevant work experience

You've had years of experience in one of the following areas of expertise: Database administration, Data Engineering, ETL data load and ingestion, data classification and normalization, SQL and schema optimization.

Expertise in Linux system administration, web servers, and networking would be an asset.

Kubernetes experience would be an asset.

Experience with implementation of database security hardening best practices, including collaboration among cross-functional teams to encourage safe and zero-trust access.

Experience with various AWS services such as Lambda, Redshift, DMS

Experience with various Apache tools such as Airflow, Superset, Kafka

Experience with other cloud vendors with similar technologies is a PLUS

A deep curiosity that motivates you to keep on top of technical trends and informs your ability to suggest tools and approaches to interesting problems.

The ability to empathize with and communicate clearly to all the other parts of the business.

Salary Range: CAD $ 104,000 - 114,000 Annually - Factors that may affect pay within this range may include geography/market, skills, education, experience and other qualifications of the successful candidate.

Benefits: The Company offers the following benefits for this position, subject to applicable eligibility requirements: medical insurance dental insurance vision insurance 09-10 days/hours of paid time off

Want to change the world? Let us know.

Tell us about your experiences, education, and ambitions. Bring your knowledge, unique viewpoint, and creativity to the table. Let's talk!