Data Intelligence Reporting Specialist APAU

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.
• Understand the data relationships that exist between the business processes and systems.  In turn apply this knowledge when interpreting the information requirements from the business.
• 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 and delivery 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 gaps and 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

Allianz Group is one of the most trusted insurance and asset management companies in the world. Caring for our employees, their ambitions, dreams and challenges, is what makes us a unique employer. Together we can build an environment where everyone feels empowered and has the confidence to explore, to grow and to shape a better future for our customers and the world around us. 
We at Allianz believe in a diverse and inclusive workforce and are proud to be an equal opportunity employer. We encourage you to bring your whole self to work, no matter where you are from, what you look like, who you love or what you believe in.
We therefore welcome applications regardless of ethnicity or cultural background, age, gender, nationality, religion, disability or sexual orientation.
Great to have you on board. Let's care for tomorrow.