Business Intelligence Team Lead

2 weeks ago

North York, Canada Direct Travel Full time

Business Intelligence Development Team Lead - RemotePosition OverviewAs a key member of the Data Management & Analytics (DMA) team, the Business Intelligence Development lead will be responsible for managing business intelligence requests, and as team grows leading business intelligence development team members. This will be a very hands-on role, involving a fair amount of design, and development of BI semantic models, and BI reports/dashboards. This will include acting as technical product owner of Power BI.For the first year or two -
this role may also work on tasks from either Data team, or Reporting team, as required. As we transition from more traditional reporting this position will be become a full-time BI position, and I expect team will grow. This will be dependent on success on BI initiative.
-this role may use resources from other DMA teams, if required for major initiatives

This role will work closely with internal customers including executives, report development team lead, and data team members. Role will report to Director of Data Management & Analytics.**Responsibilities**:Lead business intelligence initiatives to design, and develop of BI semantic models, and Power BI reports and dashboards using data sourced from our ERP system (Unit 4 ERP), and various other sources. This is a hands-on role requiring lead to be an active team member working on team tasks'projects.
-Manage team’s work queue (Gatekeeper for requests and support)
-Filter requests
-Determine the best data source for a request.
-Determine the best tool for a request (dependent on source, and type of report required)
-Assign work based on skillset, availability, and personnel training'transitioning plans.
-Manage BI internal initiatives'projects, including meeting with external parties.
-Pass on any advanced SQL code through to database team for code review.
-Mentor team.
-Promote best practices for team.
-Enforce team standards and policies.
-Perform development'code review for team as appropriate.
- Meet with user groups to gather detailed BI requirements
-Turn requirements into dimensional data models
-Datamart (DM) Design
-Document source to target mappings - where is data available
-Track and forward any data elements requested that cannot be sourced from Data Warehouse (DW) to data team.
-Design and develop Power BI reports for project initiatives
-Design and develop Power BI Dataset sourced from non-DW'DM sources
- Using advanced Power Query
- Using advance DAXDesign and develop Power BI Dataflow
-Design and develop built for purpose BI semantic model
-Design and develop Corporate Self-Service BI semantic models from all sources
- SSAS Tabular modelsSSAS Cubes - if need arises
-E(T)L design for DM
-E(T)L development for DM
-DM performance tuning
-Support of user'reporting team’s use of BI semantic models
-Support of user'reporting team’s use of data marts
-Support or BI reports and dashboards

Basic Qualifications-
Minimum 5 years of experience in business intelligence and'or data warehousing
-Minimum 10 years of IT'Technical experience
-Communication skills
-Ability to work with executives
-Ability to explain complex situations in a way anyone can understand
-Technical skills
-Detailed understanding of DW concepts
-Dimensional data modeling
-Logical data mart (DM) design
-Advanced SSAS tabular design and implementation
-SSAS performance tuning
-Advanced Power BI model design and implementation
-Advanced Power BI visualization skills
-Advanced Power Query
-Basic M language
-Advanced DAX
-Advanced SQL query skills
-T-SQL Development including stored procedures, udfs, views, and tables.
-Basic SQL performance tuning
-Basic SQL trouble shooting
-SSIS'Cloud Data Factory for moving data from data warehouse into data marts or BI semantic models as required
-Additional skills
-Requirement analysis
-Requirement documentation
-Report design
-Lead skills
-Leadership
-Basic project management skills including resource & task scheduling.
-Mentorship'Training
-Must be able to lawfully work within the US'Canada and have unrestricted work authorization for US'Canada.
-This is not necessarily an exhaustive list of responsibilities, skills, duties, requirements, or efforts associated with the position.

Preferred Qualifications-
Degree in business, computer science, or engineering or a related discipline
-Minimum 1 year of experience in lead'management role
-Technical skills
-Advanced SSAS cube design and implementation
-MDX
-Basic functional understanding of travel, and finance'accounting

About Direct Travel-
- #zr

  • Business Intelligence Team Lead- Remote

    2 weeks ago

    North York, Canada Direct Travel Full time

    **Business Intelligence Team Lead**: - Remote** **Position Overview** As a key member of the Data Management & Analytics (DMA) team, the Business Intelligence Lead will be responsible for managing business intelligence requests, and as team grows leading business intelligence development team members. This will be a very hands-on role, involving a fair...

  • Business Intelligence Systems Business Analyst

    3 weeks ago

    North York, Canada Alliance for Healthier Communities Full time

    Full-Time, Fixed-Term Employee Contract Until March 31, 2025 The Alliance for Healthier Communities is the voice of a vibrant network of community-governed primary health care organizations. Alliance members serve diverse communities across the province of Ontario, and they are rooted in the communities they serve. They share a commitment to advancing...

  • Business Intelligence Systems Business Analyst

    3 weeks ago

    North York, Canada Alliance for Healthier Communities Full time

    **Full-Time, Fixed-Term 2 Year Employee Contract** The Alliance for Healthier Communities is the voice of a vibrant network of community-governed primary health care organizations. Alliance members serve diverse communities across the province of Ontario, and they are rooted in the communities they serve. They share a commitment to advancing health equity...

  • IT Infrastructure Team Lead

    2 weeks ago

    North York, Canada Techify Inc. Full time

    **IT Infrastructure Engineer Team Lead** **Who We Are**:Techify saves time and reduces risk for clients by providing Intelligent Technology services and support. We are a high-performance outsourced IT department for more than 45 companies around the GTA. **Our Purpose**:To do right by our team, our clients, and our company. **Our Values**:Growth Mindset,...

  • Manager, Marketing Intelligence

    2 weeks ago

    North York, Canada Nestle Operational Services Worldwide SA Full time

    **A little bit about us** While Nestlé is known for KitKat, Gerber, Nescafe, and Häagen-Dazs, our recipe for success comes down to one thing: our people. We strive to lead a people-focused culture that empowers employees to bring their authentic selves to work each day. There are 3,000+ members of Nestlé Canada celebrated for taking action using agility,...

  • Manager, Business Intelligence

    2 weeks ago

    North Bay, Canada Ontario Northland Full time

    **POSITION**: Manager, Business Intelligence **REPORTS TO**:Executive Lead, Agency Modernization **DEPARTMENT**:Agency Modernization **LOCATION**: North Bay **REFERENCE**: 800-23-25 **SALARY**: $85,826 - $100,950 **WHO WE ARE**: Ontario Northland Transportation Commission (ONTC) is an Agency of the Province of Ontario that provides efficient and vital...

  • Sales & Marketing Team Lead

    2 weeks ago

    North York, Canada Techify Inc. Full time

    The Sales and Marketing Team Lead will be responsible for growing Techify by finding new clients for our Intelligent Technology program. That includes developing and nurturing a healthy pipeline of potential deals and building relationships with referral partners to feed that pipeline. **Who We Are**: Techify saves time and reduces risk for clients by...

  • Instructor: Artificial Intelligence

    2 weeks ago

    North York, Canada TORONTO BUSINESS COLLEGE Full time

    Toronto Business College is a private career college that has partnered with an Ontario College of Arts and Technology to offer programs to international students in the GTA. Our goal is to provide our students with the theoretical knowledge and practical skills required to thrive in the increasingly dynamic workforce. We strive to offer the most relevant...

  • Instructor: Artificial Intelligence

    2 months ago

    North York, Canada TORONTO BUSINESS COLLEGE Full time

    Toronto Business College is a private career college that has partnered with an Ontario community college to offer programs to international students in the GTA. Our goal is to provide our students with the theoretical knowledge and practical skills required to thrive in the increasingly dynamic workforce. We strive to offer the most relevant programs and...

  • Marketing Intelligence Specialist

    2 weeks ago

    North York, Canada Apotex Inc. Full time

    **About Apotex Inc.** **Job Summary**: The Specialist, Marketing Intelligence reports directly to the Director, Pricing & Marketing Intelligence in a role designed to help drive the Marketing plan of action for Apotex’s broad line of generic pharmaceutical products. The Specialist, Marketing Intelligence will be responsible for developing, managing and...

  • Marketing Intelligence Specialist

    2 weeks ago

    North York, Canada Apotex Full time

    About Apotex Inc. Job Summary The Specialist, Marketing Intelligence reports directly to the Director, Pricing & Marketing Intelligence in a role designed to help drive the Marketing plan of action for Apotex’s broad line of generic pharmaceutical products. The Specialist, Marketing Intelligence will be responsible for developing, managing and...

  • Intelligent Technology Consultant

    2 months ago

    North York, Canada Techify Inc Full time

    Techify is hiring an Intelligent Technology Consultant who will be a key part of our next stage in growth. The IT Consultant is a critical part of delivering the Techify Way and spearheads many of the proactive technology improvements to save our clients time and reduce risk. **Who We Are**: Techify saves time and reduces risk for clients by providing...

  • Intelligent Technology Consultant

    2 days ago

    North York, Canada Techify Inc Full time

    Techify is hiring an Intelligent Technology Consultant who will be a key part of our next stage in growth. The IT Consultant is a critical part of delivering the Techify Way and spearheads many of the proactive technology improvements to save our clients time and reduce risk. **Who We Are**: Techify saves time and reduces risk for clients by providing...

  • Manager, Business Intelligence

    2 weeks ago

    North York, Canada Elections Ontario Full time

    **Manager, Business Intelligence** For accessibility assistance with this document please telephone Elections Ontario at 1-888-668-8683 or Fax at 1-866-714-2809. You can TTY at 1-888-292-2312. **Position Status**: Permanent **Posting Status**: Open **Location**: 26 Prince Andrew Place, North York, ON M3C 2H4 (Don Mills & Eglinton) **Starting Salary**:...

  • RQ06214 Business Intelligence Specialist

    3 weeks ago

    North York, Canada Randstad Canada Remote Work Freelance Full time

    This is a contract position for a Business Intelligence Specialist - Senior for our public sector client.Work location: 777 Bay Street, TorontoDuration: 8 Months7.25 hours/dayThis is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional...

  • RQ06214 Business Intelligence Specialist

    4 weeks ago

    North York, Canada Randstad Canada Remote Work Freelance Full time

    This is a contract position for a Business Intelligence Specialist - Senior for our public sector client.Work location: 777 Bay Street, TorontoDuration: 8 Months7.25 hours/dayThis is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional...

  • Business Intelligence Developer

    4 weeks ago

    York, Canada Robert Half Full time

    Our client is looking for a Business Intelligence Report Developer for a long term contract position. The ideal candidate will have strong experience in SQL, Power BI, Tableau and Azure. This is a hybrid position in Thornhill, Ontario. If you meet the requirements and are interested in this opportunity please apply to the position directly.Key...

  • Business Intelligence Developer

    4 weeks ago

    York, Canada Robert Half Full time

    Our client is looking for a Business Intelligence Report Developer for a long term contract position. The ideal candidate will have strong experience in SQL, Power BI, Tableau and Azure. This is a hybrid position in Thornhill, Ontario. If you meet the requirements and are interested in this opportunity please apply to the position directly. Key...

  • Business Intelligence Developer

    4 weeks ago

    York, Canada Robert Half Full time

    Our client is looking for a Business Intelligence Report Developer for a long term contract position. The ideal candidate will have strong experience in SQL, Power BI, Tableau and Azure. This is a hybrid position in Thornhill, Ontario. If you meet the requirements and are interested in this opportunity please apply to the position directly.Key...

  • Business Intelligence Developer

    3 weeks ago

    York, Canada Robert Half Full time

    Our client is looking for a Business Intelligence Report Developer for a long term contract position. The ideal candidate will have strong experience in SQL, Power BI, Tableau and Azure. This is a hybrid position in Thornhill, Ontario. If you meet the requirements and are interested in this opportunity please apply to the position directly.Key...