Senior Data Engineer

KMS Technology, Inc.; Región Centro; Presencial; MXN 900,000 - 1,250,000; Jornada completa

Descripción de la vacante

A leading technology solutions provider in Mexico seeks a Senior Data Engineer specializing in Microsoft Fabric. The role focuses on designing scalable data transformation solutions and optimizing data pipelines. Candidates should have over 5 years of software development experience, with a strong background in Microsoft Fabric, SQL, and data warehousing methodologies. The position offers attractive benefits, including a performance bonus and paid certifications.

Servicios

Mexican law benefits

15 days of PTO

5 days' leave for family deaths

Major Medical Expenses Insurance

Annual performance bonus

Annual salary adjustment

Employee Referral Bonus

Paid Certifications / Courses

Coursera License

5% Savings Fund

5% Grocery Vouchers

Formación

• 5+ years of professional software development experience, with 3+ years in data engineering.
• Expertise in Microsoft Fabric, including pipelines and Synapse SQL.
• Advanced experience with SQL/T-SQL for complex transformations.

Responsabilidades

• Design and develop reusable data pipelines in Microsoft Fabric.
• Implement advanced data transformations using T-SQL.
• Lead configuration of Fabric environments and enforce governance standards.

Conocimientos

Microsoft Fabric

T-SQL

Data Engineering

Data Warehousing

Python/PySpark

Educación

Azure Data Engineer Associate (DP-203)

Herramientas

Azure Data Lake Storage Gen2

Azure DevOps

Descripción del empleo

Company Description

At KMS Technology, we are dedicated to delivering cutting‑edge solutions and services that empower businesses to achieve their goals. Our team is composed of highly skilled professionals who are passionate about technology and innovation. We provide a dynamic and collaborative work environment where you can grow your career and make a significant impact.

Job Description

We are seeking a highly experienced Senior Data Engineer specializing in the Microsoft Fabric platform. This role is responsible for leading the setup, design, and development of scalable, high-performance data transformation solutions across a unified Lakehouse architecture. The ideal candidate will excel in building dynamic ELT pipelines, optimizing workspace performance, and enforcing governance standards using Fabric Data Pipelines, Synapse SQL, and OneLake. You will play a key role in shaping foundational architecture, implementing best practices, and ensuring reliable, high-quality data operations across Fabric environments.

Responsibilities

• Design and develop dynamic, parameterized, and reusable data pipelines within Microsoft Fabric for efficient data movement and control flow.
• Implement advanced data transformations by developing complex ELT logic using T‑SQL within Synapse SQL endpoints and stored procedures.
• Lead the technical setup and foundational configuration of Fabric environments, including resource provisioning, security setup, and governance best practices.
• Define and enforce metadata management standards, including lineage, tagging, and discoverability requirements across Fabric.
• Architect OneLake ingestion and organization patterns, ensuring data is correctly structured (e.g., Delta format) for downstream Fabric workloads.
• Ensure workspace compatibility and performance optimization across both Dedicated Premium and Shared Fabric capacity environments.
• Translate complex business data models into scalable, resilient architectural solutions using Fabric components such as Lakehouse, Warehouses, and Notebooks.
• Optimize T‑SQL logic and pipeline execution to reduce latency, improve performance, and manage compute resource costs.
• Implement robust monitoring, alerting, and error‑handling frameworks to ensure operational reliability and data integrity for production pipelines.
• (Nice‑to‑have) Integrate PySpark/Spark notebooks into Fabric pipelines for advanced data processing or machine learning workloads.

Qualifications

• 5+ years of professional software development experience, with 3+ years focused on large‑scale data engineering.
• Expert‑level proficiency in Microsoft Fabric, including Fabric Pipelines (control flow, activities, parameters, variables), OneLake, and Synapse SQL.
• Advanced experience with SQL/T‑SQL, specifically for developing complex transformation logic within the Synapse SQL environment.
• Proven experience designing and implementing high‑throughput ELT and batch ingestion pipelines.
• Strong understanding of data warehousing methodologies (Kimball / Inmon) applied within Lakehouse architectures.
• Familiarity with Azure services such as Azure Data Lake Storage Gen2 and Azure DevOps.
• Relevant Azure certifications such as Azure Data Engineer Associate (DP‑203).
• Experience with data modeling, including medallion architecture patterns within OneLake.
• Experience developing Python/PySpark notebooks within Fabric for advanced data processing.

Additional Information

Perks you enjoy at KMS Mexico

• Mexican law benefits
• 15 days of PTO (in year zero, from the first year onwards it is 3 days per year).
• 5 days' leave for the death of immediate family members, negotiable.
• Major Medical Expenses Insurance with coverage for immediate dependents (spouse and children).
• Annual performance bonus (≈10% of annualized salary).
• Annual salary adjustment.
• Employee Referral Bonus.
• Paid Certifications / Courses
• Coursera License.
• 5% Savings Fund.
• 5% Grocery Vouchers.