Senior BI Developer / BI Team Lead - Remote

NTT DATA Services•Vancouver, BC

11d•Remote

About The Position

Reporting to the Director, Information Management & Reporting, the Senior BI Developer / BI Team Lead leads a development team for execution of the reporting strategy. They have a strong understanding of key BI technologies (end-to-end data warehouse stack) and provide summary analysis and recommendations for leadership. The Senior BI Developer / BI Team Lead monitors and manages delivery to align with business goals and architectural standards, and drives the solution forward based on leadership direction, technical constraints and developer input. The incumbent is a strong team player and is a coach and mentor for the analytics & reporting team.

Requirements

Minimum of 7 years of industry experience in BI.
Minimum 5 years of experience with the Power BI platform, in senior roles.
Minimum 2 years of experience leading teams.
2 years’ experience leading the modernization of legacy reporting solution for a medium to large sized organization Data analysis process, approach and design.
Ability to translate complex business requirements into functional requirements.
Ability to propose technical solutions that best fit needs within the required timeframes and budget.
5 years’ experience with SQL Language (ANSI-92). Ability to mentor others and provide expert level performance tuning for queries on large volume databases
5 years previous experience with Microsoft Power BI concepts, product architecture and vendor roadmap.
Strong Power BI DAX language skills. Power Query (M) skills are considered an asset.
3 years’ experience with supporting a Microsoft Power BI SaaS implementation, including Microsoft data gateways for data refreshes.
1 year experience with Azure and Fabric data platform. Fabric Admin experience is considered an asset.
3 years’ experience with leading development teams for the deployment of Microsoft Power BI reports in a secure corporate environment. Provincial or Federal Government experience will be considered an asset.
3 years’ experience with administration of medium scale Microsoft Power BI environment, including the workspace, security and Power BI deployment pipelines.
3 years’ experience with data warehouse concepts and design, including both on-premise and Cloud based solutions.
3 years’ experience with Physical data modelling concepts, including operational system 3NF and Kimball dimensional modelling.
3 years previous experience with ETL jobs and processes, ETL design concepts and data processing pipelines.
1 year Oracle database experience, especially querying large data volumes, for the purposes of data extraction and reporting
3 years previous experience participating in Data Governance initiatives, such as master data management or data quality initiatives

Nice To Haves

Agile development experience is considered an asset.
Healthcare and/or Health Insurance experience is considered an asset.
Capacity to engage with client(s) to ensure clear and consistent two-way communication.
Demonstrated leadership, coaching skills, and capability to develop direct reports.
Solid communication, listening and oral presentation skills.
Proven relationship building skills, with primary focus on the organization or client’s needs and priorities
Adaptability to changing priorities and evolving circumstances.
Demonstrated analytical and logical thinking, sound judgement skills with the ability to engage necessary resources to solve complex problems.
Ability to effectively plan, prioritize and follow through in a timely manner and with anticipation of potential roadblocks.
Ability to work on multiple competing priorities, including operational and program support, & projects.
Ability to persuade and gain consensus across a diverse group of stakeholders

Responsibilities

Works closely with stakeholders to understand business requirements and translate those into informative, visually appealing and simple to use reporting products
Leads a Business Intelligence (BI) team, including data analysts, quality assurance analysts and BI developers
Designs, delivers and maintains high-quality Power BI reports and dashboards
Accountable for Power BI mentorship for reusability, technical efficiencies and dashboard design
Performs operational troubleshooting to resolve disruptions to reporting service, for data refreshes and Power BI platform problems.
Develops development standards and best practices. Performs quality assurance checks.
Leads Power BI governance, through use of workspaces, appropriate security models and a managed self-service report authoring approach.
Works with the privacy and security teams to ensure that reporting solutions adhere to privacy and security policies.
Responds to work requests. Provides estimates to support timelines and stated deliverables.
Works closely with the data services team (application support) to resolve data warehouse reporting issues or enhancements to currently published database data sets.
Provides architectural leadership for the modernization of a large and complex Oracle reporting environment. Develops and presents options, plans and roadmaps to senior management teams.
Participates, as BI team lead, in transformation activities to identify, detail and prioritize reporting and analytics agile epics and features. Promotes data as an asset and other strategic reporting goals.
Works using the SAFe agile development methodology. This includes acting as Scrum Master for the Information Management & Reporting team.
Participates in the Architectural Council as a BI solution architect and working group meetings to provide expert level input for reporting and analytics business needs.
Participates in client governance meetings to bring forward analytics issues and respond to data access inquiries.
Ensures BI solutions adhere to data governance processes, participates in data governance initiatives and provides expert level input for the impact & considerations to reporting.
Leads the technical implementation of the Power BI Service (SaaS) in a secure technical ecosystem. Acts as Fabric Administrator for the overall solution deployment.