Data and Reporting Engineer Apply
locations: PHI - Manila, Cebu, Philippines
Time Type: Full time
Posted on: Posted Yesterday
Job Requisition ID: 324555
Primary Details Time Type: Full time
Worker Type: Employee
Based in Manila and reporting to the Sr. Reporting Analyst, AUSPAC Reporting, this role will support the BAU and Ad-Hoc reporting needs of the AUSPAC region, preparing reports for use across AO business units including Actuarial, Commercial Lines, Personal Lines, Credit lines, Partnership and Specialty, CTP, Worker's Compensation, Casualty and Specialty, Underwriting, Claims, and Finance reporting. This role will be responsible for producing complex reporting and analytics, automation, dashboard creation, and reports consolidation across the function. This role will involve the design and development of reporting tools that are published across the organization. This will require analytical and technical skills, in addition to a keen ability to determine standards for business reporting and maintaining data integrity.
Primary Responsibilities Produce complex and specialized reports with insights for AO Business Units. Act as a subject matter expert in data and reporting within the AUSPAC region. Responsible for data query/drill down and analysis – They will act as the data owners/data stewards for AO division. Report developers and visualization experts - creation of infographics for effective presentation and communication of actionable outcomes. Develop content strategy and information/report architecture to support AO business units through Ad-Hoc requests. Leading and managing onshore reporting project requirements and direct contact of specific AO business units. Identify and propose improvements to the current reporting templates and own the end-to-end report preparation process. Build and maintain effective ongoing working relationships across the team to understand needs and best support the team. Responsible for reports quality audits of peers. Required Education Bachelor's Degree or equivalent combination of education and work experience
Required Experience 5 years relevant experience
Preferred Competencies/Skills Advanced proficiency in MS Excel (use of macros, pivot tables, formulas). Advance programming skills in SAS, SQL, Tableau, Power BI, Alteryx, and Macro VBA. Data management skills. Well-developed analytical and problem-solving skills, with strong attention to detail. Ability to analyze and interpret data, identify trends or emerging patterns, and present findings aligned with the team's key performance indicators to stakeholders. Ability to work independently, with limited direction and guidance, and provide appropriate coaching to other AUSPAC Reporting team members. Strong verbal and written communication skills, to effectively present to peers and management. Keen attention to detail. Experience in performing multiple projects and working with varying team members. Adaptable to change and able to work in a high changing environment. Stakeholder management skills. Preferred Education Bachelor's Degree or equivalent combination of education and work experience
Preferred Education Specifics Degree qualified in Actuarial, Computer Science, IT, Accountancy, Mathematics, Statistics, Economics, or related discipline
Preferred Experience 5 years experience in a reporting process and design/data analytics/report automation role is required. Experience in insurance data and reporting is preferred. Experience working in a similar support role at the same time doing quality audits. Experience working at a BPO reporting for onshore stakeholders. Preferred Licenses/Certifications Power BI Certified. SAS Certification. Tableau Certification. Alteryx Certification. Preferred Knowledge Demonstrated understanding of design and development of reporting tools and dashboards. Broad knowledge of data analysis, extraction, and management techniques for insurance portfolios. Strong mathematical and statistical knowledge. Fundamental knowledge in Report template creation and design. Insurance data and reporting knowledge is preferred.
#J-18808-Ljbffr