Business Intelligence and Reporting
- Design develop and maintain interactive dashboards and reports using Power BI to support operational management and executive decision-making.
- Build efficient and scalable data models applying best practices such as star schema design and performance optimization.
- Develop and maintain DAX measures for KPIs trends time intelligence and performance monitoring.
- Ensure dashboards are intuitive user-friendly and aligned with business requirements and objectives.
Data Extraction Transformation and Analysis
- Write optimize and maintain SQL queries to extract transform and analyze data from multiple source systems.
- Conduct quantitative analysis including trend analysis variance analysis and time-series analysis.
- Support ad-hoc analysis and deep dives to address business questions and management requests.
Data Quality Governance and Compliance
- Ensure the accuracy consistency and integrity of reported data across all dashboards and reports.
- Validate data to ensure it is auditable and third-party verifiable
- Align reporting outputs with internal standards and external reporting or regulatory frameworks.
- Maintain clear documentation for datasets KPIs and reporting logic.
Automation and Continuous Improvement
- Support automated and scheduled reporting workflows to improve efficiency and accessibility of insights.
- Identify opportunities to optimize BI processes dashboards and SQL queries for performance and scalability.
- Contribute to the continuous improvement of analytics standards tools and best practices.
Collaboration and Stakeholder Engagement
- Work closely with the Lead Business Analytics to support enterprise BI initiatives and analytics automation.
- Collaborate with cross-functional teams (I.T. Operations Finance Product Audit and Risk) to translate business requirements into analytics solutions.
- Communicate insights clearly and effectively to both technical and non-technical stakeholders.
- Bachelors degree in business Analytics Data Science Computer Science Engineering Economics Statistics Mathematics or a related field.
- Certifications in Power BI or other BI tools are an added advantage.
- 23 years of experience in Business Intelligence Data Analytics or a related role.
- Experience working in banking fintech lending or regulated data environments is an advantage.
- Strong hands-on experience with Power BI including:
o DAX (measures calculated columns time intelligence)
o Data modeling and performance optimization
o Dashboard design and data storytelling
- Strong SQL skills for querying transforming and analyzing data.
- Experience working with large multi-source datasets.
Soft Skills:
- Strong analytical and problem-solving skills.
- Excellent communication skills with the ability to explain insights clearly.
- Strong attention to detail and organisational skills
- Ability to manage multiple tasks and priorities effectively.
- Collaborative team player with a proactive and professional attitude.
Person Specification
- Strong understanding of data analysis and interpretation.
- Ability to work in a fast-paced evolving environment.
- High level of accuracy accountability and ownership.
- Ability to think analytically and contribute to results-oriented solutions.
- Experience or exposure to the financial services or fintech industry is an advantage.
Required Experience:
IC
Business Intelligence and ReportingDesign develop and maintain interactive dashboards and reports using Power BI to support operational management and executive decision-making.Build efficient and scalable data models applying best practices such as star schema design and performance optimization.De...
Business Intelligence and Reporting
- Design develop and maintain interactive dashboards and reports using Power BI to support operational management and executive decision-making.
- Build efficient and scalable data models applying best practices such as star schema design and performance optimization.
- Develop and maintain DAX measures for KPIs trends time intelligence and performance monitoring.
- Ensure dashboards are intuitive user-friendly and aligned with business requirements and objectives.
Data Extraction Transformation and Analysis
- Write optimize and maintain SQL queries to extract transform and analyze data from multiple source systems.
- Conduct quantitative analysis including trend analysis variance analysis and time-series analysis.
- Support ad-hoc analysis and deep dives to address business questions and management requests.
Data Quality Governance and Compliance
- Ensure the accuracy consistency and integrity of reported data across all dashboards and reports.
- Validate data to ensure it is auditable and third-party verifiable
- Align reporting outputs with internal standards and external reporting or regulatory frameworks.
- Maintain clear documentation for datasets KPIs and reporting logic.
Automation and Continuous Improvement
- Support automated and scheduled reporting workflows to improve efficiency and accessibility of insights.
- Identify opportunities to optimize BI processes dashboards and SQL queries for performance and scalability.
- Contribute to the continuous improvement of analytics standards tools and best practices.
Collaboration and Stakeholder Engagement
- Work closely with the Lead Business Analytics to support enterprise BI initiatives and analytics automation.
- Collaborate with cross-functional teams (I.T. Operations Finance Product Audit and Risk) to translate business requirements into analytics solutions.
- Communicate insights clearly and effectively to both technical and non-technical stakeholders.
- Bachelors degree in business Analytics Data Science Computer Science Engineering Economics Statistics Mathematics or a related field.
- Certifications in Power BI or other BI tools are an added advantage.
- 23 years of experience in Business Intelligence Data Analytics or a related role.
- Experience working in banking fintech lending or regulated data environments is an advantage.
- Strong hands-on experience with Power BI including:
o DAX (measures calculated columns time intelligence)
o Data modeling and performance optimization
o Dashboard design and data storytelling
- Strong SQL skills for querying transforming and analyzing data.
- Experience working with large multi-source datasets.
Soft Skills:
- Strong analytical and problem-solving skills.
- Excellent communication skills with the ability to explain insights clearly.
- Strong attention to detail and organisational skills
- Ability to manage multiple tasks and priorities effectively.
- Collaborative team player with a proactive and professional attitude.
Person Specification
- Strong understanding of data analysis and interpretation.
- Ability to work in a fast-paced evolving environment.
- High level of accuracy accountability and ownership.
- Ability to think analytically and contribute to results-oriented solutions.
- Experience or exposure to the financial services or fintech industry is an advantage.
Required Experience:
IC
View more
View less