About the Opportunity

Job Type: Permanent

BI Developer/BI Tool Administrator (Software Developer)

This is a remote role.

Who We Are

Established in 1987, Fidelity Investments Canada Inc. (FIC), provides Canadian investors with a full range of mutual funds, ETFs, and alternative funds. Fidelity funds are available through several advice-based distribution channels, including financial planners, investment dealers, banks, and insurance companies.

FIC manages over $168 billion (CAD) in mutual fund and institutional assets at December 15, 2020. This includes $41 billion in assets for institutional clients, including public and corporate-defined benefit pension plans, endowments, foundations, and corporate assets on behalf of clients across Canada.

The Investment Management team focuses on research analysis and delivering strong returns, and is comprised of portfolio managers, research analysts, traders and more.

FIC has more than 1000 full time employees and is headquartered in Toronto, with regional offices in Montreal, Calgary, and Vancouver.

What You Will Do

As a BI Developer/BI Tool Administrator at Fidelity Investments Canada, you will be at the forefront of transforming raw data into actionable insights, enabling our business units to make informed decisions, enhance operational efficiency, and drive growth.

You will work with cutting-edge BI tools, including Tableau and SAP BI. You will perform tool administration tasks and develop interactive data visualizations, dashboards, and reports. You will collaborate with data engineers, architects, and other stakeholders to understand data requirements and create compelling visualizations. Your role will be critical in serving multiple business units, each with unique data requirements and analytical needs.

How You'll Make an Impact

• Develop and maintain BI content based on business requirements.
• Design and optimize data models to support reporting and analysis needs.
• Implement automated reporting solutions to streamline and enhance the reporting processes reducing manual efforts and ensuring data consistency.
• Create complex SQL queries and database views to extract and transform data.
• Perform data analysis and quality assurance to ensure accuracy and integrity of reports.
• Collaborate with stakeholders to gather requirements and provide technical expertise and guidance.
• Troubleshoot and resolve issues related to data, reports, and performance.
• Stay up to date with the latest BI tools features and best practices.
• Install, configure, and upgrade the BI software and related components.
• Monitor and manage the Business Objects servers, services, and processes.
• Troubleshoot and resolve issues related to server performance, connectivity, and security.
• Manage user access and security permissions, including the creation and maintenance of user accounts and groups.
• Maintain data security and governance protocols, including user access management and adherence to compliance requirements, to safeguard sensitive data and ensure compliance with regulatory standards.
• Perform regular backups and disaster recovery procedures to ensure data integrity and availability.
• Collaborate with other IT teams and business stakeholders to gather requirements and implement changes and enhancements to the Business Objects environment.
• Provide technical support and training to end-users on BI tools functionality and best practices.
• Familiarity with cloud-based data storage solutions and data integration techniques.

What We're Looking For:

• Completion of a University degree (Computer Science, Software Engineering, Economics or Mathematics) or equivalent work experience.
• 2+ years of relevant experience.
• Good knowledge of SQL or other database platforms such as oracle or progress.
• Experience with full stack development practices including java & python.
• Knowledge and experience in developing applications for mutual fund/investment industry.
• Effective communication skills with ability to prepare project documentation & presentations.

What you will Bring:

• Proven experience as a Business Objects/Tableau Developer or similar role.
• Relevant certifications (e.g., SAP Certified Application Associate, Business Objects Certified Professional, Tableau Desktop Specialist, Tableau Server Certified Associate) are a plus.
• Proficiency in SAP Business Objects suite (e.g., Web Intelligence, Universe Designer, IDT, Crystal Reports, and Central Management Console)
• Proficiency in Tableau tool (e.g., Desktop, Server, Tableau Services Manager Web UI)
• Proficiency in administering and troubleshooting Business Objects/Tableau servers and services.
• Knowledge of data source optimization and maintaining data connections.
• Experience connecting BusinessObjects/Tableau to various data sources.
• Knowledge of deploying and publishing Tableau workbooks to Tableau Server or Tableau Online.
• Understanding of permissions, security, and user access management (SAP BI/Tableau).
• Knowledge of security protocols and best practices for securing Business Objects environments.
• Familiarity with server operating systems (e.g., Windows, Linux) and network protocols.
• Skill in using version control systems (e.g., Git) to manage Tableau workbook versions and collaborate with team members.
• Understanding of data governance and security concepts that involve managing and protecting data assets.
• Proficient in managing backups and performing recovery procedures.
• Solid understanding of data modeling concepts and database design principles.
• Proficient in designing visually appealing and interactive dashboards that effectively communicate insights.
• Knowledge of best practices for layout, color schemes, and user experience.
• Strong SQL skills and experience with relational databases (e.g., Oracle).
• Excellent problem-solving and analytical skills.
• Strong communication skills to understand business requirements and present findings effectively.
• Ability to collaborate with business analysts, data scientists, and other stakeholders.
• Analytical mindset to identify data patterns, trends, and anomalies, and provide solutions.