Data Engineer

Toronto, ON

Looking for your next opportunity? Our Client is currently looking for a Data Engineer to join their team in Toronto! If you are looking for a new challenge, professional growth and fulfill the following qualifications, this is a role for you!

Position Overview

We are seeking an experienced Data Engineer with proven expertise in SAS, Alteryx, and Databricks to join our financial data and analytics team. The ideal candidate will have a solid understanding of banking operations, regulatory requirements, and large-scale data integration, with the ability to design and maintain robust data pipelines that support analytics, machine learning, and reporting for mission-critical financial applications.

Key Responsibilities

Data Pipeline Development & Management
- Design, build, and maintain scalable, efficient ETL/ELT pipelines using SAS, Alteryx, and Databricks.
- Integrate data from diverse banking systems, transaction platforms, and external data providers.
- Ensure data quality, consistency, and accuracy across the organization.
Data Processing & Transformation
- Perform large-scale data cleaning, transformation, and enrichment for use in analytics and reporting.
- Optimize data workflows leveraging Spark in Databricks for distributed processing.
- Develop reusable Alteryx workflows for recurring data processing tasks.
Collaboration & Business Support
- Work closely with data scientists, analysts, and business stakeholders to understand requirements and deliver data solutions that enable business insights.
- Support the integration of data sources for use in financial risk modeling, fraud detection, customer analytics, and compliance reporting.
Compliance & Governance
- Implement and adhere to data governance, security, and privacy best practices in line with banking regulatory requirements (e.g., Basel III, GDPR, PCI-DSS).
- Maintain clear documentation of data pipelines, workflows, and processes.
Continuous Improvement
- Identify opportunities to automate manual data processes and improve data pipeline efficiency.
- Stay up to date with new features and best practices for SAS, Alteryx, and Databricks in financial services.

Required Qualifications

Education: Bachelor’s or Master’s degree in Computer Science, Data Engineering, Information Systems, or related field.
Experience:
- 5+ years of experience as a Data Engineer or in a similar data-focused role.
- Strong hands-on experience with SAS, Alteryx, and Databricks.
- Solid understanding of ETL design, data modeling, and data warehouse concepts.
- Experience working with financial datasets, transaction processing systems, and banking analytics.
Technical Skills:
- Proficiency in SQL for complex queries and performance optimization.
- Strong experience with Spark in Databricks for big data processing.
- Familiarity with Python, Scala, or R for data manipulation and automation.
- Experience with cloud platforms (Azure, AWS, or GCP), ideally Azure Databricks.

Preferred Qualifications

Experience with financial reporting and compliance-driven data workflows.
Knowledge of API integration and automation in Alteryx.
Exposure to BI/visualization tools (Tableau, Power BI).
Understanding of real-time data streaming concepts in a financial context.

Soft Skills

Strong analytical and problem-solving skills.
Excellent communication skills for cross-team collaboration.
Detail-oriented mindset, especially when working with sensitive financial data.
Ability to work independently and under tight deadlines.

Newfound Recruiting is a Canadian professional services company, headquartered in Ottawa, Ontario and is one of Canada’s leaders in Professional Staffing and Recruiting. Currently, Newfound Recruiting is servicing clients across Canada, having established relationships in Ontario (Toronto and Ottawa), Alberta, British Columbia, Quebec, and Newfoundland. By applying innovative techniques, we match the right candidate with the right position. Our 20 years of industry experience gives you the assurance that we will provide the right answers to your difficult questions. At Newfound, we believe that diversity and inclusion among our teammates is critical to our success, and we seek to recruit, develop, and retain the most talented people from a diverse candidate pool. We are committed to providing an environment of mutual respect where equal employment opportunities are available to all applicants and teammates without regard to age, race, colour, national origin, sex, gender, sexual orientation, religion, physical or mental disability, or any other category protected by law. All employment at Newfound is based on personal merit, qualifications, experience, ability, and job performance. Newfound welcomes and encourages applications from people with disabilities, and we will provide reasonable accommodations, accessible formats, and communication support upon request to persons with disabilities during the recruitment and selection process. If you require accommodation, please contact our Human Resources department at info@newfoundrecruiting.com