Business Intelligence & Reporting Lead

Responsibilities include

• Lead the development of the business case, requirements, selection, approval and implementation of an enterprise self-service business intelligence, reporting and analytics platform
• Provide expertise and leadership for business intelligence and reporting solutions, architecture, development, and services in support of the organizations strategic goals
• Engage with Business Unit and IT stakeholders to understand business and operational needs to plan and align current and future business intelligence and reporting capabilities to support organizational goals and objectives.
• Ensure ongoing reliability and support of business intelligence systems by working with support and administration teams
• Anticipate future data needs of the organization and champion the use and development of enterprise information assets
• Deliver business intelligence services and solutions that drive data insights and promote a data-driven, decision making culture
• Extensive collaboration with members of the Enterprise Data Services team to architect, develop and schedule the introduction of business intelligence and reporting capabilities to the enterprise
• Act as a mentor for others on the team and provide day-to-day development leadership of the business intelligence solutions environment, including troubleshooting existing procedures and processes
• Provide input to data warehouse data, storage and access requirements for business intelligence solutions
• Ensure development follows best practices with peer review, documentation and end user training for all deployments
• Guide the business in identifying any new business intelligence opportunities including the data needs and delivery mechanisms for delivering reporting solutions
• Engage with the data warehouse development team to define and facilitate the aggregation of data warehouse data for business intelligence solutions
• Liaise with key stakeholders to support business objectives and projects by providing value and input at all stages of project lifecycle
• Liaise with IT Operations, Infrastructure and Security to develop and maintain performance, security and operational monitoring for business intelligence assets
• Provide input to annual budgeting of investments in software and hardware to support the needs of the enterprise’s demands and expectations for data and data services

   

  Skills / Knowledge / Education

• Completion of a University degree or equivalent experience
• 7+ years work experience in data warehousing, business intelligence and reporting tools
• 2-3 years of experience in data modeling
• Experience with Life Insurance/Financial Services data
• Proven experience leading and delivering business intelligence application solutions from specification through to end-user acceptance testing
• Experience in the documentation of functional and non-functional requirements for business intelligence and reporting solutions
• Experience in the selection of software and services solutions
• Experience with multiple business intelligence tools
• Experience in data warehouse development and architecture with some hands-on physical and logical database design experience
• Moderate to expert level experience in Structured Query Language development
• Experience in database administration is desirable
• Experience in business process engineering and modelling
• Experience with Pentaho Data Integration ETL tool
• Experience with multiple ETL tools is highly desirable
• Experience with GitHub, Jira and other DevOps tools is desirable
• Experience with development methodologies (e.g., Scrum) and project management

   

  Working Conditions

• Office environment
• Prolonged periods of concentration and attention to detail
• Prolonged periods of sitting while using a computer and/or telephone
• May be required to work overtime
• Travel may be required