## James Adema

Data Engineer | Data Analyst | BI Developer

View Resume Hire Me

## About Me

I am a proactive and solution-oriented Business Intelligence and Data Engineer with over 7 years of experience in designing and optimizing data pipelines, building scalable data systems, and integrating complex datasets. My expertise lies in ETL development, cloud platforms (Azure, AWS, GCP), and creating efficient data warehouse architectures that enable actionable insights and data-driven decisions.

I have a strong track record of leading and mentoring BI and Data Engineering teams, designing end-to-end solutions, and improving business operations through data optimization. I excel in tools like Azure Synapse Analytics, Databricks, Apache Spark, Power BI, and SQL optimization, ensuring high-performance data workflows.

I thrive in challenging environments, continuously adopting new technologies to drive efficiency and innovation. Let's collaborate to turn data into actionable insights and unlock the full potential of your business!

## Bio

Email
ademajames@gmail.com
Phone
+254 703 693 081
Address
Nairobi, Kenya

## Professional Skills

Cloud Platforms and Services:

- Microsoft Azure
- Amazon Web Services (AWS)
- Google Cloud Platform (GCP)
- Azure Synapse Analytics, Azure Data Lake, Azure Data Factory, Azure Databricks

Data Engineering and Analytics:

- Data Warehousing (Cloud and On-premises)
- ETL Processes (SSIS, Oracle ODI, Python, Azure Data Factory, Synapse, Apache NIFI)
- Data Mart and Cube Development
- Apache Hadoop, Apache Spark, Apache Hive, Presto
- Performance Tuning and Optimization (SQL, Azure Data Lake, Synapse Pipelines)

Databases and Storage:

- Oracle, DynamoDB, MySQL, SQL Server
- Database Management and Administration
- Parquet, Data Lake Storage Solutions
- Database Architecture and Design

Data Visualization and Reporting:

- Power BI, Tableau, SSRS (SQL Server Reporting Services)
- Zoho Analytics, Google Analytics, QlikView

Programming Languages:

- Python (Data Engineering, Automation, ETL Development)
- PHP
- Java

## Work Experience

Data Engineer at Jubilee Insurance
September, 2025 – Present
• Designed and deployed scalable data pipelines on Microsoft Azure (Synapse, Data Lake, Data Factory) to support IFRS 17 reporting.
• Partnered with actuarial, finance, and IT teams to define requirements, resolve integration challenges, and deliver compliant datasets on time.
• Developed data mappings, transformation rules, and models aligned with IFRS 17 methodologies for Health and Life insurance portfolios.
• Implemented data validation, reconciliation processes, and governance frameworks to ensure accuracy and consistency.
• Automated ETL workflows using Python and SQL, optimizing Azure Synapse performance through indexing and partitioning.
• Ensured compliance with regulatory, audit, and Azure cloud security standards, maintaining detailed documentation of all data flows.
• Acted as an Azure SME, mentoring team members and driving continuous improvement in data engineering practices.
Technical Lead & Lead Data Engineer at Pathways Technologies
May, 2022 - August 2025
• Led the investigation and resolution of critical system issues, reducing downtime and enhancing system reliability.
• Evaluated and integrated emerging technologies to address evolving business needs and improve operational efficiency.
• Directed a cross-functional BI team, delivering enterprise applications from concept to completion.
• Managed the architecture, design, and implementation of company-wide platforms and applications.
• Mentored junior engineers and provided ongoing support for professional development.
• Advised management and cross-functional teams on technology solutions, optimizing business operations.
Lead Trainer & Business Intelligence Consultant at Pathways International
May, 2020 - May 2022
• Maintained training data and performance tracking using Power BI reports for over 5000 users.
• Monitored and optimized Cube server performance to ensure smooth access for large-scale users.
• Designed training aids, computer tutorials, and reference materials for effective classroom and virtual instruction.
• Facilitated learning through in-person classroom instruction, on-the-job coaching, and virtual training sessions for 40 employees.
• Collaborated with 3 managers to brainstorm and implement improvements to enhance training effectiveness.
• Directed the implementation of new BI tools, selecting appropriate solutions and supporting onboarding processes.
• Drafted a strategic business intelligence roadmap, incorporating data governance policies and safeguards.
• Created customized data collection models for specific data visualization needs.
• Generated both standard and custom reports to provide actionable insights into business performance and trends.
Junior Business Intelligence Consultant at Pathways International
May, 2019 – May, 2020
• Managed business data systematically, ensuring ease of understanding and accessibility.
• Guided clients on selecting appropriate BI tools and streamlining business workflows.
• Analyzed and compiled data, extracting valuable information for decision-making.
• Customized BI solutions to meet specific client requirements, improving customer satisfaction.
• Managed end-to-end project lifecycles, from initial concept to successful implementation.
• Presented insights and strategic recommendations to senior management, influencing business decisions.
• Demonstrated creativity and initiative when tackling complex BI-related challenges.
Intern: Business Intelligence Consultant at Pathways International
June, 2018 – April, 2019
• Worked under senior and junior BI consultants, assisting with simple reporting and database management tasks.
• Conducted research on the latest trends in Business Intelligence, BI tools, and ETL processes.
• Assisted in preparing test environments for junior consultants, ensuring smooth workflows.
• Quickly learned and adapted to new BI tools, demonstrating a high level of initiative and technical adaptability.
• Collaborated with senior staff in the development of marketing materials to improve brand visibility and engagement.
Content Moderator at Ma3route
Jan, 2016 – May, 2018
• Monitored, reviewed, and approved user-generated messages to ensure compliance with platform guidelines.
• Curated and moderated content to provide accurate, relevant, and timely transport and traffic updates to users.
• Collaborated with the operations team to maintain a seamless flow of information on mobile, web, and SMS platforms.
• Enhanced user experience by ensuring quality control of messages and efficient response times.
• Played a critical role in fostering an interactive and reliable community for transport and traffic information sharing.
Intern: IT Support at Mumias Sugar Company
October, 2014 – December, 2014
• Diagnostics of hardware errors, maintenance, and repair of systems in the offices.
• Monitoring, diagnostics, maintenance, and repair of networks.
• Installation, configuration, and maintenance of wired and wireless LAN printers.
• Analyzing computer software and hardware concerns.
• Setting up both wired and wireless Local Area Network.

## Education

Master of Data Science
The Open University of Kenya, Expected 2027
Bachelor of Science In Information Technology
Mount Kenya University, Nairobi, 2024
Diploma in Technology: Computer System Engineering
Technical University of Kenya, Nairobi, 2015
Kenya Certificate Of Secondary Education
Eluche Secondary School, Kakamega, 2010
Kenya Certificate Of Primary Education
Mumias Complex Primary School, Kakamega, 2006

## Portfolio

Microsoft Azure / Synapse / Azure Cost Optimization / Power BI Reporting

### Jubilee Insurance, Kenya Uganda & Tanzania

In 2024, I led a team of data engineers to develop high-performance data pipelines on Azure Synapse, optimizing data flow and reducing costs by 60%. I designed a reusable ETL framework, enhanced the data warehouse by integrating diverse sources, and ensured smooth operations by quickly resolving system issues. Additionally, I documented scalable data architecture and managed reports across teams in three countries.

See More

Data warehouse / SQL / SSIS ETL / Power BI Reporting / Unit4 ERP

### CIFOR-ICRAF NGO, Kenya & Indonesia

As the Lead Data Engineer and Data Architect, I was responsible for designing and implementing an ETL solution that extracted data from the ERP system (Unit4) and loaded it into a centralized data warehouse. This architecture facilitated the seamless integration of organizational data, which was used to generate insightful reports. These reports provided actionable insights accessible to the entire staff, empowering decision-making at all levels. By optimizing data flow and ensuring data accuracy, the solution significantly improved operational efficiency and enhanced data-driven strategies across the organization.

See More

SQL & SSIS Optimization / Data Modeling / Indexing & Partitioning / Resource Utilization Optimization

### ABSA ETL Training, Kenya

I led a training session with Absa Bank's Data Engineering team, covering key topics like optimizing SQL queries, SSIS workflows, and Hadoop server management. We focused on reducing resource utilization, automating ETL jobs, improving ETL efficiency, and best practices for managing partitions, indexes, and execution plans. The session provided valuable insights for enhancing data processing and improving overall performance.

See More

Tableau Automation / Data Warehouse Design / ETL Development

### Mwalimu SACCO, Kenya

Mwalimu National is the largest African SACCO with a membership drawn from teachers all over Kenya. I was part of the team that automated their reporting in Tableau, connecting to their NAV database, designing a data warehouse, creating ETL pipelines, and delivering real-time dashboards. This project significantly reduced manual reporting efforts and empowered the SACCO with actionable insights.

See More

Database Management / Report Development / Data Cleanup

### ResponsePoint, United States

I collaborated with ResponsePoint to manage their database for Regal Cinemas and deliver powerful business insights through dashboards and reports using Power BI, SSRS, and Tableau. My responsibilities included data cleanup, analytics, and automating ETL workflows, providing a seamless experience for running promotional campaigns.

See More

ETL Development / Azure Workspace Setup / Power BI Dashboards

### BEI SAWA Supermarkets, Kenya

BEI SAWA Supermarkets leveraged data from daily sales to predict reorder levels of products in their stores. I designed and implemented an ETL solution to load data into a staging environment, built Power BI dashboards, and provided analytical insights to help the client optimize inventory management and forecast financial performance.

See More

## Certifications & Awards

### Microsoft Certified: Azure Data Fundamentals

Microsoft - Issued November 2021

Credential Link

### Microsoft Power BI Training Award

Pathways International - Issued August 2022

Award Link

## Referee

### Kennedy Kwambai

Business Intelligence Manager

Onafriq

Phone Number:+254 715 755126
Email: Kennedy.kwambai@onafriq.com

### Ann Mburu

BI Reporting Manager

MSI Reproductive Choices UK

Phone Number: +254 702 625036
Email: ann.waithera@msichoices.org

### Stephen Barry

Solution Developer (Business Intelligence)

Save the Children International, Nairobi, Kenya

Phone Number: +254 712 933497
Email: barry.okwaro@savethechildren.org