Full-time
McLean & Dickey Ltd. is Simcoe County’s leading independent insurance brokerage, serving clients across Ontario. We’re looking for a Data Analyst who combines strong technical expertise with analytical thinking, business awareness, and clear communication skills. Reporting to the Manager of Information Technology, you’ll help strengthen how we collect, interpret, and use data across the organization.
The Opportunity
As a Data Analyst, you’ll work closely with our department, leadership, partners, and IT teams to understand reporting needs, solve complex data challenges, and turn technical findings into clear, practical insights that support sound business decisions and operational improvement.
Key Responsibilities
· Data Collection & Cleaning: manage the end-to-end flow of data, including extraction, integration, validation, storage, retrieval, and troubleshooting the reporting database environment.
· Data Analysis: apply statistical and analytical methods to identify trends, patterns, correlations, and actionable insights. Support the design and implementation of systems used to generate and capture internal and external data.
· Reporting and Visualization: develop interactive dashboards and reports using Power BI and Excel to present complex findings to non-technical stakeholders. Automate recurring reports and tasks to improve efficiency and increase productivity.
· Collaboration: work with leadership and cross-functional teams to define KPIs, clarify reporting needs and address business problems. Using Power BI, make data available to the business for analysis and decision-making.
What You Bring to the Role
We’re looking for someone who combines advanced technical ability with a strong analytical mindset. You can work confidently with large and complex datasets, recognize relationships within the data, and develop accurate reporting solutions that respond to real business needs. You’re also able to explain your findings clearly and help stakeholders understand what the data means and how it can be used.
Qualifications
Technical Proficiencies:
· Degree in business, analytics, finance, information systems or computer science.
· Strong working knowledge of programming languages like SQL, or Python. Extensive experience with spreadsheet software like Microsoft Excel is mandatory.
· Intermediate to advanced knowledge of Microsoft’s Power BI.
·Adept at developing queries, dashboards, automated reports, and data visualizations.
· Experience with Google BigQuery is an asset.
Analytical Mindset:
· Proficiency in statistics, data modeling, and data mining techniques.
· Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
Communication Skills:
· Comfortable in presenting findings to senior management.
· Able translate data into meaningful information to manage expectations with business leaders.
· Insurance industry knowledge is an asset and French language proficiency is considered a bonus.
What Makes You a Great Fit
- You approach complex problems with curiosity and sound analytical judgment.
- You notice patterns, inconsistencies, and opportunities others may overlook.
- You work independently and confidently handle non-routine technical challenges.
- You communicate complex findings clearly to different audiences.
- You stay organized and accurate while managing competing priorities.
- You collaborate effectively and build trust across departments.
· Insurance industry knowledge is an asset while and understanding of French language is considered a bonus.
Why Join McLean & Dickey?
For more than 100 years, we've built our reputation by putting people first. As an independent brokerage, we're committed to supporting our clients, investing in our employees, and giving back to the communities we serve. Here, you'll find meaningful work, opportunities to grow, and a team that's genuinely invested in your success.
We offer:
- Work-Life Integration: Flexible 35-hour work week built around core hours, with hybrid options available.
- Comprehensive Benefits: Competitive compensation, extended health coverage, life insurance, travel insurance, and a defined contribution pension plan.
- Professional Development: Tuition reimbursement and support for related education and professional development.
- Career Advancement: Opportunities to grow within a thriving organization that promotes from within.
- Supportive Team: Dedicated HR and IT support in a collaborative work environment.
- Community Impact: Volunteer hours reimbursement and opportunities to give back locally.
- Practical Perks: Free parking, annual performance reviews, and more.
Our Commitment to Inclusion
McLean & Dickey Ltd. provides a workplace that respects individual differences and ensures every team member has the opportunity to be heard and contribute meaningfully. We welcome applications from people of all backgrounds and abilities. Accommodations are available upon request throughout the recruitment process.
Ready to apply your technical expertise and analytical thinking to meaningful business challenges? Join McLean & Dickey and help us turn complex data into reliable insights and stronger processes.
Job Types: Permanent, Full-time
Pay: $65,000.00-$75,000.00 per year
Benefits:
- Company events
- Company pension
- Dental care
- Extended health care
- Life insurance
- On-site parking
- Vision care
Ability to commute/relocate:
- Orillia, ON: reliably commute or plan to relocate before starting work (required)
Application question(s):
- Are you legally entitled to work in Canada?
- Do you have any criminal convictions?
- Are you agreeable to a criminal record check?
- Have you ever filed for bankruptcy?
Work Location: In person
