ETL Developer

Highlights

PSB BOISJOLI is an accounting firm dedicated to meeting the financial needs of SMEs. We share our clients’ entrepreneurial values and work directly with them to provide creative solutions and offer tailored, practical advice, directly contributing to their success.

Apply

Company Profile

Located in Montreal, PSB Boisjoli is one of Quebec’s leading accounting firms, with a team of over 250 people. The Firm values an approach based on mutual support and teamwork amongst Partners and team members. It also offers a competitive salary and benefits as well as a stimulating working environment that fosters professional growth.

Due to the ongoing growth within our firm, our Information Technology Department is seeking an ETL Developer to design and implement ETL processes. The ideal candidate will build ETL pipelines to integrate the data from diverse sources into our system. We require someone with exceptional business acumen and communication skills to be able to work with business owners, understanding their data requirements and help them make data-related decisions using the ETL knowledge and experience.

The role also requires agility to learn new tools and technologies fast, alongside a deep understanding of databases and basic programming and scripting skills. The chosen candidate should have expertise in the design, creation, management, and business use of large datasets. Moreover, will play a pivotal role in building stable and efficient data pipelines that can be easily maintainable over time.

Responsibilities

  • Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.
  • Gather requirements and business process knowledge to transform the data according to the needs of end users.
  • Maintain and improve existing processes.
  • Ensure that the data architecture is scalable and maintainable.
  • Work with our partners and directors in designing and delivering correct, high quality data
  • Investigate data to identify potential issues within ETL pipelines, notify end-users and propose effective solutions.
  • Prepare documentation for further reference.
  • Create and maintain API links to various systems.

Requirements

  • Proficiency in data modeling principles with meticulous attention to detail.
  • Ability to create and understand API tunnels.
  • In-depth knowledge of the following tools, PowerBI, Tableau and SSRS.
  • Strong organizational skills, including time management and planning.
  • Solid SQL knowledge (query performance tuning, index maintenance, etc.) as well as an understanding of database structure
  • Knowledge of various SQL/NoSQL data storage mechanisms and Big Data technologies.
  • Passionate about complex data structures and problem solving.
  • Experience with at least one ETL tool (e.g., SSIS, Informatica, Talend).
  • Quick learner, adept at grasping new data tools and concepts.
  • Knowledge of Python, Javascript and other RPA languages an asset.
  • Previous experience in a professional services firm is an asset.

Who are we?

First and foremost, PSB BOISJOLI is a tight-knit team of more than 250 professionals and 29 partners. Our biggest asset is our employees, who are dynamic, talented and ambitious individuals. At our firm, we believe that everyone is provided the opportunity to define their role, their voice, their inspiration and their growth potential, all while placing high importance on their personal values. Free from traditional hierarchical boundaries, our team members keep things simple when it comes to relationships and effective communication. Quality of life is our priority, both in and outside of the office.

    Form


    Mr.Mrs.Ms.







    Newsletter

    Subscribe to receive our latest news and publications

    Your email adress has been added to the list.

    Location

    3333 Graham Boulevard, Suite 400
    Montréal, QC H3R 3L5
    (De la Savane Metro station)

    Follow us