Data / Business Intelligence Analyst at Sigma Consult

• The Data / Business Intelligence Analyst will be responsible for transforming complex, multi-source data into actionable insights that drive strategic and operational decision-making across the organization.
• The role requires a strong blend of technical expertise, analytical capability, and business acumen. The successful candidate will act as a critical bridge between data systems and business stakeholders, delivering high-quality analytics, dashboards, and reporting solutions that enhance organizational performance—particularly within the insurance industry.

KEY RESPONSIBILITIES

Data Analysis & Modelling

• Collect, analyze, and interpret large, complex datasets from multiple sources.
• Identify trends, correlations, and patterns to support business insights.
• Develop, optimize, and maintain scalable data models and database structures.
• Ensure data accuracy, integrity, and availability across all systems.

Business Intelligence Development

• Design, develop, and deploy interactive dashboards and reports using Power BI or Tableau.
• Provide real-time visibility into key business metrics and KPIs.
• Continuously enhance reporting tools to meet evolving business needs.

Data Engineering & Process Optimization

• Develop and standardize data cleansing, transformation, and validation processes.
• Improve data workflows and pipelines for efficiency and scalability.
• Identify opportunities for operational improvements through advanced analytics.

Reporting & Analytics Framework

• Establish and manage a centralized reporting structure across departments.
• Serve as the primary point of contact for enterprise-wide data and reporting requests.
• Ensure consistency and standardization in reporting formats and metrics.

Strategic Decision Support

• Translate business requirements into analytical solutions and reporting outputs.
• Provide data-driven insights and recommendations to senior management.
• Support long-term strategic planning through predictive and trend analysis.

Data Governance & Compliance

• Develop and enforce data governance policies, standards, and best practices.
• Ensure compliance with data protection regulations and reporting standards.
• Promote data quality, security, and ethical analytics practices.

KEY DUTIES / DAY-TO-DAY ACTIVITIES

• Extract, query, and analyze data from relational databases such as SQL Server, Oracle, and MySQL.
• Perform data cleaning, transformation, and preprocessing using SQL, Python, or Excel.
• Monitor automated dashboards and reports, identifying and resolving discrepancies.
• Conduct statistical, diagnostic, and predictive analyses to solve business problems.
• Collaborate with cross-functional teams within Agile project environments.
• Maintain detailed documentation of data processes, models, and reporting frameworks.

QUALIFICATIONS & REQUIREMENTS

Educational Qualification

• Minimum of HND / B.Sc. in Computer Science, Statistics, Mathematics, or any related quantitative discipline.

Experience

• 3–5 years of progressive experience in Data Analysis or Business Intelligence roles.
• Mandatory: Prior experience within the Insurance Industry.

TECHNICAL COMPETENCIES

• SQL: Advanced proficiency in SQL Server (query optimization, performance tuning, database objects).
• BI Tools: Strong hands-on experience with Power BI or Tableau.
• Programming: Proficiency in Python or R for data analysis and automation.
• Microsoft Excel: Advanced skills (Pivot Tables, Power Query, Macros).
• Database Systems: Solid knowledge of SQL Server, Oracle, and MySQL environments.