Visualization: Data Studio, Tableau and Power BI
Daniel Lule
Performance Marketing, Data Engineering And Anaytics
Nairobi,Kenya
Summary
Business and Data Analyst with 2+ years of experience across the advertising and marketing ecosystem with experience in digital media planning and buying, performance and growth, and conversion tracking. Known for using data analytics tools to offer value for money through data-driven decision making.
Overview
7
7
years of professional experience
4
4
years of post-secondary education
2
2
Languages
Work History
Digital Performance Marketing
Brand Design and Development
Nairobi, Nairobi City
05.2022 - Current
- Developed Digital Media strategies for clients to offer ROAS based on the overall business objectives and goals.
- Implemented conversion tracking from both the Ad platforms and the conversion points to attributed traffic to the Ads run on different platforms.
- Setup campaigns and managed third party ad partners to ensure tracking, execution and reporting are as expected and within timelines.
- Align client goals and internal business goals to create a win-win matrix for both.
- Manage data flowing from ad platforms to power our visualization tools which include Data studio, Reporting and Agency Analytics using Supermetrics as the data pipeline.
- With the experience above, the sales of one of our clients have increased by between 45% -70% per month in 2022 compared to the same periods in 2021.
Cloud Practioner
Alternative Ad Agency
Nairobi, Nairobi
07.2020 - 04.2022
- Recommended design changes to production systems in response to changing business process, capacity, risks and performance requirements.
- Collaborated with development and operations teams to develop practical automation solutions and custom modules.
- Researched and understood emerging technologies and end-user needs.
- Provided solution designs to meet system strategies, capabilities and technologies and to respond to current and future business requirements.
- Managed and monitored installed systems for highest level of availability.
- Managed installation, upgrade and deployment projects and provided on-site assistance for network engineers.
- Managed use of various types of databases and configured, installed and upgraded new ones.
Junior Data Engineer & Analyst
Alternative Ad Agency
Nairobi, Nairobi
09.2020 - 04.2022
- Researched and resolved issues regarding integrity of data flow into databases.
- Updated organizational systems and subsystems to improve and streamline data collection.
- Created and improved intelligence resources to facilitate consistent data management strategies.
- Compiled, evaluated and reviewed engineered data for internal system.
- Documented business workflows for stakeholder review.
- Participated in requirements meetings and data mapping sessions to understand business needs.
- Developed tables, views and materialized views using SQL.
- Synthesized current business data to produce reports and presentations, highlighting findings and recommending changes.
- Produced monthly reports using advanced Excel spreadsheet functions and Google Data Studio.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Coordinated statistical data analysis, design and information flow.
- Designed and developed schema data models.
Digital Media Planner and Manager
Alternative Ad Agency
Nairobi, Nairobi
02.2020 - 04.2022
- Incorporated media database technologies such as tagging, tracking and ad service metrics into media planning efforts.
- Developed integrated campaign strategies, incorporating media outreach initiatives across multiple verticals to create unified branding.
- Collaborated with account and content managers on development of social media outreach content.
- Prepared performance analysis reports on media properties, presenting findings to clients.
- Researched and developed media buying plans, prioritizing cost-effective content with maximum impact.
- Planned and acquired media for multiple digital channels.
- Designed overall media campaign objectives, defining project goals and outlining possible limitations.
- Identified and monitored KPIs for new and existing digital media properties.
- Helped clients develop website portals and social media pages to promote businesses.
- Collected and analyzed Web metrics such as visits, time on site and page views per visit.
- Maximized strategic approaches by keeping close eye on performance and making appropriate adjustments.
- Produced and submitted weekly reports outlining progress against KPI objectives.
- Identified appropriate KPIs and reported key metrics from digital campaigns.
- Maintained continuous check on ROAS, Ad spaces bidding prices and conversion metrics, optimizing and enhancing campaigns based on current trend data. This saw increased client revenue by 3% quarterly.
- Incorporated media database technologies such as tagging, tracking and ad service metrics into media planning efforts
Web Development Intern
Alternative Ad Agency
Nairobi, Nairobi
05.2019 - 12.2019
- Developed user interfaces with modern JavaScript frameworks, HTML5 and CSS3.
- Troubleshot and debugged code ensuring compatibility with devices, browsers, and operating systems.
- Designed and implemented web components across new and existing designs.
- Participated in project development through entire Software Development Lifecycle (SDLC).
- Collaborated with project managers, testers, end-users, and distributors.
- Studied user requirements and implemented requirements into solutions.
- Worked on eCommerce maintenance and management for client websites.
- Maintained website analysis spreadsheet by monitoring activity.
- Maintained quality assurance through code testing and cross-browser testing.
- Developed code collaboratively with Agile squads.
- Investigated and resolved application issues for web-based programs providing end-user support.
- Mastered emerging technologies to offer technical direction and creative solutions.
- Utilized scripting languages, content creation tools, management tools, and digital media to design web sites.
- Supported web applications and web sites through database development.
- Researched and developed new technology designs.
- Adhered to best practices for software development methodology and web security.
- Attended corporate learning and development programs to gain competencies and professional skills.
- Collaborated with product managers, testers, and developers to initiate process improvements.
- Analyzed, prioritized and problem-solved several tasks concurrently with minimum supervision.
- Studied basic project requirements with assigned technical lead and planned development strategies.
Education
Bachelor of Science - Computer Science
Multimedia University of Kenya
Nairobi 09.2017 - 12.2021
Skills
Data Engineering and Analysis
Intermediate Python
JavaScript experience
Project Management
SQL Scripting for Data Definition, Data Query, Data Manipulation and Data Control operations
Proficient in Facebook Business Suite, Twitter Ads, Google Ads, Google Analytics and DSP Partnerships
Bash Scripting for development and file management
Software
Tracking: Facebook Pixel, Twitter and Google Ads conversion tracking All these managed in GTM
Google Univeral Analytics and Google Analytics 4
Segment and DV360
Jupyter Notebook for offline python scripting
Excel for data analytics and pre processing
Google Colab for python scripting
Amazon Web Services for cloud services
Github for code management and versioning
Databases: Ms SQL Server, Postgres and MySQL
JavaScript
Interests
Artificial Intelligence
Data and its Ecosystem
Blockchain
Software Solutions
Marketing and Advertising
Timeline
Digital Performance Marketing
Brand Design and Development
05.2022 - Current
Junior Data Engineer & Analyst
Alternative Ad Agency
09.2020 - 04.2022
Cloud Practioner
Alternative Ad Agency
07.2020 - 04.2022
Digital Media Planner and Manager
Alternative Ad Agency
02.2020 - 04.2022
Web Development Intern
Alternative Ad Agency
05.2019 - 12.2019
Bachelor of Science - Computer Science
Multimedia University of Kenya
09.2017 - 12.2021