Business Intelligence Team Lead - North York, Canada - Direct Travel

Direct Travel

Verified Company

North York, Canada

2 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

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.