Erick Atura
Senior Business Intelligence Analyst
Based in Kenya
About
I’m Erick Nyamwaya Atura, a Senior Data Analyst and BI Specialist with 7+ years of experience turning complex data into actionable business insights. I design scalable BI solutions and intuitive dashboards using Looker Studio, and Tableau, powered by SQL, Python, and BigQuery. My work—spanning healthcare, e-commerce, and more—focuses on user-centric analytics that drive real impact, like reducing reporting from days to real-time and recovering $50K in claims. Certified by Google, Tableau, and DataCamp, I’m passionate about data storytelling, mentorship, and building data-driven cultures. Let’s connect to solve tough analytics challenges together.
Skills
Projects
Experience
2018 - 2022
Data Analyst at TMC
- Retrieve and collect patient records, medical histories, treatment details, and other relevant healthcare data from the hospital's server systems. - Perform data cleaning and preprocessing tasks on insurance payable data to identify and rectify inconsistencies, errors, and missing values. - Conduct reconciliation processes to match insurance payable records with patient billing information, claims submissions, and insurance policy details. - Analyze insurance payable data to identify trends, patterns, and anomalies in reimbursement claims, denials, and payments. -Present reports to relevant stakeholders, including hospital administrators, finance departments, and insurance providers.
2022 - Date
Freelance Data Analyst
- Engage in consultations with clients to understand their business objectives, data challenges, and analytical requirements. - Collect data from multiple sources, including databases, APIs, spreadsheets, and other data repositories, relevant to the client's project. - Perform exploratory data analysis (EDA) to gain insights into the structure, patterns, and relationships within the data -Develop predictive models, regression analyses, and forecasting techniques to anticipate future trends, customer behavior, and business outcomes - Create compelling data visualizations, interactive dashboards, and customized reports to communicate findings, trends, and insights effectively. - Cultivate strong client relationships through effective communication, responsiveness, and proactive engagement.
Education
2023
Data Analytics at Coursera
I completed a comprehensive data analytics course on Coursera, where I honed my skills in extracting actionable insights from complex datasets. Through hands-on projects and practical exercises, I gained expertise in data cleaning, visualization, and statistical analysis techniques. Utilizing Python, SQL, and data visualization tools, I learned to interpret trends, identify patterns, and make data-driven recommendations. This course equipped me with the knowledge and proficiency to tackle real-world data challenges, contributing to informed decision-making and business success. I am eager to leverage my expertise in data analytics to drive impactful solutions and add value to diverse projects and organizations.
2023
Data Preprocessing in Great Learning
In data preprocessing at Great Learning, I meticulously prepared raw datasets for analysis and modeling by employing a series of essential techniques. This involved handling missing values, removing duplicates, and addressing outliers to ensure data integrity. I standardized data formats, scaled features, and encoded categorical variables to facilitate effective analysis. Furthermore, I performed exploratory data analysis (EDA) to gain insights into data distributions and relationships. By employing techniques such as normalization and feature engineering, I optimized datasets for machine learning algorithms. Through comprehensive data preprocessing, I enhanced the quality, consistency, and suitability of datasets for subsequent analysis and modeling endeavors.
2021
Tableau Desktop Specialist
The Tableau Desktop Specialist certification course equipped me with foundational skills to harness Tableau’s powerful data visualization capabilities. Through hands-on training, I mastered creating interactive dashboards, connecting to diverse data sources, and transforming raw data into compelling visual insights. The course covered essential techniques like data preparation, calculated fields, and basic analytics, enabling me to design reports that drive decision-making. This certification validated my ability to efficiently navigate Tableau’s interface, build impactful visualizations, and communicate data stories clearly—skills I apply to deliver actionable results in my data analysis projects.
2024
Looker Studio Certification
The Looker Studio Certification course empowered me with the skills to leverage Google’s Looker Studio for dynamic data visualization and reporting. Through practical exercises, I learned to connect diverse data sources, design interactive dashboards, and craft visually engaging insights tailored to stakeholder needs. The training focused on data blending, custom metrics, and intuitive report-building, enhancing my ability to transform complex datasets into clear, actionable narratives. This certification sharpened my expertise in delivering real-time, impactful visualizations, a skill I utilize to drive informed decision-making in my data analysis projects.
2022
Data Analyst in SQL by DataCamp
The Data Analyst in SQL certification course from DataCamp strengthened my ability to extract and analyze data using SQL, a cornerstone of data-driven insights. Through interactive lessons, I mastered querying databases, joining tables, and aggregating data to uncover meaningful patterns. The training emphasized practical skills like filtering, sorting, and writing efficient SQL code to solve real-world problems. This certification enhanced my proficiency in manipulating large datasets and translating technical results into actionable findings, a capability I leverage to deliver precise, impactful analysis in my data projects.
2024
SQL Associate by DataCamp
The SQL Associate certification from DataCamp advanced my expertise in using SQL within the ecosystem to drive data analysis. Through focused training, I honed skills in writing complex queries, optimizing data extraction, and integrating SQL with Tableau’s visualization tools. The course covered advanced techniques like subqueries, joins, and data manipulation, enabling me to streamline workflows and uncover deeper insights. This certification solidified my ability to bridge raw data and visual storytelling, a skill I apply to deliver precise, impactful solutions in my analytical projects.