Being a part of BrokerLink, means you live our values: to act with integrity, be respectful of others, have a customer-driven mindset, strive for excellence and always treat others with generosity. These values drive our diversity and inclusion efforts to ensure a respectful and inclusive environment.

We want like-minded individuals who want to provide the highest level of customer service, who carry themselves with utmost professionalism.

We want to invest in you! Your success is our success and our purpose of “we’re here to help people” is what motivates us to keep the amazing talent we attract, for a long time. We want to bring out the best of all our team members! Offering countless opportunities to grow and an environment which values our most important assets, you, our team members. We have over 200 offices across Canada, ask us about our flexible work arrangements!

The Position:

We are looking for a Financial Data Analyst to join BrokerLink and work from our Calgary office on a Permanent FT Basis.

Seeking an experienced Financial Data Analyst to join our FP&A team and lead our data infrastructure modernization efforts. This role would make an immediate impact by transforming our reporting capabilities from legacy Access databases to modern SQL and Databricks solutions. We are seeking an individual with strong business acumen, analytical modeling capabilities, coupled with advanced proficiency in Excel. This role offers a unique opportunity to collaborate with a financially driven FP&A team and serve as a key technical partner and leader.

As part of our employee promise, here are some of the many perks of working with us:

• Flexible health and dental insurance benefits package
• Personal Spending amount to invest in your healthy lifestyle
• RRSP - Registered Retirement Savings Plan with Company matching
• ESPP - Employee Share Purchase Plan (TSX:IFC) program with matching aspect
• Hybrid working environment flexibility
• ‘Dress for your day’, dress according to your daily schedule
• Competitive compensation package with bonus aspect
• Employee discount program, including Apple, Bell, Rogers and more!
• Paid Time Off in the form of: Personal days, Volunteer days, Exam/Study Time, Jury Duty and starting at 3 weeks of vacation per year!
• Working for an employer who is regularly recognized as one of Canada’s best employers such as Kincentric 2024

What the Role Entails:

• Modernize Data Infrastructure: Technical lead for the conversion of existing Access databases into scalable SQL and Databricks reporting solutions
• Build Analytical Models: Develop and maintain analytical models that drive executive decision-making
• Create Executive Dashboards: Design and deliver executive-level dashboards and reports that translate complex data into actionable insights
• Strategic Analysis: Conduct ad-hoc analyses to support strategic initiatives and answer critical business questions
• Collaborate Cross-Functionally: Partner with accounting and finance teams to understand requirements and deliver data solutions that meet their needs
• Optimize Reporting: Streamline existing reporting processes through automation and best practices in data management

The Successful candidate will have:

*If you feel you have the equivalent skills, please apply*

• Bachelor’s degree in Data Analytics, Finance, Accounting, Economics, Mathematics, Statistics, Computer Science, MIS or related field
• Professional post graduate certification in related fields would be highly valued.
• Ie Business Intelligence and Data Analytics from University of Calgary.
• 5+ years of experience in a Data/Financial Analyst or similar role.
• Expert-level SQL skills with demonstrated ability to write complex queries, optimize performance, and an ability to manipulate large complex datasets.
• Database migration experience with a proven track record converting legacy systems (Access, etc.) to modern data platforms
• Advanced Excel proficiency. Skilled in building dynamic financial models with advanced formulas, modelling data for scenario analysis and VBA/Macros to streamline processes
• Experience working with data visualization tools such as PowerBI.
• Working Knowledge of Oracle would be a valued asset
• Positive team player with excellent communication skills and ability to serve as key technical partner and leader within our FP&A team.
• Willingness to adapt working hours to meet critical deadlines and peak operational periods.
• Demonstrates a strong sense of ownership and accountability

We thank all applicants for their interest, but only those selected for an interview will be contacted.

BrokerLink is committed to providing an accessible environment. Accommodations are available on request for candidates taking part in the selection process.

BrokerLink is committed to creating and maintaining an inclusive environment which embraces our diversities and sees them as our strength! We want to foster a workplace that makes all our team members and customers feel welcome and appreciated.

Discover more about BrokerLink! Visit our new dedicated Webpage - https://www.brokerlink.ca/campaign/discover-brokerlink

At BrokerLink, we value diversity and are committed to creating an inclusive workplace that inspires each of us to be the best we can be. Join our team and make a difference!