Senior Data Analyst & BI Lead with 7+ Years Experience

BRENDA AKINYI OONGO

***********@*****.*** +254-***-******/ +254-***-******

PROFESSIONAL SUMMARY

Senior Data Analyst and BI Lead with 7+ years of experience designing, supporting, and scaling enterprise BI platforms, ETL pipelines, and data warehouse environments across regulated organizations. Proven ability to automate data ingestion, troubleshoot complex data systems, optimize SQL driven platforms, and translate business requirements into reliable front end, middle tier, and back-end analytics solutions in financial services.

EDUCATION

• Masters of Science (Strategic Management) 2023- 2026 Jomo Kenyatta University of Agriculture and Technology

• Bachelor of Science (Statistics) 2014 - 2018

Jomo Kenyatta University of Agriculture and Technology SKILLS

• Programming & Scripting: Python (Pandas, NumPy, Scikit-learn, Matplotlib, Seaborn), R, SQL, DAX

• Machine Learning & Analytics: Predictive Modeling, Clustering, Classification, Regression, Time Series Analysis, Churn Prediction, Credit Scoring, A/B Testing, Customer Segmentation

• Data Visualization & BI Tools: Power BI, Looker, Tableau, Excel (Pivot Tables, Power Query), Matplotlib, Seaborn

• Version Control & Collaboration: GitHub, JIRA, Confluence, Agile/Scrum

• Stakeholder communication: Translate business requirements into clear technical solutions and explain data issues to non-technical teams.

• Problem solving: Perform root cause analysis on data and platform incidents and implement fixes that prevent repeat failures.

WORK EXPERIENCE

Team Lead Data Analyst. January 2025 – Date

I&M Bank

Responsibilities.

• Lead design, coding, and support of ETL and analytics processes across the BI ecosystem.

• Develop and support reliable data ingestion and preparation pipelines using SSIS, SQL, and Python.

• Manage front-end BI tools, middle-tier semantic models, and back-end data warehouse components.

• Perform root cause analysis for data and application incidents, ensuring fast resolution and platform stability.

• Automate BI processes to enable proactive monitoring and reduce manual intervention.

• Support platform upgrades across BI front end, ETL layers, and database tiers.

• Partner with IT teams on performance tuning, access control, and data governance.

• Translate business requirements into scalable data models and reporting solutions.

• Mentor analysts and enforce engineering and BI development standards. Key Results

• Reduced manual reporting effort by 40 percent through ETL automation.

• Improved data accuracy by 30 percent through validation and quality controls.

• Enabled executive level performance tracking through standardized BI dashboards. Data Analyst and Data Scientist April 2022 – December 2024 I&M Bank.

Responsibilities.

• Designed and supported enterprise MIS and BI reporting frameworks.

• Built and maintained ETL workflows for structured banking data sources.

• Developed SQL optimized datasets for analytics and reporting consumption.

• Supported production BI issues and performed data level troubleshooting.

• Built predictive models integrated into reporting pipelines for decision support.

• Collaborated with Risk, Marketing, and Product teams to define data requirements.

• Automated reporting pipelines and improved delivery turnaround by 40 percent.

• Delivered customer segmentation and credit scoring solutions used by business teams. Data Analyst. September 2019 – December 2021

Kenya National Highways Authority

Responsibilities

• Supported large scale data collection and analysis for national infrastructure projects.

• Designed dashboards for compliance monitoring and operational reporting.

• Conducted data quality reviews and audit support analysis.

• Presented analytical findings to technical and non-technical stakeholders. Monitoring & Evaluation Intern. June 2019 – August 2019 AMREF Kenya

Responsibilities

• Supported analytics and reporting for healthcare programs.

• Assisted in data preparation, analysis, and visualization. LEADERSHIP AND KNOWLEDGE SHARING.

• Lead BI training and self-service analytics enablement

• Participate in internal technical forums and cross-functional design reviews

• Drive continuous improvement in data platforms and analytics services

Contact this candidate