Reporting Manager

Responsibilities

• Constantly reviews internal processes and procedures to improve existing reporting
• Undertake ongoing analysis of reporting in the team and wider business to identify reporting efficiencies and the removal of duplicated reporting
• Arrange, agenda and lead monthly meeting with key stakeholders to share the progress and project plan, proactively re-organize/reschedule team priorities and resource to ensure it is aligned with business strategy
• Plans and oversee prioritization of assigned projects and priority tasks in line with project plan, team priorities and internal and external reporting deadlines
• Ensure reporting deadlines and Client SLA agreements are adhered to and where delays or threats to service levels are incurred or at risk, provide regular and informative updates to manage customer expectation
• Maintain a Quality Assurance score of audited reports in the month of 90% or above
• Arrange and hold scope meetings, conduct investigation and deliver scope outline documentation in line with reporting request
• Accountability for evidencing data definitions and justification for data sources and calculations, to ensure that all reports provided are appropriate to the user and in line with the agreed scope
• Collaborate with internal IT Departments in relation to data sources/connections and relevant data tables from controlled IT environments and various back-office systems
• Use SQL Server Management Studio to write statements to design data views, for promotion to the internal Operational Data Store, to create live data connections for reporting tools
• Build and develop interactive and accessible MI dashboards in Microsoft Power BI. Connecting and writing SQL statements to retrieve accurate data from the Operational Data Store, ensure reports are valid and in line with the appropriate scope document
• Develop an all-round understanding of all reportable business areas through interactions with these departments to ensure reporting requirements are fully understood and fulfilled, with an awareness of the insightful impact MI has on decision making within these areas
• Share knowledge through creating and maintaining effective work level instructions, performing on the job training of peers and maintaining open communication in line with development plans
• Provide ad hoc requests for data and reporting, which may be required by immediate or senior management
• Ensure reports and task statuses are kept updated in a timely and efficient manner on relevant reporting tools demonstrating current position and completeness
• Provide technical support for other areas of the business that use Power BI as a reporting tool, being a point of contact for creating data measures and connection to tables

Requirements

• Bachelor's degree in Computer Science, Analytics, Business, Economics, Accounting or a related field.
• Minimum of 4+ years of experience in the fields of insurance, analytics and reporting.
• Expert in visualization techniques, Broad in visual story telling with data, designing highly automated descriptive analytics/reporting solutions, building, integrating and managing databases, creating data models, especially within the Power BI stack, understanding of business needs and processes.
• Experienced in PowerBI, Excel, SSRS and Tableau, Broad in SharePoint, PowerApps, MSFlow, SQL and/or SAS.
• Broad in effective and compelling communication to technical and non-technical departments.

Desired Skills/Experience

• Displays a clear understanding of our TRUE values (Trust, Respect & Integrity, Urgency and Excellence and Accountability).
• Performance Management and Team Management skills.
• Good understanding of organizational structure and goals.
• Highly organized.
• Excellent attention to detail.
• Developing and maintaining effective working relationships with both internal and external contacts.
• Able to communicate effectively with Key Stakeholders and Clients, both face to face and in writing, accurate and realistic timeframes for reporting delivery.
• Accountable for allocated projects and priority tasks and delivery to agreed timelines.
• Able to prioritize own time/workload in line with Project Planning and Key Stakeholder requests.
• Flexible approach to reporting, realigning priorities with business where necessary, adaptable to change.
• Able to work well under pressure, using own initiative.
• Awareness of the effect insightful MI has on decision making.
• Technical skills and knowledge of all team reporting tools, data sources/connections and data tables to enable investigation and delivery of report request.
• SQL/Query building knowledge.
• Inquisitive mind and keenness to learn new systems and processes.
• Acts with urgency, without compromising on quality, with thorough validation and attention to detail.
• Competent at working with Microsoft Office products, specifically Excel.
• Awareness of Microsoft Access and Power BI is advantageous.
• Ability to navigate and develop interactive workflows and forms in SharePoint.
• Solution oriented, ability to explore alternative data methods/sources.