You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Hector Herrera EspinolaHH

Hector Herrera Espinola

Senior BI / Analytics Engineer

€750/day
Dublin, IE
8-15 years

Average response time: 1 hour

About Hector

Analytics Engineer with over 5 years of experience building reliable data infrastructure, BI solutions, and end-to-end reporting pipelines across healthcare, legal insurance, FMCG, and manufacturing sectors. Proven track record designing scalable DBT data models, cloud-based pipelines, and executive dashboards that drive business performance and enable stakeholder self-service.
Skilled in Python, SQL, DBT, and Snowflake, with hands-on experience in Azure (Data Factory, Synapse, Databricks), advanced data modeling (star/snowflake schema, OBTs, SCDs), and data quality frameworks including contracts and validation checks. Experienced applying AI tools to data workflows — including cloud AI and emerging AI platforms — to automate pipelines and improve data accessibility. Strong background in data governance, compliance data, cross-functional collaboration, and mentoring. Fluent in Spanish and English, with intermediate Portuguese.
  • Spanish

    Native or bilingual

  • English

    Native or bilingual

  • Portuguese

    Conversational

Remote only
Primarily works remotely

Experience

  • Datavant
    Senior BI / Analytics Engineer
    TECH
    January 2026 - Today (7 months)
    Ireland
    • • Built and maintained reusable DBT data models powering the core reporting layer, implementing data contracts and validation checks that catch quality issues before they reach stakeholders.
    • • Designed and delivered scalable BI dashboards in Sigma for the Legal and Insurance business units, establishing the primary self-service reporting layer for cross-functional teams.
    • • Integrated LLM-assisted workflows into daily analytics work, accelerating SQL development, automating DBT model documentation, and reducing turnaround on ad-hoc analysis from days to hours.
    • • Conducted exploratory and ad-hoc analysis using SQL and Python to surface trends, anomalies, and business opportunities, translating findings into actionable recommendations.
    • • Partnered with finance, operations, HR, and compliance stakeholders to translate business requirements into analytical solutions, collaborating with data engineering to ensure integrity between source systems and the reporting layer.
  • Kenvue
    Analytics Engineer
    RETAIL (LARGE RETAILERS)
    April 2025 - December 2025 (8 months)
    Ireland
    • • Retained through the J&J Consumer Health spin-off into Kenvue, embedded within the Digital Transformation Office to deliver analytics engineering solutions at global scale.
    • • Delivered Power BI dashboards and automated reporting pipelines, giving executives real-time visibility into KPIs across multiple business units.
    • • Led data governance and quality initiatives for strategic reporting, defining standards for accuracy, integrity, and security of executive-level data.
    • • Evaluated and integrated analytics platforms (Azure, Databricks) with IT and business stakeholders, improving scalability of the global reporting architecture.
    • • Trained business users on BI tools and data best practices, accelerating self-service adoption across business units.
  • Johnson & Johnson
    Data Engineer
    PHARMACEUTICALS INDUSTRY
    July 2023 - April 2025 (1 year and 9 months)
    Ireland
    • • Built data pipelines ingesting manufacturing, compliance, and inventory process metrics; performed ETL using R, Python, Alteryx, and SQL across internal and cloud-based systems.
    • • Reduced inventory costs by 25% in Asia-Pacific by identifying excess stock and implementing a batch expiration-based prioritization strategy.
    • • Accelerated EMEA dashboard performance by 30% by migrating R scripts to PySpark within Databricks.
    • • Delivered monthly Power BI training to groups of 15–20, increasing data literacy and reporting efficiency across the organization.

Recommendations

Be the first to recommend Hector

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • MSc Computing
    Atlantic Technological University
    2027
    MSc Computing
  • BS
    Universidad Tecnológica Nacional
    2016
    BS

Categories