Sr. Data Engineer, Data Integration and Management
Description
The Senior Data Engineer is responsible for designing, building, and maintaining scalable data pipelines and platforms to enable analytics, reporting, and data-driven decision-making. This role ensures data accuracy, reliability, and efficient delivery across business and technology systems.
What We're Looking For
Function in accordance with the Software Development Lifecycle (SDLC) framework and governance processes.
Design and develop data workflows and mappings for analytics, reporting, and integration.
Perform data extraction from primary and secondary sources, data migration, maintenance, and monitoring of databases/data systems.
Investigate source data to understand structure and interrelationships; identify, analyze, and interpret trends in complex data sets.
Evaluate internal systems for inefficiency and inaccuracies; develop and maintain protocols for handling, processing, data cleansing, and identifying data quality issues.
Evaluate data elements/codes, data attributes, business rules, and data standards.
Assist with project documentation including source-to-target mapping, data taxonomies, data lineage, and other data management artifacts.
Collect/document business and data requirements, create specifications for reports and visualizations, design and execute test cases.
Assist in the development, maintenance, and synchronization of conceptual, logical, and physical data models.
Assist in the development and maintenance of interactive visualizations and dashboards.
Participate in development of test plans and perform quality assurance and testing.
Ensure work includes necessary audit controls and security controls within all design and deliverables.
Accurately define and execute transformations, aggregations, and other data manipulations to meet requirements.
Minimum 8+ years with implementing data solutions including data engineering and integration, database development, advanced SQL, and relevant data transformation tools.
Strong working knowledge of data modeling, data warehousing techniques and concepts (including ETL processes, Star Schema/Snowflake Schema), data extraction, aggregation, and data visualization.
Proficiency in SQL or other query languages, data integration, ETL, and working with large structured and partially structured data sets.
Experience with data visualization tools (PowerBI, Tableau etc.), data visualization wireframes, and mockups.
Ideal Candidate
Bachelor's degree in Computer Science, Information Technology, or a related field.
Minimum Education
Bachelor's Degree
Hard Skills
Soft Skills
Work Hours
37.5 hours/week
Benefits
About the Company
Royal Bank of Canada
Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance. As Canada's largest bank, it provides personal and commercial banking, wealth management, and capital markets services to over 17 million clients worldwide.
We respect your privacy
BerryMap uses cookies to provide essential features, analyze usage, and improve your experience. You can customize your preferences below.