Business Intelligence and Analytics Consultant

IFG International Financial Group Ltd; South Frontenac; Hybrid; CAD 80,000 - 120,000; Full time

Job summary

A leading financial institution seeks a Business Intelligence & Analytics Consultant to support data migration and enhance reporting capabilities. This hybrid role involves collaborating with teams to ensure data quality, develop BI reports, and design performance analytics solutions. Ideal candidates have a background in finance or analytics with significant data warehousing experience.

Qualifications

• 3+ years in business intelligence or data analytics role.
• Hands-on with data warehousing and SQL.
• Experience building BI reports and analytics tools.

Responsibilities

• Map and transition data from current data lake to new.
• Develop and enhance BI reports for investment strategies.
• Collaborate to gather specifications and define requirements.

Skills

Analytical skills

Problem-solving skills

Communication skills

Attention to detail

Education

Bachelor's degree in Finance

Bachelor's degree in Business Analytics

Bachelor's degree in Computer Science

Tools

SQL

Job description

Our client, a large financial institution, is seeking a skilled Business Intelligence & Analytics Consultant to support their ongoing data migration and reporting enhancement initiatives. This role has two functions, first focusing on creating reports and optimizing data and reporting workflows to drive effective trading strategies and performance analytics. The second is to help with data mapping and testing on the migration of data from one data warehouse to another.

***This role is hybrid 2-3 days a week in office

The key responsibilities include the following;

• Data Migration & Transformation: Partner with business and technology teams to map and transition existing data from current data lake to new, ensuring data quality and continuity
• Business Intelligence Reporting: Develop and enhance BI reports for middle and front office functions to support self-service reporting capabilities for investment strategies
• Requirement Gathering & Documentation: Collaborate with stakeholders to gather specifications, identify potential data improvements, and define detailed technical and business requirements
• Analytics Development: Design and implement performance analytics solutions, ensuring accurate and efficient data flows for reporting purposes
• Business & Technology Collaboration: Act as a liaison between business units and technical teams, ensuring smooth integration of BI solutions that align with organizational goals

To be considered for this role, our client is looking for someone with the following skills/qualifications;

• Education: Bachelor's degree in Finance, Business Analytics, Computer Science, or related field
• Experience:
  • 3+ years experience in a business intelligence or data analytics role within financial services, insurance, or investment sectors
  • Hands-on experience with data warehousing and SQL
  • Proven ability to build BI reports and performance analytics tools that meet business needs
  • Strong knowledge with investment products and derivatives
• Soft Skills:
  • Strong analytical and problem-solving skills, with attention to detail
  • Effective communication skills, with an ability to straddle both business and technical discussions

If you are qualified and interested in this position, please send your updated resume in MS Word to Navneet Kaur at [e-mail]. today!

For other opportunities please visit www.ifg-global.com today!