Learn Data Skills
Beta
Mikel Garcia Prats

Mikel Garcia Prats

Certified

Analytics Engineer

Job&Talent

Technologies

My Portfolio Highlights

My New Course

Introduction to SQL

My New Track

Data Analyst

My New Course

Introduction to SQL

Data alchemist, transforming raw numbers into golden insights.

My Work

Take a look at my latest work.

course

Data Manipulation with pandas

course

Introduction to SQL

course

Intermediate Python

course

Data Manipulation with pandas

My Certifications

These are the industry credentials that I’ve earned.

Data Engineer Associate

Data Engineer Associate

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to SQL
Intermediate Python
Data Manipulation with pandas
Understanding Cloud Computing

My Work Experience

Where I've interned and worked during my career.

VIU - Universidad Internacional de Valencia | Jan 2025 - Present

Lecturer in People Analytics

As a Lecturer in People Analytics for the Master’s in Human Resources at the International University of Valencia, my responsibilities include: • Online Teaching: Delivering live online classes, covering key People Analytics concepts and tools for HR decision-making. • Tutoring: Offering one-on-one and group tutorials to support student learning and provide guidance on projects and assignments. • Course Development: Designing and creating the entire course curriculum, including lectures, case studies, and exercises. • Examinations and Grading: Developing and grading exams, assignments, and projects, providing feedback to ensure student progress. • Student Support: Monitoring student performance and providing personalized feedback to facilitate their academic growth.
Show More

Job&Talent | Nov 2022 - Present

Analytics Engineer

As an Analytics Engineer on the Data team at JobandTalent, my role involves: • Leveraging dbt (core version) to transform and optimize tables in Redshift, ensuring they meet business needs. • Utilizing dbt Cloud to orchestrate and manage jobs, ensuring seamless and efficient workflow automation. • Developing robust SQL dbt models to streamline data processes and enhance data accessibility. • Refining, harmonizing, and filtering data sets to ensure they are accessible and actionable for the entire data team. • Applying best practices in project design, categorizing our models into staging, intermediate, and mart layers for optimal organization and performance. • Developing dimensions and metrics in LookML (Looker) to support comprehensive analytics across all business units.

Job&Talent | Sep 2021 - Oct 2022

Data Analyst & BI Engineer

As a member of the BI - Engineering department at JobandTalent, I have the opportunity to participate in the following activities through the Scrum (Agile) methodology: • Design and implementation of ETLs using the dbt tool to provide robust and reliable data retrieval processes for business teams. • Optimization and creation of SQL queries (using popSQL and dbt) on Amazon Redshift. • Resolution of technical incidents in SQL that result in errors in data queries by business teams. • Standardization of metrics with the goal of unifying criteria throughout the organization for consuming critical data.

KPMG España | Oct 2019 - Sep 2021

Data Analyst

As a member of the D&A Audit department at KPMG, I have the opportunity to engage in the following activities: • Design and implementation of workflows in Alteryx for ETL processes. • Design and implementation of data analysis tests using various applications (SQL) to support the audit team. • Implementation of machine learning algorithms in Scikit-learn (Python), with the goal of developing predictive models in various audit areas. • Large-scale data processing using Excel and Python. • Execution of data analysis using proprietary tools based on SQL. • Innovation in technology to enhance the reliability of client processes within the audit team. • Conducting data tests focused on auditing to uncover fraud.

KPMG España | Jul 2018 - Oct 2019

Talent Acquisition

As a member of the People (Human Resources) department at KPMG, I have the opportunity to engage in the following activities: • Management of processes and selection initiatives within the Audit area at a national level • Direct interaction with various lines of business involved in the processes, aiming to manage the firm's needs • Collaboration in the organization of innovative selection processes to drive new hiring approaches. • Employer Branding actions and participation in forums and talks at universities and business schools to foster the acquisition of top talent.

Management Solutions | Nov 2016 - Jun 2018

HR Generalist

Recruitment; Madrid, Bilbao, Lisbon, and London: • CV screening and candidate filtering with diverse profiles: Functional, IT, and Methodological; across various job portals (LinkedIn, Infojobs) • Facilitation of group dynamics • Creation of reports on candidates and assessment of profiles. • HR interviews: Spain and Portugal • Contacting and posting job offers on International Universities (Spain, UK, and Portugal) • Talent acquisition: Representing the company at various university job fairs: Deusto, UNAV, UPNA, UC, UPV/EHU Training: • Management of courses within the generic training plan and the Master's in Business Consulting (University of ICADE) • Monitoring, evaluation, and assessment of provided training courses, for subsequent development and implementation of improvements in the training plan • Documentation management (FORCEM) Administrative tasks: • Employee management in Navision • Handling onboarding of new employees and processing offers • Contract management • Management of enrollments and departures • University agreement management

Inetum | Jan 2016 - Jun 2016

HR department

• Recruitment and Selection, IT Sector: Languages; J2EE, Cobol, C++, .Net, Databases; Oracle, DB2, SQL Server. • Document Management in Occupational Health and Safety • Design of Training Plan • Payroll Management • Management of Employees on Virtual Platforms

My Education

Take a look at my formal education

Master of Business Intelligence & Big Data, Ingeniería informáticaUniversidad Camilo José Cela | 2020
Master en gestión de los RRHH y del empleo, Gestión de recursos humanos/ Administración de person...UPV/EHU | 2018
psicología, PsicologíaUniversidad de Deusto | 2016

About Me

Mikel Garcia Prats

Mikel hasn't filled in a bio text

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free