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.
**Responsibilities**:
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.
**Benefits and Perks**:
**Location**:Guadalajara,**Jalisco, Mexico (working from home - office won't be mandatory all the time, rather it will required from time to time).

📌 Senior Data Engineer (Guadalajara)
🏢 KMS Technology
📍 Guadalajara