Expires 2 weeks from now
Data & Analytics Engineer
Python
full-time
| Executive
Lagos,
Lagos
Share this job
Job Summary
The Data & Analytics Engineering function is responsible for building and maintaining the data pipelines, models, and platforms that power AIICO’s Enterprise Data Warehouse (EDW) and business intelligence initiatives. This role combines data engineering and analytics engineering to ensure that high-quality, well-modeled, and timely data is available for reporting, advanced analytics, and actuarial IFRS17 Reporting.
Job Details
a. Data Engineering
- Maintain the Enterprise Data Warehouse (EDW) as a trusted single source of truth to support analytics, reporting, and advanced modeling.
- Design, build, and optimize ETL/ELT pipelines using Python, dbt, and Airflow for orchestration.
- Collect and load structured and unstructured data from internal and external systems.
- Manage the organization-wide data collection process for IFRS17, automating inputs from data stewards and producing monthly outputs for actuarial evaluations.
- Design and optimize dbt models, transforming raw data into analytics-ready datasets.
- Ensure data quality, accuracy, and integrity across all pipelines and reporting systems.
- Analyze the organization’s data maturity level, uncover gaps, and recommend improvements.
- Continually assess data quality, clean dirty data and raise concerns over gaps with closure recommendations
- Implement best practices for data governance, model testing, validation, and documentation.
- Ensure proper version control and CI/CD workflows using Git and Azure DevOps.
- Collaborate with analysts, actuaries, and business stakeholders to deliver actionable insights.
- Uphold data security and governance in collaboration with DBAs and system administrators.
- Assess new and existing data systems and continually uncover gaps to improve data maturity
b. Analytics Engineering
- Develop, maintain, and optimize dbt models with tests, documentation, and version control.
- Translate business requirements into scalable data models that serve analytics and reporting needs.
- Support incremental data refreshes transformation logic to improve automation and scalability.
- Continuously monitor and troubleshoot data workflows within the warehouse for improvement.
- Create Machine learning models for predictive analytics
- Collaborate with business units to define KPIs, use cases, and reporting needs.
- Support the development of BI solutions using SSRS, SSIS, and SSAS.
- Enable Data Analysts and business stakeholders by providing well-structured, analytics-ready datasets.
- Provide technical guidance for predictive analytics and advanced statistical modeling.
- Supply Data models and insightful knowledge base to AIICO Intellect AI system
Requirements
- HND/B.Sc. in Computer Science or any related discipline.
- Knowledge of SQL & Python is an added advantage
- Minimum of 3 - 4 years experience.
Benefits
Thrive Professionally and Personally at AIICO Insurance Plc.
At AIICO Insurance Plc., we believe in fostering an environment where individuals excel, both personally and professionally. We offer a comprehensive employee value proposition designed to empower you, support your well-being, and fuel your career aspirations.
We offer:
Stress-Free Work-Life: Hybrid work schedules, competitive leave, and reliable transportation.
Holistic Wellbeing: Health & and wellness programs, and subsidized gym memberships.
Grow with Us: Sponsorship for professional certifications, coaching, learning and development opportunities, and more.
At AIICO, we recognize that our employees are our greatest asset. We are committed to fostering a supportive culture where you feel valued, respected, and empowered to achieve your full potential.
Join us and embark on a rewarding career journey that makes a difference.
About Company
AIICO Insurance Plc
AIICO Insurance Established in 1963, AIICO Insurance Plc (NSE Ticker: “AIICO”) is a financial services group with market-leading positions in its key business lines; Insurance, Health Maintenance and Asset Management. Background AIICO commenced operations in Nigeria in 1963 as an Agency office of American Life Insurance Company (“ALICO”) – at the time, a subsidiary of American International Group (“AIG”). The Company was incorporated, registered and licensed in Nigeria as American Life Insurance Company Limited – as a wholly owned subsidiary of ALICO/AIG – in 1970 – to offer Life and insurance services. The Company was renamed American International Insurance Company Limited (“AIICO”) upon the acquisition of a 60% stake by the Federal Government of Nigeria, and later listed on the Nigerian Stock Exchange in 1990, after which both shareholders – the Federal Government of Nigeria and AIG divested. 1. Life and general insurance are strategic business divisions within AIICO. 2. AIICO Capital Limited – a subsidiary of AIICO providing asset management services for AIICO and 3rd parties. 3. AIICO Multishield Limited – a leading health maintenance organisation. Following the insurance industry's consolidation in 2007, the Company acquired NFI Insurance PLC and Lamda Insurance Company Limited (both cumulatively accounting for less than 30% of AIICO's pre-acquisition gross premiums). The Company subsequently re-certified as both a General Insurance and Life Assurance Company – taking advantage of its legacy, brand, franchise and strong retail distribution network to grow a leading General Insurance business.