Job descriptionSenior BI Developer / BI Team Lead – Remote (Canada)
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.
Job Duties
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
Required Skills
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
Agile development experience is considered an asset
Healthcare and/or Health Insurance experience is considered an asset
Preferred Skills
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
Equal Opportunity Employer NTT DATA is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.
#J-18808-Ljbffr