Learn Data Skills
Nigel Amaya

Nigel Amaya


Business Intelligence Analyst

Dynasoft Business Solutions Limited | Nairobi, Kenya


My Portfolio Highlights

My New Course

Introduction to Python

My New Track

Associate Data Analyst in SQL (previously Data Analyst in SQL)

Insights conductor, orchestrating a symphony of knowledge from data streams.

My Work

Take a look at my latest work.


Competition - Supply Chain Analytics


Using Joins to Analyze Book Sales in SQL


Course notes: Data Manipulation with pandas


Project: Analyzing Students' Mental Health

My Certifications

These are the industry credentials that I’ve earned.

SQL Associate

SQL Associate

Other Certificates

Microsoft Microsoft Certified: Azure Fundamentals

Microsoft Microsoft Azure Data Fundamentals

Microsoft Microsoft 365 Fundamentals

Microsoft Microsoft Dynamics 365 Fundamentals

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Kisumu Water and Sanitation Company Limited | Feb 2024 - Present

Business Intelligence Analyst


Dynasoft Business Solutions Limited | Mar 2020 - Jul 2023

Business Intelligence Analyst

• Managed database systems to ensure storage optimization, implemented compression techniques, maintained high availability, enforced security measures, and controlled data access. • Collected and cleaned data from various sources, ensuring accuracy and completeness. • Implemented data quality checks and assurance processes to maintain data accuracy and consistency. • Performed in-depth data analysis to identify trends, patterns, and anomalies. • Utilized SQL for custom data queries, transformations, and business logic within the database. • Ensured data quality through validation procedures. • Building and deploying BI solutions using Microsoft Power BI. • Created visually appealing reports and dashboards using Power BI. • Created and maintained comprehensive technical documentation for database systems and analytical applications. • Performed in-depth data analysis to identify trends, patterns, and anomalies. • Collaborated with system implementers to enhance deployed ERP systems.
Show More

Kenya Medical Research Institute | Mar 2019 - Mar 2020

Data Officer

Supported statistical analysis of stored data to assist customized report generation. • Provided informational resources regarding data-related access, storage, and security issues. • Conducted quality assurance, quality control and protocol validations to maintain efficiency. • Played a role in data architecture and design, including schema creation and evolution. • Led database management, development and analysis to meet organizational goals for information integrity. • Controlled users and access levels for each segment of given database. • Worked with project teams to coordinate the development of each database based on the established scope and limitations.

Jaramogi Teaching and Referral Hospital | Dec 2018 - Mar 2019

ICT/Data Intern

Devised customized hospital data report formulas and delivered reports to management as specified. • Performed data analysis, cross-referencing and consolidation. • Created standard queries, verified data quality and pinpointed inconsistencies and missing data. • Documented complex procedures deployed in data management. • Collaborated with staff and vendors to contribute to documentation of data, metadata and systems architecture. • Trained users and junior support staff in proper use of hardware and software. • Set up equipment based on staff needs and IT capabilities. • Participated in data quality checks and assurance procedures to maintain data accuracy. • Supported non-technical users by quickly investigating and resolving hardware and software issues

My Education

Take a look at my formal education

Bachelors of Business Information Technology in Information TechnologyJomo Kenyatta University of Agriculture and Technology | 2018

About Me

Nigel Amaya

I have honed my skills using a diverse set of tools including Python, SQL, Excel, and Power BI. My journey in the world of data doesn't stop there; I'm currently exploring the exciting realm of Data Engineering.

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free