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 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 is a remote position and 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, report development team lead, and data team members. Role will report to Manager 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 the database team for code review.
- Mentor team.
- Promote best practices for the team.
- Enforce team standards and policies.
- Perform development'code review for the team as appropriate.
- Meet with user groups to gather detailed BI requirements
- Turn requirements into dimensional data models
- Datamart (DM) Design
- Document data source to target mappings
- Track and forward any data elements requested that cannot be sourced from Data Warehouse (DW) to the 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 advanced DAX
- Design 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 models
- SSAS Cubes - if the need arises
- Design and develop E(T)L for DM
- DM performance tuning
- Support of user'reporting team’s use of BI semantic models and data marts
- Support of Direct Intelligence'Travel Optics BI semantic model (Qlik Sense)
- Support of BI reports and dashboards

**Basic Qualifications**
- Minimum 5 years of experience in business intelligence and'or data warehousing
- 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 QLIK Sense model design
- Basic functional understanding of travel, and finance'accounting

**About Direct Travel**

Our growing company relies on excellence to deliver on our commitments to our customers. This starts with our employees. Our inclusive culture encourages entrepreneurial spirit empowering employees to build strong, long-lasting relationships with our customers and deliver innovative solutions.

Direct Travel is one of the most respected Travel Management companies providing our customers with smart consultation, tailored solutions and a true partnership. Our s

  • 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...

  • 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,...

  • 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...

  • 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...

  • Business Intelligence/ BI Developer

    4 weeks ago

    York, ON, 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. Builds complex SQL queries, reports(SSRS/Power BI), and dashboards (Power BI) to meet business needs. Design, develops and implements BI solutions using technology best...

  • Remote Mortgage Agent

    2 weeks ago

    North York, Canada Turkin Mortgage Team Full time

    **Remote Mortgage Agent** **About You** **Do you enjoy talking to people ? Are you a good listener and think quickly on your feet? Are you detail oriented and have a passion for helping clients? Do you enjoy working in a fast paced environment with the latest technology and innovative ideas? If you answered “YES” to all of the above, we’d love to...

  • Remote Technology Business Development Representative

    4 weeks ago

    North York, ON, Canada Ecom Logistics Full time

    Founded in 2017 in Toronto, Canada, Ecom Logistics was established to address gaps in supply chain management, warehousing, fulfillment, shipping, and delivery services for North American businesses. Connecting businesses and communities to a better future through sustainable logistics. #To enable the growth of North American businesses by providing quality...

  • Remote Technology Business Development Representative

    3 weeks ago

    North York, ON, Canada Ecom Logistics Full time

    Founded in 2017 in Toronto, Canada, Ecom Logistics was established to address gaps in supply chain management, warehousing, fulfillment, shipping, and delivery services for North American businesses. Connecting businesses and communities to a better future through sustainable logistics. #To enable the growth of North American businesses by providing quality...

  • 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...

  • Business Intelligence Specialist

    2 weeks ago

    North York, 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 **Business...

  • 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...

  • Implementation Lead

    2 months ago

    North York, Canada Direct Travel Full time

    **IMPLEMENTATION LEAD - Remote** **Position Overview** As a key member of the Implementation team, the Implementation Lead will be responsible for delivering timely and successful new corporate account implementations on behalf Direct Travel. This role will also lead internal Direct Travel projects as needed. This position will coordinate efforts with...

  • 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...

  • 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**:...