Business Intelligence Consultant

7 months ago


Toronto, Canada INNOVER GLOBAL INC Full time

**Responsibilities**:

- Lead the design and development of data warehouse solutions using SQL Server, ADF, and other ETL tools.
- Build and optimize databases, data warehouses, and data marts, with a focus on delta/incremental and full loads.
- Collaborate with cross-functional teams to analyze requirements, design data models, and develop ETL programs.
- Implement best practices for data modeling, including snowflake and star schema models, and slowly changing dimensions.
- Conduct performance optimization and tuning of databases and ETL processes to ensure optimal system performance.
- Work closely with designers, business analysts, and other developers to understand business requirements and translate them into technical solutions.
- Assist in troubleshooting and resolving issues related to data integrity, performance, and scalability.
- Liaise with project managers, quality assurance analysts, and business intelligence consultants to ensure successful project delivery.
- Design and implement technical enhancements of the data warehouse as required, in alignment with business objectives.

**Qualifications**:

- 7+ years of experience working as a Business Intelligence Consultant or similar role is required.
- String experience working with SQL Server, ADF, and T-SQL development is a must.
- Proven experience in building databases, data warehouses, and data marts, with a focus on delta/incremental and full loads.
- Experience with ETL tools such as SQL Server, ADF, and cloud-based tools is required.
- Strong understanding of data modeling concepts and tools, such as SAP Power Designer.
- Knowledge of database performance optimization techniques and ability to conduct unit tests.
- Excellent communication and collaboration skills, with the ability to work effectively in a cross-functional team environment.
- Bachelor's degree in computer science, engineering, or related field is preferred.

Flexible work from home options available.



  • Old Toronto, Canada Valona Intelligence Group Full time

    Transform Business Decision-Making with Valona Intelligence GroupWe are seeking a skilled Business Intelligence Research Specialist to join our dynamic team in Toronto, Canada.About the Role:Monitor business environments and industry trends using market intelligence platforms and publicly available sources.Synthesize large volumes of industry news to...


  • Toronto, Ontario, Canada Rubicon Path Full time

    Rubicon Path is seeking a Senior Business Intelligence Consultant to join our team. This role will focus on delivering high-quality business intelligence solutions using Oracle's analytics offerings.About the RoleThe ideal candidate will have 5+ years of experience in developing customer solutions using Oracle Analytics Cloud, Data Visualization, Fusion...


  • Old Toronto, Canada Valona Intelligence Group Full time

    Valona Intelligence Group, a leading global provider of competitive and market intelligence solutions, is seeking an energetic and detail-oriented Strategic Business Insights Specialist to join our dynamic North America Content Services team in Toronto.Job SummaryThis is a remote work position with optional work days and periodic team sessions from our...


  • Toronto, Ontario, Canada Arthur Grand Technologies Inc Full time

    At Arthur Grand Technologies Inc, we leverage the expertise of seasoned professionals who have worked for top-tier consulting firms to drive business growth through data-driven decision making.Key Responsibilities:Develop and maintain robust business intelligence solutions to support strategic decision making.Analyze complex data sets to identify trends and...


  • Toronto, Canada Astek Full time

    Job OverviewAstek, a leading global player in engineering and technology consulting, is seeking a highly skilled Business Intelligence (BI) developer to join its team. With over 7800 employees worldwide, Astek supports international clients in the intelligent deployment of their products and services.


  • Old Toronto, Canada ROSS Full time

    Are you a skilled programmer and analyst looking for a new challenge? Ross is seeking a Business Intelligence Technical Consultant to join our team.About the RoleWe are a leader in business intelligence and analytics, providing an integrated platform for data analysis and predictive insights. As a Business Intelligence Technical Consultant, you will work...

  • Business Intelligence

    14 hours ago


    Toronto, Canada Ministry of Public and Business Service Delivery Full time

    The Enterprise Financial Services Division (EFSD) is part of Ontario Shared Services. EFSD manages and operates two enterprise systems to support effective financial management and transfer payment administration for the Government of Ontario - the Integrated Financial Information System (IFIS) and Transfer Payment Ontario system. This role is in the...


  • Toronto, Canada Dawn InfoTek Inc. Full time

    Dawn InfoTek Inc. is a professional IT consulting team that partners with major financial institutions, investment firms and government sectors. We have been dedicated to delivering cutting-edge consulting services and recruiting all levels of IT positions for our clients. **Responsibilities**: - Assist with gathering business and information...


  • Toronto, Canada Dawn InfoTek Inc. Full time

    Dawn InfoTek Inc. is a professional IT consulting team that partners with major financial institutions, investment firms and government sectors. We have been dedicated to delivering cutting-edge consulting services and recruiting all levels of IT positions for our clients. We are currently seeking competent individuals to fulfill the role of Junior BI...


  • Old Toronto, Canada ROSS Full time

    We are Ross, a leading provider of business intelligence solutions, and we are seeking an experienced Business Intelligence Project Lead to join our team.As a Business Intelligence Project Lead at Ross, you will be responsible for managing complex implementation projects, defining production consulting scope, and mentoring Productions Consultants. You will...


  • Toronto, Canada EXL Full time

    EXL (NASDAQ: EXLS) is a global analytics and digital solutions company that partners with clients to improve business outcomes and unlock growth. Our Analytics division provides data-driven, action-oriented solutions to business problems through statistical data mining, cutting edge analytics techniques and a consultative approach. Leveraging proprietary...


  • Toronto, Canada EXL Full time

    EXL (NASDAQ: EXLS) is a global analytics and digital solutions company that partners with clients to improve business outcomes and unlock growth. Our Analytics division provides data-driven, action-oriented solutions to business problems through statistical data mining, cutting edge analytics techniques and a consultative approach. Leveraging proprietary...


  • Toronto, Canada VML MAP Full time

    Do you have a knack for uncovering game-changing insights from complex data? Do you excel at building strong client relationships and transforming numbers into compelling stories and client presentations that drive customer behavior for global brands? If so, seize this opportunity to make a significant impact as a Performance Intelligence Consultant at VML...


  • Toronto, Canada Wunderman Thompson MAP Full time

    DEC 23, 2024 Do you have a knack for uncovering game-changing insights from complex data? Do you excel at building strong client relationships and transforming numbers into compelling stories and client presentations that drive customer behavior for global brands? If so, seize this opportunity to make a significant impact as a Performance Intelligence...


  • Toronto, Canada V-Tech Solutions Full time

    **Job Title**:Bi Specialist** **Location**:Toronto, Ontario (Hybrid)** **Duration: 6 Months Contract** Ontario Tourism Marketing Partnership Corporation (operating as Destination Ontario) would like to engage the People Placement Service to procure a resource that can help our President & CEO’s Office in establishing and implementing standardized...


  • Toronto, ON, Canada EXL Full time

    EXL (NASDAQ: EXLS) is a global analytics and digital solutions company that partners with clients to improve business outcomes and unlock growth. Our Analytics division provides data-driven, action-oriented solutions to business problems through statistical data mining, cutting edge analytics techniques and a consultative approach. Leveraging proprietary...


  • Toronto, ON, Canada EXL Full time

    EXL (NASDAQ: EXLS) is a global analytics and digital solutions company that partners with clients to improve business outcomes and unlock growth. Our Analytics division provides data-driven, action-oriented solutions to business problems through statistical data mining, cutting edge analytics techniques and a consultative approach. Leveraging proprietary...


  • Toronto, Ontario, Canada Tata Consultancy Services Full time

    Tata Consultancy Services is an IT services, consulting and business solutions organization with a presence in over 55 countries. As a Business Intelligence Developer, you will be part of our team that partners with clients to deliver innovative solutions.We are committed to meeting the accessibility needs of all individuals in accordance with the...


  • Toronto, Canada KPMG Full time

    Overview: At KPMG, you’ll join a team of diverse and dedicated problem solvers, connected by a common cause: turning insight into opportunity for clients and communities around the world. KPMG Corporate Intelligence protects its clients by helping them better understand the backgrounds of individuals and companies with whom they are considering doing...


  • Toronto, Canada Quarry Consulting Full time

    We are seeking a highly skilled Senior Business Intelligence Specialist to join Quarry Consulting in Canada. This is a 1-year contract position, with a hybrid work arrangement of 2 days a week on-site at multiple sites throughout Canada.Due to the high volume of resumes, we will only contact candidates who clearly demonstrate the required experience in their...