James Adema
Data Engineer | Data Analyst | BI Developer
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
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
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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
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 MoreData 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 MoreDatabase 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 MoreCertifications & Awards
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