Technical Architect / Senior ETL and Information Analyzer Developer

RBC - Bedford, NS (30+ days ago)

Apply Now

What is the opportunity?

A key opportunity within the US Data Office where you will perform technical design, develop solutions and independently manage deliverables on assigned projects related to Data Quality, to ensure US Data Office strategic goals and objectives are accomplished.

What will you do?

Follow structured approach to understand requirements and design solutions for Data Quality deliverables
Define and manage scope and deliverables to align with stakeholder requirements
Review deliverables of team members and provide feedback/suggestions.
Design Data Sourcing solutions that involve retrieving data from various sources, profile the data and prepare the data for Data Quality analysis.
Understand the Data Quality Rules (English language rules) and translate them into ETL jobs using Datastage.
Run the executable rules using the retrieved data, and generate Data Quality metrics.
Aggregate the metrics and represent them using Analytics tool (such as Tableau) as a Dashboard
Design and develop exception handling methods and processes and collect process metrics
Seek out industry trends and organization knowledge to understand alternative approaches / solutions.
Function as a liaison between Business Analysts and the Technical teams on assigned issues.
Ensure traceability of requirements to deliverables.
When assigned, walk stakeholders through deliverables and manage expectations regarding scope.
Seek innovative or improved methods to get the work done and implement best practices.
Contribute content for end user documentation and training.
Recommend business solutions that satisfy sponsor/stakeholder needs continually exploring and assessing options for value-add to clients.
When assigned, assists with the development of high level plans for completion of Implementation and Acceptance phases of projects, improving in the level of detail and accuracy of estimates over time.
Provide support related to technical bug fixes and issue resolution related to implementation of Data Quality rules, Data sourcing or Dashboard.
When assigned, contributes to the development and execution of testing, including coordinating system and acceptance testing.
Reviews defects arising from testing, including User Acceptance Testing, and works with stakeholders to resolve them.
Provides guidance with the definition of a defect as a Change Request or bug.
Ability to perform Root Cause analysis of issues and defects

What do you need to succeed?


5+ years of Technical Development experience using ETL tools like IBM Datastage, Informatica, Talend etc.
5+ years of experience in technical design and development of Data solutions including Data Sourcing, Data Management using DB2, Microsoft Sql Server ,Oracle ,Exadata etc.
3+ years of experience in Unix Shell Scripting (Intermediate to expert level).3-5 years minimum experience in programming, ability to independently design and develop unix shell scripts, perform testing and troubleshooting.
Experience in scheduling jobs using tools like Control-M, Stone Branch etc.
Technical hands-on knowledge of associating rules to data (from files, databases, web services etc.), run the rules and generate Data Quality Metrics
Experience in data retrieval and transformation from various sources (such as HDFS, NAS drives, Databases etc.) and the necessary technical configurations.
Technical Knowledge of InfoSphere Information Server (IIS)
Experience working with IT teams during Installations, Migrations, Server management, Security and access configurations, Data Management and Archival etc.
Degree in Computer Science / Engineering /Data Analytics/Information Systems or related.

Nice to have

Knowledge of Banking and Capital Markets Data Models
Understanding of concepts and components related to Data Management, such as Data Architecture, Data Models, Data Lineage, Data Dictionary, Controls etc.
Knowledge of Information Analyzer OR IDQ
Ability to create executable Data Quality Rules using Information Analyzer OR IDQ
Experience with business intelligence and analytics tools such as Tableau, Cognos, Oracle BI etc.
Experience in Agile methodology using Jira, Kanban board etc.

What’s in it for you?

We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.

A comprehensive Total Rewards Program including bonuses and flexible benefits
Leaders who support your development through coaching and managing opportunities
Ability to make a difference and lasting impact
Work in an agile, collaborative, progressive, and high-performing team
The opportunity to interface with senior level executives from many different parts of the organization