Senior Data Engineer

At Fiera Capital

We invest in creating a culture of purpose that makes our people feel valued, cared for, seen, and heard. Our approach to employee experience is tailored to your needs and ambitions:

• Your Inclusive Experience: We are committed to cultivating an inclusive, safe, and trusting work environment.
• Your Growth & Empowerment: We have ambitious growth goals for our firm, which makes us a great place to advance your career.
• Your Rewards & Recognition: We deeply value our people and their contributions and that’s reflected in our competitive compensation and benefits packages and our collaborative culture.
• Your Wellness Your Way: We strive to create a healthy work environment and we offer programs designed to support our employees’ wellbeing.

What we are looking for:

Are you a talented Senior data engineer seeking an exciting opportunity to make a real impact? Join our dynamic team and play a pivotal role in shaping the future of our databases, integrations, and applications.

In this diverse and fast-paced role, your adaptability and appetite for learning will be your greatest asset as you navigate through a complex and changing business domain across our evolving technology stack. You'll be immersed in everything from back-end to client-side code, employing the most efficient Microsoft technologies, frameworks, and patterns to achieve outstanding results.

Your exceptional problem-solving, solution design, high-quality coding skills, and appetite for learning and personal growth are exactly what we're looking for. If the idea of contributing to the optimization and evolution of our system architecture excites you, then we can't wait to hear from you. Apply now and let's embark on this journey together!

Your responsibilities:

As part of your duties, you will be assigned the following responsibilities:

• Create and maintain efficient, sustainable, secure and low latency data pipelines.

• Build and maintain data warehouse solution on cloud that is flexible enough to adapt with changes as it evolves.

• Assemble large, complex data sets that meet functional / non-functional business requirements.

• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.

• Design and deliver ETL capabilities, with proficiency in SSIS and Azure Data Factory

• Develop and support API designs and integrations with internal databases.

• Create, maintain and optimize data models, cube that efficiently feeds the reporting tools.

• Understand of cost impact and feasibility aspect of running end to end modern data solution in cloud.

• Work with data and analytics experts to strive for greater functionality in our data systems.

Must have requirements to be successful in this role:

• 5+ years of relevant experience as a Data Engineer.

• A bachelor’s degree in computer science, engineering, technology, or a related field is highly valued, but we also recognize the importance of hands-on experience and alternative educational paths in shaping top talent.

• Experience in financial services, asset management, or banking industry an asset.

• Excellent communication skills in English (Written and Spoken) and French an asset.

• Be an open-minded person with a passion to learn and drive to solve complex problems.

People

• You do not fear asking questions about things you don’t understand

• You generously share your technical knowledge and experience; you love working with tech savvy business people

• Whether designs, code comments or collaborative interactions; you communicate well

• Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.

Technical Skills and Experiences

• 5+ Years of hands on Data Warehouse or BI developer experience ideally in finance/banking industry or large enterprise.

• Clear Understanding Dimensional Data Modeling (Inmon Vs Kimball or hybrid).

• Understanding of Lambda Architecture for batch and stream processing.

• Proficiency with SSIS/Azure Data Factory or similar ingestion/integration tools.

• Cube Data Modeling with Azure Analysis Services or similar technologies.

• Advanced SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.

• Proficiency in at least one programming language (C#, Java, Python, JavaScript …) for when you need to write your own tool.

• Keeping yourself up to date with ever-changing industry trends in pattern practices and architecture.

Other expected skills

• Working knowledge of message queuing, stream processing, and highly scalable ‘big data’ data stores.

• Strong analytic skills related to working with unstructured datasets.

• Master data management.

• Experience with Microstrategy/PowerBI an asset.

OUR CURRENT TECH STACK

• When it comes to technology; we believe in standardizing where it’s needed and diversifying where it matters.

  • We are in Azure, it’s a standard.

  • We value SOLID understanding of Object-Oriented Design principles. We believe and practice TDD.

  • We use Azure DevOps for our codebases, CI/CD and managing overall SDLC.

• Back-End

  • Databases - SQL (MSSQL), AZURE SQL Database

  • SSIS and AZURE Data Factory

  • C#, .NET Core, and related technologies.

SUPPORT

• Monitoring of processes and/or put in place efficient automate processes to respect organization Service Level Agreement (SLA).

• Responsible for the monitoring and management of systems ensuring all systems checks are completed and documented and any service incidents are managed, resolved, or escalated in a timely manner. ​

#LI-Hybrid

For all positions in Quebec (Montreal and Laval), proficiency in French, both spoken and written, is mandatory. Working English proficiency is also required in order to serve our offices and clients around the world. 

Fiera Capital subscribes to the principle of employment equity. Our staff is our most valuable asset, and our goal is to create an inclusive and equitable environment where everyone can achieve their true potential.

We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, colour, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, or on the basis of disability, genetic information or any other federal, state, or local protected class. Fiera Capital will not tolerate any form of discrimination or harassment.

All staffing decisions, including hiring and promotion decisions, will be based on merit, skills, performance, and business needs. We are pleased to receive applications from qualified individuals from a variety of backgrounds. Job applicants who are individually selected for an interview will be notified that accommodations are available upon request. If a selected participant requests accommodation, Fiera Capital shall consult with the applicant and provide, or arrange for the provision of, suitable accommodation in a manner that considers the applicant’s accessibility needs due to disability.

Please stay vigilant and never share personal or confidential information during this hiring process, unless it is through Mintz Global Screening, the secure platform we use to exchange such information. If in doubt, or if you think you have been a victim of fraudulent manoeuvres during your hiring process, please contact us.

Please note that job titles indicated in job postings may differ from internal job titles. Accordingly, offers of employment may not reflect job titles indicated in job postings.

We thank all applicants for their interest in a career with Fiera Capital. We will only contact those selected for an interview.