Data and Reporting Specialist
The Data Intelligence Reporting Specialist will be responsible for data mining, design of, creation and timely production of accurate Global Health reports. Maintenance and support of these reports within the global reporting team as well as across all departments within Operations is also required
**Responsibilities**:
- Creation and maintenance of reports and data in line with documented Key Performance Indicators (KPIs).
- Ability to design, create, maintain, enhance and analyze dashboard reports and KPIs across a number of data intelligence tools.
- Ability to identify changing trends and anomalies in data and investigate/ explain same.
- Ability to translate data, analysis and commentary into a clear and concise story to support management in strategic decisions.
- Creation, test anddelivery of existing and ad-hoc reporting from current systems
- Maintenance of reporting from legacy systems including highly complex reports e.g. Claims trend& Leakage reports to agreed deadlines.
- Ability to gather, interpret, identify gapsand translate business reporting requirements into global reporting solutions.
- Creation of ad hoc data extracts from an oracle database via SQL.
- Understanding database concepts and terminology, database design principles and elements in order to deliver reporting.
- Expert knowledge of the functionality available within PowerBI, Oracle Database, Alteryx, Celonis and Excel.
- Creation and maintenance of robust testing, analysis and aggregation of formatted data to ensure data trustworthiness.
- Enhance Data Quality and Integrity within Allianz Parnters systems.
- Proactively manage own daily, weekly, and monthly workflow to ensure key performance indicators and service standards are met.
- Continue to develop technical and systems knowledge, business and insurance understanding and support other team members.
- Act as the Operations reference point for all Business Information Management related questions.
- Ensure all Operations data performance is aligned with key stakeholder data e.g. regional office alignment.
- Utilize Power BI suite (Power BI Report Builder, Power BI Desktop, DAX, Workspace and Workspace Administration, Premium Capacity Administration, Power Automate, Power BI Apps) to create and manage reports and dashboards.
- Manage and administer data marts, Azure databases, and database administration tasks.
Essential Requirements
- Minimum of 5 years experience with extensive knowledge of Management Information Systems (preferably within the insurance/financial services industry).
- Exceptional analytical skills (capable of understanding complex data structures, organize and structure data extract and transformation processes).
- Excellent presentation skills.
- Customer focused, confident, personable character.
- Personal Effectiveness - highly motivated, proactive, self-starter, responsible and highly committed, high attention to detail and accuracy.
- Experience in working to and meeting deadlines.
- Role model who inspires and motivates others to perform, effective team player.
- Proven Management Information reporting experience and Business Analyst skills including:
- Requirements analysis / ability to interpret users needs
- Source data analysis and consolidation
- Report building and writing
- Financial& KPI reporting
- Data modeling as an integrated model in a common landscape
- Data Quality and Integrity
- Problem solving& effective solution delivery
- Demonstrable expert knowledge of the following tools:
- SQL, MS Excel, MS Access
- Power BI suite (Power BI Report Builder, Power BI Desktop, DAX, Workspace and Workspace Administration, Premium Capacity Administration, Power Automate, Power BI Apps)
- Data marts, Azure databases, and database administration
- Additional experience with the following advantageous:
- VBA, Oracle
74380 | IT& Tech Engineering | Professional | Non-Executive | Allianz Partners | Full-Time | Permanent