Data and Reporting Analyst
Data and Reporting Analyst
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Primary Details
Time Type: Full timeWorker Type: EmployeeA Data and Reporting Analyst is responsible for collecting transforming and storing data from various sources ensuring data quality and integrity and creating meaningful reports and dashboards for stakeholders. They bridge the gap between data sources and end-users enabling data-driven decision-making within QBE. . This role will also 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 project driven and will be direct contact of onshore stakeholders on certain projects that will be assigned.Primary Responsibilities
Data Extraction and Transformation:
Gather data from diverse sources such as databases APIs and flat files.
Clean transform and preprocess data to ensure accuracy and consistency.
Develop and maintain ETL (Extract Transform Load) processes.
Data Warehousing:
Design and maintain data warehouses or data lakes to store and organize data efficiently.
Implement data modeling and schema design to optimize data retrieval.
Big data management
Database Management:
Administer and optimize databases for performance and scalability.
Ensure data security and access control measures are in place.
Reporting and Visualization:
Create interactive dashboards and reports using tools like Tableau Power BI or custom-built solutions.
Collaborate with business analysts and stakeholders to define reporting requirements.
Data Quality and Governance:
Implement data quality checks and validation processes.
Establish data governance policies and procedures to maintain data integrity.
Perform root cause analysis on data queries from stakeholders
Automation and Scalability:
Develop automated solutions for data processing and reporting tasks.
Scale data pipelines and reporting systems to handle growing volumes of data.
Performance Monitoring:
Monitor system performance troubleshoot issues and optimize query performance.
Implement alerting mechanisms for system failures or anomalies.
Documentation and Knowledge Sharing:
Maintain documentation for data pipelines data models and reporting processes.
Collaborate with team members and stakeholders to share knowledge and best practices.
Technical Expertise:
Stay up-to-date with emerging technologies and best practices in data engineering and reporting.
Continuously enhance skills in SQL data modeling and reporting tools.
Project Management:
Leading and managing onshore reporting project requirements and direct contact of specific AO business units.
Implement Agile methodology on different reporting projects
Quality Assurance:
Implement data quality checks to ensure data integrity.
Identify and address data quality issues as they arise.
Audit reports produced by the team ensuring DTP is adhered to.
Required Education
Bachelors Degree or equivalent combination of education and work experience
Required Experience
7 years relevant experience
Preferred Competencies/Skills
Proficiency in data modeling SQL and database management systems (e.g. SQL Server Oracle PostgreSQL).
Experience with ETL tools and processes ( Base SAS EG Apache NiFi Apache Spark Talend).
Knowledge of data warehousing concepts and technologies (e.g. Snowflake Redshift BigQuery).
Familiarity with reporting and visualization tools (e.g. Tableau Power BI QlikView).
Programming skills in languages such as Python Java or Scala for data processing and automation.
Strong analytical and problem-solving skills.
Understanding of data governance and data security principles.
Excellent communication skills to work effectively with cross-functional teams and business stakeholders.
Ability to adapt to evolving technologies and trends in data engineering and reporting.
Preferred Education
Bachelors 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
7 years minimum experience in SAS Base SAS EG SQL Excel Tableau Power BI Has been involved in multiple automation initiatives that delivered tangible benefits
At least 1 year experience in the financial services industry preferably in insurance
Working experience in a consulting or shared services environment preferred
Bachelors Degree in Computer Science Information Technology or any related field or equivalent work experience.
Preferred Licenses/Certifications
All Certification below are preferred;
Power BI Certified
SAS Certification
Tableau Certification
Alteryx Certification
Preferred Knowledge
General knowledge of insurance business and related market conditions preferred
Fundamental knowledge of data analysis extraction and management techniques for insurance portfolios
Strong mathematical and statistical knowledge
Fundamental knowledge in Report template creation and design
Agile methodologies such as Scrum Kanban and Lean.
QBE Cultural DNA
Everything we do at QBE is underpinned by our DNA (which interlinks seven cultural elements) because we know its not just what we do that matters its how we do it that makes the difference. We expect all employees to role model and inspire the right behaviours that link to our cultural elements:
We are customer-focused
We are technical experts
We are inclusive
We are fast-paced
We are courageous
We are accountable
We are a team
All employees are expected to adhere to QBEs Code of Ethics and Conduct and apply sound risk management practices
US Only - Travel Frequency
NA
US Only - Physical Demands
General office jobs: Work is generally performed in an office environment in which there is not substantial exposure to adverse environmental conditions. Must have the ability to remain in a stationary position for extended periods of time. Must be able to operate basic office equipment including telephone headset and computer. Incumbent must be able to lift basic office equipment up to 20 lbs.
US Only - Disclaimer
To successfully perform this job the individual must be able to perform each essential job responsibility satisfactorily. Reasonable accommodations may be made to enable an individual with disabilities to perform the essential job responsibilities.
Job Type
Individual Contributor
Australia/New Zealand Only - Advice/Non-Advice
Non-Advice: This role is not authorised to provide financial product advice to retail customers in respect of General Insurance products. Financial product advice means a statement or recommendation made to a retail customer with the intention of influencing their decision in considering a general insurance product.
Global Disclaimer
The duties listed in this job description do not limit the assignment of work. They are not to be construed as a complete list of the duties normally to be performed in the position or those occasionally assigned outside an employees normal duties. Our Group Code of Ethics and Conduct addresses the responsibilities we all have at QBE to our company to each other and to our customers suppliers communities and governments. It provides clear guidance to help us to make good judgement calls.
Skills:
Business Intelligence Applications Business Reporting Critical Thinking Customer Service Detail-Oriented Financial Products Insurance Claims Management Intentional collaboration Managing performance Reporting and Analysis Report Writing Risk Management Sound Judgment Stakeholder Management Working IndependentlyHow to Apply:
To submit your application click Apply and follow the step by step process.
Equal Employment Opportunity:
QBE is an equal opportunity employer and is required to comply with equal employment opportunity legislation in each jurisdiction it operates.
Required Experience:
IC
Employment Type
Full-Time
