Senior Data Engineer
rbc · Toronto
Job description
About the role
RBC is looking for a Senior Data Engineer in Toronto to build and maintain scalable data pipelines that support enterprise analytics and reporting. The role focuses on ETL/ELT pipelines built with Informatica and dbt, working with department and line-of-business subject matter experts to meet organizational objectives while following end-to-end process standards.
Key responsibilities
- Design and implement data ingestion and transformation pipelines.
- Develop ETL workflows using Informatica IICS.
- Build transformation models and data pipelines using dbt.
- Develop optimized SQL transformations for large datasets.
- Implement data quality checks and validation logic within ETL pipelines.
- Monitor data pipelines and troubleshoot production issues.
- Collaborate with data analysts and architects to design scalable data models.
- Document data lineage, transformations and technical architecture.
- Participate in Agile development processes and code reviews.
Required profile
- Bachelor's degree in a related field (e.g. Computer Science, Business, Engineering) or equivalent experience.
- 3-6 years' experience in data engineering or ETL development.
- Hands-on experience with Informatica ETL tools.
- Experience with enterprise data warehouses or cloud platforms.
- Experience in Agile engineering environments.
Required skills
- dbt and ELT-based transformation frameworks.
- Strong SQL and data modeling.
- Source control (Git), testing frameworks and CI/CD pipelines.
- Nice to have: Snowflake, Databricks, Python, Airflow or Control-M, and banking or financial services experience.
What we offer
- Total Rewards Program with bonuses, flexible benefits, competitive compensation, commissions and stock where applicable.
- Leadership coaching and development opportunities.
- A world-class training program in financial services.
Questions fréquentes
Why are you reporting this job?
Explore further
Salaries, guides and searches in Canada.
Salaries by job title
Apply in 30 seconds
Enter your email to apply. An account will be created automatically.
By continuing, you accept our terms of use.
Already have an account? Login
A question about this job?
Ask it here: you will get the full job summary by e-mail, right away.
Published 1 day ago
Expires 1 month from now
6 views · 0 interested
Boost your chances
Upload your CV — we will match you with relevant openings.
Analyzing your CV...
rbc
Toronto