John Petit
@johnpetit
Data Analyst translating messy data into dashboards and SQL insights for clear business decisions.
KenyaWhat I'm looking for
I turn raw numbers into business actions from Nairobi, and I like analytics that non-technical teams can actually use. I build interactive dashboards in Tableau and PowerBI, then back them with SQL queries and clear documentation.
At Adanian Labs, I extracted and analyzed production data with SQL to identify trends and inform model performance decisions. I built dashboards for KPIs and model evaluation metrics for cross-functional stakeholders, and cleaned/transformed raw datasets to keep data quality consistent.
As a freelance data analyst, I worked with large-scale network traffic data using SQL and Python, and built data pipelines from AWS logs into structured datasets. I also developed risk-scoring models from structured vulnerability data, and wrote data-driven intelligence reports to support policy decisions.
Before that, I did backend and security work—designing database schemas for analytical performance, integrating analytics into CI/CD workflows, and analyzing security incident logs. That history keeps my analytics grounded in data pipelines, statistical rigor, and the practical context stakeholders need.
Experience
Work history, roles, and key accomplishments
Extracted and analyzed production data using SQL to identify trends and inform model performance decisions.
Built dashboards to visualize KPIs and model evaluation metrics for cross-functional stakeholders.
Cleaned and transformed raw datasets for downstream analysis, ensuring data quality and consistency.
Collaborated with product teams to translate analytical findings into actionable business
Analyzed large-scale network traffic data using SQL and Python, identifying anomalies that improved threat detection accuracy by 35%.
Built data pipelines transforming raw log data from AWS services into structured datasets for reporting and analysis.
Developed risk-scoring models using structured vulnerability data, prioritizing remediation efforts and improving system resilience by 30%.
Creat
Analyzed security incident logs to extract patterns and features, informing predictive defense mechanisms.
Built data pipelines integrating analytics into CI/CD workflows with feedback loops for continuous improvement.
Engineered data architectures with quality controls that increased data integrity by 20%.
Communicated technical findings to non-technical stakeholders, translating analysis into
Designed and optimized relational database schemas for analytical query performance and data integrity
Built data pipelines using Python to ingest, process, and integrate data from multiple sources
Implemented testing protocols ensuring data quality and service reliability across backend systems
Analyzed user behavior and market data to drive product strategy, contributing to 20% increase in user acquisition.
Conducted A/B testing and built personalization infrastructure for data-driven feature development.
Translated quantitative and qualitative insights into business cases for stakeholders.
Refined matching algorithm using preference and feedback data, improving user satisfaction by
Applied rigorous analytical methodologies to identify, classify, and match patterns in complex forensic evidence (ballistics, documents, digital media), developing early expertise in pattern recognition and feature extraction.
Performed feature extraction from physical and digital evidence to build comprehensive analytical reports, gaining foundational skills in structured data analysis and clas
Education
Degrees, certifications, and relevant coursework
Kenyatta University
Bachelor's degree, Forensic Science
Frontier Technology Institute
Introduction to Quantum Computing
2022 - 2023
Tech stack
Software and tools used professionally
Availability
Location
KenyaAuthorized to work in
Social media
Job categories
Skills
Interested in hiring John?
You can contact John and 90k+ other talented remote workers on Himalayas.
Message JohnGet matched with your dream remote job
Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!
