JAIR PIMENTEL
BI And Data Analysis
London
Summary
Highly ambitious data professional with experience in CX, product analysis, marketing, market research and finance. Expert in data analysis, reporting development and automation. Personable business professional bringing successful 18-year career in data roles within large and fast-paced corporations. Creative solutions architect with real-time problem-solving flexibility.
Overview
16
16
years of professional experience
6
6
years of post-secondary education
3
3
Languages
Work History
Marketing Data and BI Manager
G.Network
London
2022.01 - Current
- G.Netowrk is a telecom company building a fibre network across London and offers internet connection to residential and business customers
- As the first data specialist hire in the Sales & Marketing team, my role involves creation of data models using internal data (mainly Salesforce) and external data, the setup and implementation of Power BI dashboards, definition of KPIs, AB testing, and audience targeting.
- Performed analysis on future network build which changed the way G.Netork decides network expansion.
- Provided technical support for troubleshooting analytics and reporting issues
- Generated ad-hoc reports to evaluate specific business requirements
- Utilized data visualization techniques to present and explain complex data sets
- Incorporate competitor data into reports, for sales, infrastructure, and planning teams, which proved to be main factor to optimize sales and building network.
- Established Power BI dashboards for sales, product and marketing teams, to measure and make decision using data analysis.
BI Manager
emap
London
2021.02 - 2022.01
- Emap is publisher with more than 20 different publications mostly B2B
- As BI Manager, my main responsibilities were maintaining and improve the analytics data warehouse using a variety of tools (Analytics Canvas, Google BigQuery, python) and this includes creation of data models, ingest new data sources, create dashboards using Google DataStudio and manage several stakeholders.
- Implemented business intelligence solutions to increase operational efficiency
- Developed and maintained data warehouses and data marts to support business operations
- Collaborated with stakeholders to identify business needs and data sources
- Designed and developed data pipelines to acquire, clean and process data
Data Consultant
Motif Research
London
2020.11 - 2020.12
- Working as a contractor to streamline and automate processes for 9 different projects, using mainly Alteryx and SQL
- Data transfer from online surveys to internal database
- Sample process automation
- Process mapping documents.
CS Operations Data Analyst EMEA
JUUL Labs
London
2019.05 - 2020.06
- JUUL is an American company that produces and sells vape products around the world
- As the only Data Analyst for the whole EMEA region and reporting to the Analyst Manager in San Francisco, I was accountable for the creation and maintenance of Tableau dashboards and Salesforce reports, process design, data quality and automation, and ad-hoc analysis for the Customer Service team in EMEA using customer data from different sources (sales, omnichannel, CRM) to track KPIs and SLAs for internal and external stakeholders
- Subject matter expert, creating tracking systems to help organization manage KPI’s successfully
- Created a global Utilization report to monitor the customer experience and the efficiency of global call centers, which lead to outbound campaigns and a 5% increase in revenue
- Setup new KPIs to evaluate customer experience and product penetration
- Post-market analysis following product launches, giving data and recommendations relating to the customer experience in mind
- Planed and present workshop for an external partner on how to use Tableau dashboards
- Worked with data science, IT, product and L&D teams to maintain databases structure and models to ensure data and reports are accurate and structured
- Use of Python Pandas library to extract data for the Compliance team.
Data Analyst Manager
Motif Research
London
2012.06 - 2019.05
- The company is a market research consultancy specialized in loyalty and customer satisfaction, there I was accountable for managing the data, suppliers and analyst team, directed their development and grow
- Collaborated in new projects, reports and dashboards requirements and setup alongside with IT and business teams working as a data architect
- Headed the company’s data analysis strategy in collaboration with internal stakeholders
- Implemented Alteryx in the company, giving training and creating complex workflows for automation
- Improved the productivity and speed of an online dashboard from 4 hours to 15 minutes
- The tool is now used by all analysts and soon it will be used by other departments
- Manage internal and external stakeholders
- Development of the analyst team, proposing training, skill assessment and knowledge sharing
- Evaluation and implementation of existing and new software to be used within the analyst team
- Created a model to predict the type of transaction of the sample sent by the client, also run stats analyses using transaction with survey data combined to discover what drives customers to promote the client’s brand
- Delivered best practices, manuals and training for new and existing processes and tools
- Presented a business case at ASC Conference 2017 about ETL flow applied to market research.
Senior Data Analyst
Motif Research
London
2007.04 - 2012.06
- Accountable for report development and production, data accuracy, questionnaire scripting, data analyses and data interpretation
- Developed statistics skills with SPSS, learned Askia software and SQL
- Helped the implementation of a new market research software (Askia)
- Developed and implemented an online dashboard which is accessed over ten thousand times every week and it is use for the client’s bonus scheme
- Collaborated on the implementation of an ETL tool called Loadit which has been used by the whole company for various tasks.
Education
Bachelor of Business Administration - Marketing And Finance
1995.03 - 2001.05
Skills
Data AnalysisData modelingReporting developmentTableau / Power BI / Google Data StudioAlteryxSQLSalesforcePythonExcel
Timeline
Marketing Data and BI Manager - G.Network
2022.01 - Current
BI Manager - emap
2021.02 - 2022.01
Data Consultant - Motif Research
2020.11 - 2020.12
CS Operations Data Analyst EMEA - JUUL Labs
2019.05 - 2020.06
Data Analyst Manager - Motif Research
2012.06 - 2019.05
Senior Data Analyst - Motif Research
2007.04 - 2012.06
Pontificia Universidade Catolica - Bachelor of Business Administration, Marketing And Finance
1995.03 - 2001.05