I am a forward-thinking professional with a passion for leveraging data-driven insights to drive transformative change for individuals and organizations. Throughout my career, I have demonstrated proficiency in devising and implementing innovative solutions aimed at enhancing operational efficiency and fostering growth.My diverse portfolio spans a spectrum of disciplines, ranging from pioneering Data Engineering initiatives and illuminating Business Intelligence strategies, to orchestrating Robotic Process Automation endeavors and architecting robust Data Warehousing solutions. Additionally, I have ventured into the realms of Software and Mobile development, consistently delivering impactful solutions tailored to specific business needs.My expertise has been cultivated through dynamic collaborations across various industries, including technology, finance, banking, health, insurance, education, and human resources. I thrive on the challenges inherent in data and software conundrums, continuously seeking inventive resolutions to drive tangible results.My academic background includes a BSc. degree in Computer Science from The University of Nairobi and a Google Cloud professional Data Engineer certification. Committed to staying at the forefront of industry trends, I actively explore the potential of emerging technologies such as Blockchain and Computer Vision, ensuring that my skill set remains relevant and adaptable to evolving market demands.I invite you to connect with me if you are interested in exploring innovative solutions to your data and software challenges. Together, we can unlock new opportunities for growth and success.Feel free to reach out to me to discuss potential collaborations or to learn more about my expertise and capabilities.My data stack includes an ensemble of powerful tools:- Python for versatile scripting- dbt for data transformation and management- Looker and Power BI for insightful visualization- Stitch, Fivetran for seamless data integration- Alteryx for advanced data analytics- SQL (Bigquery, MSSQL, Snowflake) as the bedrock of data manipulation- GCP and AWS for robust cloud infrastructure- MongoDB for agile NoSQL database management- ETL data pipelines to ensure smooth data flowIntrigued by the possibilities of merging your needs with the potential of data and software? Let's embark on a journey of innovation and problem-solving together. Let's chat
-
Senior Data EngineerUpworkNairobi County, Kenya
-
Senior Data EngineerIu Group Jun 2024 - Present -
Senior Data ConsultantFreelance Jan 2024 - May 2024- Advised clients on best practices for data architecture and data management.- Conducted needs assessments to understand client requirements and data challenges.- Developed customized strategies to improve data quality, accessibility, and analytics capabilities.- Integrated automated data sources, including structured and unstructured data, into cohesive data warehouses.
-
Analytics Team LeadAleno Jul 2021 - Dec 2023Zurich, SwitzerlandCompany profile: Software startup building tools for restaurant management- Led 5+ data initiatives and data management functions including financial reporting for investors, company all hands and strategic initiatives- Created and managed real-time and scheduled integrations of data ingestion to move data and change data capture events averaging to 5Million+ events per month from sources (Mongodb, Xero, Hubspot, Postgress, re:spondelligent) to Google Big Query- Created and… Show more Company profile: Software startup building tools for restaurant management- Led 5+ data initiatives and data management functions including financial reporting for investors, company all hands and strategic initiatives- Created and managed real-time and scheduled integrations of data ingestion to move data and change data capture events averaging to 5Million+ events per month from sources (Mongodb, Xero, Hubspot, Postgress, re:spondelligent) to Google Big Query- Created and maintained 6+ data transformation pipelines on dbt (batch and streaming pipelines)- Administered and Maintained Google cloud instance to ensure performance ,security and consistency.- Created and updated the organization-wide data model for reporting, automation and analytics on Looker (BI, APIs and Embeds)- Created reports for internal use and for 100+ hotel customers (general availability reporting and custom reports)- Ran data-driven experiments and proof of concepts using AI, GA4 and Mixpanel Show less -
Data EngineerSavings United Gmbh Mar 2021 - Oct 2022Hamburg, GermanyCompany profile: Startup as a coupon partner of media companies and advertisers.- Connected and maintained python ETL pipelines to get transaction and revenue data from 10+ of the largest global couponing affiliate networks APIs (Awin.com, cj.com, tradedoubler.com, tradetracker.com, rakuten.com, performancehorizon.com,groupon.com, ebay.com) hosted on Airflow- Created a automated monitoring and notification system doing log collection, aggregation, visualization from 3 inhouse and… Show more Company profile: Startup as a coupon partner of media companies and advertisers.- Connected and maintained python ETL pipelines to get transaction and revenue data from 10+ of the largest global couponing affiliate networks APIs (Awin.com, cj.com, tradedoubler.com, tradetracker.com, rakuten.com, performancehorizon.com,groupon.com, ebay.com) hosted on Airflow- Created a automated monitoring and notification system doing log collection, aggregation, visualization from 3 inhouse and purchased solutions using python- Automated reconciliations of invoices from manual files to transactions , previously done manually- Reviewed and updated the company-wide data model on Looker with data from APIs, Greenhouse, Emails, Website scrapes and Salesforce- Code review and peer testing of python and sql queries and procedures of data team of 5 (analysts + engineers)- Bug tracking and documentation of data pipelines and infrastructure Show less -
Data ConsultantFreelance May 2020 - Mar 2021RemoteSetting up and optimizing clients' data stacks by implementing these solutions remotely:- Creation and maintainance of data models on Lookml and SQL for operations, client demos and automated procedures- Machine-learning pipelines on python, bigqueryml, jupyter- Data engineering workflows on python, dbt, mssql, snowflake, alteryx , airflow - Robotic process automation solutions on python- Business intelligence solutions on Looker… Show more Setting up and optimizing clients' data stacks by implementing these solutions remotely:- Creation and maintainance of data models on Lookml and SQL for operations, client demos and automated procedures- Machine-learning pipelines on python, bigqueryml, jupyter- Data engineering workflows on python, dbt, mssql, snowflake, alteryx , airflow - Robotic process automation solutions on python- Business intelligence solutions on Looker, Tableau, PowerBI- Data warehouses design and implementation on MSSQL, Bigquery, Snowflake - Metadata management and data lineage solution- GDPR compliance audits and reviews- Training & Facilitation on GDPR, BI best practices and Data reconciliationSome clients I've worked for: Two Sigma (US), World Bank, HIAS International, RareKarma (US), Centerfield (US), GreenHouse Co. (UK), BetterWork (Haiti), Biolog-id (US), Liven (Australia), FYISoft (US), Omdena Show less
-
Data & Analytics CoordinatorAndela May 2019 - Apr 2020Nairobi County, KenyaCompany profile: Andela enables you to source, assess, hire, manage, and pay global technical talent from one unified platform.- Implemented the cross-departmental Andela Data & Analytics Strategy in 4 departments (Engineering Tech, Partner Engineering, People and Travel).- Created, Updated and Maintained data in the Google BigQuery data warehouse by performing data modelling for reporting using data from 7 operational systems using dbt on Airflow.- Built 10+ actively used… Show more Company profile: Andela enables you to source, assess, hire, manage, and pay global technical talent from one unified platform.- Implemented the cross-departmental Andela Data & Analytics Strategy in 4 departments (Engineering Tech, Partner Engineering, People and Travel).- Created, Updated and Maintained data in the Google BigQuery data warehouse by performing data modelling for reporting using data from 7 operational systems using dbt on Airflow.- Built 10+ actively used analytical dashboards on the Looker platform for use by various departments and leadership teams to make actionable data driven decisions.- Data warehouse resource usage monitoring, optimization and Query A/B testing- Stakeholder management by ensuring continuous support and collaboration to ensure KPIs are defined, monitored effectively and insights communicated in engineer delivery and engineer experience teams. Show less -
Data & Analytics AssociateKpmg East Africa Jan 2017 - May 2019Nairobi County, Kenya- Implemented automated analytical, monitoring and reporting programs for internal business functions such as IT and Finance using structured and unstructured data.- Conducted data analysis and reporting for Forensic investigations for organizations in sectors such as Education and Insurance.- Conducted trend analysis, prediction and visualization of big data from organizations in Insurance,HR,FMCG companies and Banking sectors for business advisory and process automation.- Did… Show more - Implemented automated analytical, monitoring and reporting programs for internal business functions such as IT and Finance using structured and unstructured data.- Conducted data analysis and reporting for Forensic investigations for organizations in sectors such as Education and Insurance.- Conducted trend analysis, prediction and visualization of big data from organizations in Insurance,HR,FMCG companies and Banking sectors for business advisory and process automation.- Did financial audits and compliance checks for various banks against Central Bank of Kenya reporting standards.- Undertook Extraction, Transformation and Load data procedures to support different assignments.- Trained auditors audit methodologies and use of Computer Audit Aided Tools eg. CaseWare IDEA Show less -
Brand Ambassador ProgrammeUber Sep 2016 - Mar 2017NairobiPeer marketed the brand using the Brand Ambassador programme -
Data & Analytics InternKpmg East Africa Jan 2016 - May 2016Nairobi- Did data Extraction,Analysis and Exception reporting for 5+ client data.- Trained auditors on Data Analysis using Caseware IDEA for 5+ clients.- Performed sales,installation, configuration and maintenance of Caseware IDEA tool for data Analysis.-Mobile Application design, development and testing for Proof of Concept.
-
Technical Support AssistantKenyaweb Ltd Jan 2015 - Jun 2015Nairobi,Kenya-Customer Support Service -Cisco router configuration-Internet installation, configuration and servicing.-Mail server and Domain Installation, Configuration and troubleshooting
Peter Wachira Skills
Peter Wachira Education Details
-
First Class Honours -
Emobilis Mobile Technology InstituteAndroid,Java,Php,Mysql
Frequently Asked Questions about Peter Wachira
What company does Peter Wachira work for?
Peter Wachira works for Upwork
What is Peter Wachira's role at the current company?
Peter Wachira's current role is Senior Data Engineer.
What schools did Peter Wachira attend?
Peter Wachira attended University Of Nairobi, Emobilis Mobile Technology Institute.
What skills is Peter Wachira known for?
Peter Wachira has skills like Html, Mysql, Java, Php, C, Android Development, C++, Networking, Tcp/ip, Software Development, Data Analysis, Network Administration.
Not the Peter Wachira you were looking for?
-
Peter Wachira
Co-Founder & Ceo @ Triply.Co (Ycw24) | 500 Startups | Travel-Tech | God FirstNairobi County, Kenya -
Peter Wachira
Banking | Finance | Relationship Management | Portfolio Monitoring | Risk Management |Consumer Lending |Customer Experience| Credit Remedial & Recoveries |Nairobi County, Kenya -
-
2sanlameastafrica.com, pinebridge.com
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial