Lead Data Engineer

Guidanz Inc; Tamil Nadu; On-site; INR 12,00,000 - 18,00,000; Full time

Job summary

A leading data solutions provider in Tamil Nadu is seeking a Lead Data Engineer to design and manage enterprise-grade data pipelines using Microsoft Fabric and Azure Data Factory. The role involves working directly with clients to translate business needs into scalable solutions while leading and mentoring a small team. Ideal candidates will have 6+ years in data engineering, expertise in SQL, and strong communication skills. This position offers competitive pay and opportunities for growth.

Benefits

Competitive salary

Opportunities for growth

Fast-paced environment

Qualifications

• 6+ years in data engineering, with 2+ years leading/mentoring teams.
• Strong expertise in Microsoft Fabric and Azure Data Factory.
• Advanced proficiency in SQL and Stored Procedures.
• Proven end-to-end project delivery experience.
• Deep understanding of Medallion Architecture and data lakehouse practices.

Responsibilities

• Design, develop, and optimize data pipelines in Fabric and ADF.
• Architect solutions using Medallion Architecture.
• Lead small teams and mentor data engineers.
• Work directly with customers to gather requirements.
• Deliver production-grade solutions with monitoring and optimization.

Skills

Data engineering

Microsoft Fabric

Azure Data Factory

SQL

Stored Procedures

End-to-end project delivery

Job description

About BI Connector

BI Connector is the industry leading solution for integrating Oracle Fusion Cloud data into modern BI platforms like Power BI, Tableau, and Data Warehouse, without complex ETL. Our Data Architecture and Reporting Solutions team extends this mission by helping enterprises unlock the full value of their Oracle Fusion ERP, SCM, HCM data through expertly crafted data pipelines, reports, dashboards, and data models. We’re now building pre-built data pipelines, dashboards and analytics apps to help customers go from raw data to insights faster.

About the Role

We are seeking a Lead Data Engineer to design, build, and manage enterprise-grade data pipelines in Microsoft Fabric and Azure Data Factory (ADF). This is a customer-facing role, where you’ll partner directly with clients to translate business needs into scalable data solutions, while leading and building small teams and mentoring other engineers.

The ideal candidate is hands-on with Fabric/ADF, strong in SQL and Stored Procedures, and experienced in delivering end-to-end projects using Medallion Architecture.

Key Responsibilities

• Design, develop, and optimize metadata-driven data pipelines in Fabric and ADF for ingestion, transformation, and delivery. Implement transformations using SQL and Stored Procedures to ensure performance and maintainability.
• Architect solutions using Medallion Architecture, ensuring scalability, governance, and reusability.
• Lead small teams, mentor data engineers, and set technical direction on projects.
• Work directly with customers to gather requirements, troubleshoot, and provide best-practice guidance.
• Integrate data from Oracle Fusion ERP, HCM, SCM, and other SaaS/on-prem systems into Fabric, Data Lakes, or Warehouses.
• Deliver production-grade solutions with monitoring, error handling, and performance optimization.
• Document and share best practices, reusable frameworks, and provide knowledge transfer to client teams.

What You Bring

• 6+ years in data engineering, with 2+ years leading/mentoring teams.
• Strong expertise in Microsoft Fabric and Azure Data Factory (ADF).
• Advanced proficiency in SQL and Stored Procedures.
• Proven end-to-end project delivery experience (from raw ingestion to BI/analytics).
• Deep understanding of Medallion Architecture and data lakehouse practices.
• Excellent communication skills for working with both business and technical stakeholders.

Bonus Points For

• Exposure to Oracle Fusion ERP/HCM/SCM data models or BI/reporting tools.
• Familiarity with BI Connector or other integration middleware.
• Consulting/professional services background (customer-facing delivery).
• Knowledge of data governance, lineage, and security in Azure.
• Experience with Databricks or Snowflake ETL.

What We Offer

• Lead high-impact customer-facing projects at the intersection of Microsoft Fabric, Azure, and Oracle Fusion.
• Mentor and grow a team while staying hands-on with cutting-edge technologies.
• Shape the future of enterprise data architectures with Fabric + lakehouse best practices.
• Competitive salary, benefits, and opportunities to grow in a fast-moving, customer-first team.

How to Apply

Email your resume and portfolio to [e-mail]. Include a brief note on your domain background and what you love about turning data into decisions.