Business Intelligence (BI) Developer at APA Life Assurance Company Ltd

KEY PRIMARY RESPONSIBILITIES

BI Solution Development

• Design, develop, and maintain interactive dashboards, reports, and visualizations using BI tools (e.g., OBIEE, Power BI, Tableau, Looker, QlikView).
• Develop and optimize data models to ensure efficient and accurate reporting.
• Automate data extraction, transformation, and loading (ETL) processes.

Data Management & Integration

• Collaborate with database administrators to design and maintain data warehouses.
• Develop and optimize SQL queries, stored procedures, and views to support reporting needs.
• Integrate data from multiple sources, ensuring data integrity and accuracy.

Stakeholder Engagement & Requirements Gathering

• Work closely with business users to gather reporting and analytics requirements.
• Translate business needs into technical specifications and BI solutions.
• Provide training and support to business users on BI tools and reports.

Performance Optimization & Troubleshooting

• Monitor and improve BI solutions' performance and efficiency.
• Troubleshoot and resolve issues related to BI tools, reports, and data quality.
• Ensure data security and access control policies are enforced.

Continuous Improvement & Innovation

• Research and implement best practices in BI development and analytics.
• Stay updated with emerging BI trends and technologies to enhance reporting capabilities.
• Participate in BI strategy development and process improvement initiatives.

ACADEMIC QUALIFICATIONS

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a related field.

JOB SKILLS AND REQUIREMENTS

• Ability to work with large datasets and complex reporting requirements.
• Strong business acumen and ability to translate data into actionable insights.
• Detail-oriented with a focus on data accuracy and integrity.
• Ability to work independently and collaboratively within a team.
• Excellent communication and stakeholder management skills.

PROFESSIONAL QUALIFICATIONS

• Microsoft Certified: Data Analyst Associate (PL-300)
• Oracle Database PL/SQL Developer Professional

EXPERIENCE

• 3+ years of experience in business intelligence, data analytics, or a related role.
• Strong proficiency in BI tools such as OBIEE, Power BI, Tableau, or Looker.
• Advanced knowledge of SQL and database technologies (e.g., Oracle, SQL Server, PostgreSQL, MySQL).
• Experience in ETL development using tools like ODI, SSIS, Talend, or Informatica.
• Familiarity with data warehousing concepts and best practices.
• Knowledge of programming languages like Python or R.Strong problem-solving, analytical, and communication skills.