A Billyard Insurance Group (BIG) is a leading force in the insurance industry, committed to attracting the best insurance professionals and equipping them with cutting-edge technology, tools, and unwavering support to thrive in today's dynamic insurance landscape. With a strong presence and continuous growth, we boast over 80 locations across Canada. Our dedication to excellence has earned us prestigious recognition, including being featured on Insurance Business Canada's esteemed Top Brokerages list for the past three years and securing a spot as one of Canada's Top Growing Companies in the renowned Globe and Mail's Report on Business. At Billyard Insurance Group, our mission is clear: to establish a nationally recognized insurance brokerage brand that empowers brokers and leads the digital insurance revolution.

We are looking for a Business Intelligence Database Administrator to help drive data-informed decision-making across our growing organization. In this role, you will work closely with business and technical stakeholders to develop reporting solutions, analyze data, and maintain business intelligence systems that support operational and strategic objectives. The ideal candidate combines strong technical expertise with a practical understanding of business needs and enjoys turning complex data into clear, actionable insights that create value across the organization.

What does the BI Database Administrator do?

As a Business Intelligence Database Administrator, you will transform data into meaningful insights that support operational performance and strategic decision-making. Working closely with stakeholders across the organization, you will develop reports, dashboards, and key performance indicators that help leaders make informed business decisions. You will also support the administration and optimization of BI-owned Azure SQL databases, ensuring data quality, reliability, security, and performance. Through collaboration, innovation, and continuous improvement, you will help drive a data-driven culture across the organization.

Does this sound like you?

The ideal candidate is an analytical and detail-oriented professional who enjoys turning complex data into actionable business insights. You possess strong SQL, reporting, and data analysis skills, along with the ability to understand business needs and develop effective solutions. You are a collaborative communicator who can work with both technical and non-technical stakeholders, manage competing priorities, and deliver high-quality results. You are curious, adaptable, and committed to continuous learning, with a passion for using data to improve performance and support business growth.

Qualifications

Bachelor's degree in Computer Science, Information Technology, Business Analytics, Data Management, Information Systems, or a related field.
Equivalent combinations of education and directly related experience may be considered.
Minimum of 2 years of experience in business intelligence, data analysis, database administration, reporting development, or a related analytical role.
Demonstrated experience writing advanced SQL queries, stored procedures, views, and data manipulation scripts.
Experience gathering, documenting, and translating business requirements into reporting and analytical solutions.
Experience developing reports, dashboards, and visualizations using Power BI, Python, or comparable business intelligence platforms.
Experience working with data modelling concepts including dimensional modelling, entity relationship diagrams (ERDs), and data dictionaries.
Experience supporting operational reporting, performance measurement, and business analytics initiatives.
Experience working with Azure SQL databases or similar cloud-based database platforms.
Experience performing database administration functions such as security management, access control, performance monitoring, and backup oversight is considered an asset.
Experience with data integration, ETL processes, and data warehousing concepts is considered an asset.
Insurance brokerage, financial services, or regulated industry experience is preferred.

What We Offer

People-focused company culture
Comprehensive benefits including medical, vision, dental, and Employee Assistance Program (EAP)
3 weeks’ of paid vacation in the first year of employment; 4 weeks’ in year 2
Birthday day off
Hybrid work from home / in-office environment (3/2)
Retirement savings programs, with company-matched RRSP contributions

Our Commitment to Diversity, Inclusion and Belonging

Billyard Insurance Group is committed to building a transparent environment where everyone feels heard, welcomed, and included. We believe Diversity, Inclusion, and Belonging are fundamental in our vision to be the leading insurance platform in Canada. BIG is a proud, equal-opportunity workplace that is committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, or gender identity.

Our Commitment to Accessibility

Billyard Insurance Group is committed to developing an inclusive, barrier-free recruitment process and work environment. Should you require any accommodation, please inform us and we will work with you to meet your accessibility needs. For any accessibility-related assistance, requests for information in accessible alternative formats or to report any accessibility problems, please contact us at recruitment@thebig.ca or 905.346.2190 ext. 10211.