Lead ETL Developer

Apply now »

Date: Jun 22, 2022

Location: Ottawa, ON, CA, K2K 3N5

Company: Innovapost

Who is Innovapost?

Great question! We are the technology arm of the Canada Post Group of companies. This includes Canada Post, Purolator, and SCI. By joining us you will be able to make a positive impact on how every Canadian deliver and receives their packages and mail. Next time you see your neighbor picking up their mail and receiving a package, you will be able to say “you’re welcome!”

Why join Innovapost?

As Technology evolves constantly, we invest in our High Performing Workforce with the Skills of Tomorrow through continuous learning and career growth within Innovapost, including access to LinkedIn Leaning, the new Degreed capability and a Leadership Developmental Program. We invest in Diversity, Inclusion and Belonging, and provide continuous employee engagement to grow our business together.      

What role you will play?

  • Manage technical project deliveries, design development process improvements, manages and drives development activities across data analytics product teams.
  • Taking lead on assisting in designing ETL EDW solutions which includes diagnosing complex technical problems, performance code optimization, and setting development standards and processes.
  • Hands-on responsibilities for Extract, Transform and Load (ETL) design and development for the DI Development team
  • Ensure proper technical document standards are followed and maintain ETL processes related documentation across the EDW.
  • Work closely with data architects, data integration (ETL) and business intelligence developers, DBAs, and other technical SMEs to ensure alignment of standard development methods and practices.
  • Work closely with QA team for regular QA defects review process.

Other Responsibilities

  • Work closely with production support for any operational issue escalations.
  • To liaise with our business partners to ensure effective coordination and understanding of the full technology and process implementation.
  • Lead and guide the developers with their career and yearly goals, performance review, regular meeting and career planning.
  • Able to share/teach relevant technological innovation and/or industry knowledge and expertise to other developers.
  • Attend regular Agile daily stand-up meetings and other scrum meetings as needed
  • Represent Data Analytics with the business sponsors identifying appropriate Data Integration solutions during project initiation phase
  • Work on the strategic migration from on-premise to Cloud

Experience?

  • Experience designing/developing/implementing ETL solutions (landing, Integration and semantic) particularly applied to data analytics/data warehouse
  • Experience with SQL/PL, SQL, SQL query optimization
  • Ability to analyse customer requirements and define these as a formal specification for software development

Knowledge

  • Agile development and delivery methodologies
  • Knowledge of Jira and Confluence
  • General knowledge of a wide range of software products and technology applications

Mandatory Skills

  • Expert with ETL design and development using tools such as IBM InfoSphere DataStage and QualityStage, Teradata Studio/SQL Assistant. Erwin, SAP PowerDesigner
  • Expertise on ETL code optimization for performance and data.
  • Expertise in end-to-end ETL data flow validation and control, able to set proper notifications, alerts or break points to maintain data accuracy.  
  • Expertise in data modeling (conceptual, logical, physical), types of data capture SCDs.
  • Excellent verbal and written communication skills that can translate technical to non-technical audiences within various levels of the organization.
  • Excellent problem-solving, team, and time management skills.
  • Cloud native technology knowledge (Azure, AWS, Google, ADF, Data Bricks, AKS, Event Hub, Stream Analytics, Data Lake, Synapse Analytics….)
  • Able to provide mentorship and guidance to team members and help them achieve their career goals

Nice to have

  • Tableau, Business Objects, Power BI
  • SAS

Education

Bachelor’s degree or higher in Computer Science or related field or related experience

 

The work we do at Innovapost impacts every Canadian. To work with us, you must be eligible to obtain a Canada Post Reliability Security Clearance.

Good luck! We are looking forward to meeting you, but unfortunately, we will not be able to meet all of you!

Competencies

Be Courageous
Innovate
Be Inclusive
Inspire
Be Curious
Technical Knowledge