HR Data Integration Engineer — End-to-End Delivery

Pyramid Consulting, Inc; Ciudad de México; On-site; MXN 900,000 - 1,350,000; Full time

Job summary

Pyramid Consulting, Inc. is seeking an HR integration specialist to design, build and deliver complex HR data integrations. You will own requirements, develop robust integrations, and provide SME-level production support across DevOps pipelines.

The role requires hands-on experience with Databricks, Spark, SQL modeling, and CI/CD tooling, along with strong analytical and documentation skills. You will collaborate with cross-functional teams and adhere to HRIT standards throughout the delivery

Qualifications

• Strong hands-on experience with Databricks and Apache Spark (PySpark preferred; Scala a plus).
• Solid understanding of Delta Lake features and operations.
• Experience integrating with cloud storage and data services (Azure/AWS/GCP) and JDBC connectors.
• Proficiency in SQL and data modelling concepts (dimensional, lakehouse).
• Experience with Git, branching strategies, and CI/CD tooling (Azure DevOps/GitHub Actions).
• Strong analytical and problem-solving skills; strong documentation abilities.
• Familiarity with Agile framework and delivery lifecycle management.
• Experience with XML, JSON, XSLT/XPath expressions, SQL, JMS, CFX.
• DevOps tooling: Jenkins, Nexus, GitHub, JIRA.
• NoSQL experience such as MongoDB.

Responsibilities

• Drive end-to-end integration delivery through analysis, design, build and deployment.
• Manage requirement gathering and analysis for integration builds.
• Develop new and enhanced integrations following HRIT and HR delivery lifecycle.
• Develop and maintain integration patterns and blueprints per HRIT/HR standards.
• Document integration specifications and patterns per HR standards.
• Assist with test scenario prep and guidance for HRIT/HR test teams.
• Support and troubleshoot integrations through deployment test phase pipelines.
• Provide HRIT integration SME production support for troubleshooting and analysis.

Skills

Databricks & Spark

SQL & data modelling

CI/CD tooling

Git & CI/CD

Agile delivery

Analytical thinking

Technical documentation

NoSQL MongoDB

XML/JSON/XSLT

Tools

Jenkins

Nexus

GitHub

JIRA

MongoDB

Delta Lake

Job description

Pyramid Consulting, Inc. is seeking an HR integration specialist to design, build and deliver complex HR data integrations. You will own requirements, develop robust integrations, and provide SME-level production support across DevOps pipelines.

The role requires hands-on experience with Databricks, Spark, SQL modeling, and CI/CD tooling, along with strong analytical and documentation skills. You will collaborate with cross-functional teams and adhere to HRIT standards throughout the delivery