Business Intelligence Team Lead

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