Martin Wanjiru

Data Engineer

Deel

Nov 2023 - Current (2 years 8 months)

We use Snowflake, Airflow, dbt core, and Fivetran, At Deel, I; • Create, set up, and manage data pipelines that are both scalable and efficient. • Implement and enforce robust data governance policies and procedures such as PII anonymization to ensure the integrity, quality, and security of the organization's data assets. • Implement and maintain ELT processes to extract, load, and transform data from various sources into our data warehouse. • Identify and optimize complex models and queries for data analysis and reporting purposes. • Work with data analysts, data scientists, analytics engineers, and other stakeholders to understand their data needs and provide support in optimizing data workflows. • Build a development environment an

M

Data Engineer

Meta Platforms Inc

May 2022 - Nov 2023 (1 year 7 months)

• Partner with leadership, engineers, program managers and data scientists to understand data needs • Apply proven expertise and build high-performance scalable data warehouses • Design, build and launch efficient & reliable data pipelines to move and transform data (both large and small amounts) • Securely source external data from numerous partners • Intelligently design data models for optimal storage and retrieval • Deploy inclusive data quality checks to ensure high quality of data • Optimize existing pipelines and maintain of all domain-related data pipelines • Ownership of the end-to-end data engineering component of the solution • Design and develop new systems in partnership with software engineers to enable quick and easy

Data Engineer and BI

Apollo Agriculture

Oct 2020 - Feb 2022 (1 year 5 months)

financing, farm advice, when possible. At Apollo, I did; • Do data modeling, specifically dimensional modeling, creating facts and dimension tables that represent different business processes. • Provide clean, tested, documented, and transformed data. Data marts that summarized various business processes to allow more business users to be comfortable with SQL. • Building and maintaining reports and interactive dashboards in Tableau and Redash. • Version controlling, testing, and continuous integration of analytics code base inside dbt (data build tool) • Maintain data documentation & definitions on Confluence. • Monitor and maintain the ETL process. Updating the Stitch integration, debugging, and monitoring errors • Maintaining pytho

Data Analyst

Branch International

Jan 2020 - May 2020 (5 months)

Branch International is a US-based fintech offering loan products to Its customers through mobile its application available on android platform. I; • Produced daily, weekly and monthly reports and insights that were used directly to improve collections across all delinquency buckets • Continuously supported the servicing and collection manager in monitoring and evaluating the outsourced agencies performance • Used SQL to derive borrower data. • Used Sisense (formally Periscope) Data to build dashboards to monitor key business KPIs across departments. • Analyzed collection and repayment trends, produced solid reports that were used for decision making with strategic and useful insights. • Worked with departmental managers to outline th

S

Project-Based Data Analyst

Strategic Synergy Consultants

Jan 2019 - Jun 2019 (6 months)

Strategic synergy Consultants Is a tenderer who bids for tenders In government Institutions; tenders to conduct surveys and report on the findings. Depending on work availability, I; • Prepared online survey tools to be used for data collection • Did Data Cleaning and preparation for analysis • Did Data Analysis and presentation of results and findings to clients • Presented Data Analysis Findings to clients

Business Intelligence Developer

Kenya Revenue Authority

Dec 2018 - Dec 2019 (1 year 1 month)

Kenya Revenue Authority to oversee tax At KRA, I; • Collaborated in implementing dimensional modelling of the authority's data • Collected business requirement from business users and translated them to SQL • Collaborated efforts with colleagues to manage BI solutions • Created visualizations and dashboards from business data using OBIEE • Did Data Analysis and presentations at department executive level. • Did Trend and behavioral analysis on taxpayers

About

Detail

Timeline

Résumé