• Citizen

• Full Time

• Direct Hire

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 18th May 2022

Job Specifications
• Qualifications Bachelor of Engineering/Technology
• Key Requirement for the Position Python, Power BI, ETL, Insurance knowledge (P&C)
• Experience From5 Years 0 Months
• Experience To7 Years 0 Months
• Job Description
Data Capture
• Expanding and improving on the current Python based ETL process that takes data from monthly flat files and loads them into the SQLite data warehouse.
• Working with third party administrators to transition from a monthly flat file data feed to a daily API feed off data into the SQLite data warehouse.
• Improve and expand upon the current exception reporting that is used to verify the
quality of data received from third party administrators or captured internally.
• Improve and expand upon the controls that exist for loading data into the SQLite data
warehouse.
• Work with volante offshore outsourced partners to document the Claims Data Capture process.
• Work with volante offshore outsourced partners to train team members on Claims Data Capture.
Reporting
• Expanding upon the current Power Bi Claims Reporting, addressing inaccuracies, and improving quality and quantity of information available.
• Improving on the current Bordereau production process, focusing on o Ensuring all required data is provided.
o Bordereau can be produced and distributed in a simple and timely manner.
o Work with volante offshore outsourced partners to document the Claims Bordereau
process.
• Expanding on the current Flat file reporting that is distributed via Python.
• Work with the other functional areas of the business to improve or implement claims
reporting where required.
• Work with volante offshore outsourced partners to document processes for Claims Reporting.
• Work with volante offshore outsourced partners to train team members on Claims Reporting.
Ad hoc work
• Regularly provide reports on progress to Data & Reporting Analyst.
• Proactively raise requests for more work if capacity permits.
• Support the Data & Reporting Analyst on other MI & Reporting work if capacity permits.