Data Engineer

Applied Info Services India Pvt Ltd; Hyderabad; On-site; INR 800,000 - 1,500,000; Full time

Job summary

Applied Info Services India Pvt Ltd (AIS) seeks a mid-level Data Analytics Engineer to build and support modern data solutions using Microsoft Fabric and the Azure data ecosystem. The role is hands-on, focusing on reliable data pipelines, transforming and modeling data for analytics, and enabling scalable lakehouse-based architectures.

You will collaborate with architects, BI developers, analysts, and source-system teams, implement CI/CD and observability, and mentor juniors as you grow with

Qualifications

• Experience with SQL and relational data concepts.
• Practical experience with Microsoft Fabric components (Data Factory / Pipelines, Lakehouse, Notebooks, Warehouse).
• Experience designing ETL/ELT and incremental data processing.
• Knowledge of Medallion Architecture and layered data transformation patterns.

Responsibilities

• Build and maintain data ingestion pipelines from databases, APIs, files, and cloud storage sources.
• Develop transformation workflows across Bronze, Silver, and Gold layers within Fabric.
• Create curated analytical datasets and dimensional models for reporting and analytics.
• Implement incremental data processing, validation, and data quality checks.
• Develop reusable data engineering components and metadata-driven patterns.
• Monitor and troubleshoot data workloads and performance bottlenecks.

Skills

Writes complex SQL

Models data

Builds ETL/ELT pipelines

Applies Python/R and BI tools

Data warehouses and cloud services

Statistics & ML analyses

Tools

Microsoft Fabric

Data Factory / Pipelines

Lakehouse

Notebooks

Warehouse

Spark / PySpark

Git / CI/CD

Job description

Why AIS?

When you join AIS, you’re joining a mission-driven team that’s passionate about making a difference. You’ll work on projects that matter, alongside industry-leading experts, in an environment that fosters innovation, driving client success, and empowering our team to make a lasting impact. As an employee-owned company, we value collaboration, inclusivity, continuous growth, and shared success. Employee Ownership: Your contributions directly impact the company’s success, and you share in its achievements. Continuous Learning: Access to resources, training, and mentorship to support your professional growth. Inclusive Culture: A workplace where diversity is celebrated, and everyone’s voice is valued. Mission-Driven Work: Engage in projects that make a meaningful difference for our clients and communities.

What are we looking for?

At AIS, we're looking for more than just skills - we're looking for driven individuals who are passionate about making a difference, eager to grow, and aligned with our core principles.

Working@AIS

At AIS, we are dedicated to providing our employees with diverse opportunities to grow their careers while supporting a variety of impactful projects. For this position, we are seeking a talented individual to join AIS as a Data Analytics Engineer.

Core Knowledge & Skills

• Writes complex SQL


• Models data


• Builds and maintains ETL/ELT pipelines


• Applies Python/R and BI tools


• Works with data warehouses and introductory cloud services


• Conducts intermediate statistical and ML analyses

Work & Complexity

• Designs pipelines and optimizes performance


• Addresses moderate data quality and integration issues


• Directly improves project efficiency and reliability

Quality & Independence

• Produces high-quality analyses and reproducible results


• Operates independently within defined parameters


• Suggests process enhancements

Teamwork & Communication

• Partners with cross-functional teams


• Presents findings to stakeholders


• Establishes feedback loops


• Begins mentoring juniors

Consulting & Engagement

• Consults on analytics projects


• Elicits needs


• Proposes solutions


• Documents outcomes

Project Summary

We are looking for a mid-level Data Engineer with 4-6 years of experience to build and support modern data solutions using Microsoft Fabric and the Azure data ecosystem. The role is primarily hands‑on and will involve developing reliable data pipelines, transforming and modeling data for analytics, and supporting scalable lakehouse‑based solutions. The ideal candidate should have strong data engineering fundamentals, solid SQL skills, and practical experience with Microsoft Fabric.

Key Responsibilities

• Build and maintain data ingestion pipelines from relational databases, APIs, files, SaaS applications, and cloud storage sources


• Develop transformation workflows across Bronze, Silver, and Gold layers within Microsoft Fabric


• Create curated analytical datasets and dimensional models for downstream reporting and analytics


• Implement incremental data processing, validation, error handling, and data quality checks


• Develop reusable and maintainable data engineering components, including metadata‑driven patterns where appropriate


• Support data workloads across Fabric Lakehouse, Warehouse, Pipelines, and Notebooks


• Monitor and troubleshoot pipeline failures, data issues, and performance bottlenecks


• Participate in code reviews, testing, documentation, and deployment activities


• Work with architects, BI developers, analysts, and source‑system teams to translate business requirements into data solutions


• Follow engineering standards for security, source control, CI/CD, observability, and production support

Required For This Opportunity

• Data Engineering, Data Platform, or BI Engineering roles


• Strong hands‑on experience with SQL and relational data concepts


• Practical experience with Microsoft Fabric, particularly: Data Factory / Pipelines, Lakehouse, OneLake, Notebooks, Warehouse


• Experience with Spark, PySpark, or Spark SQL


• Good understanding of Delta Lake and lakehouse architecture


• Experience designing and implementing ETL/ELT and incremental data processing


• Good understanding of Medallion Architecture and layered data transformation patterns


• Experience with dimensional modeling, including facts, dimensions, and star schemas


• Working knowledge of Git and CI/CD practices


• Good understanding of data quality, troubleshooting, logging, and production support

Nice to Have Skills

• Experience with Azure services such as Key Vault, Entra ID, and Azure DevOps


• Familiarity with Power BI, Semantic Models, and Direct Lake


• Experience with CDC, Change Tracking, or other incremental ingestion techniques


• Familiarity with Fabric security, governance, lineage, and Microsoft Purview


• Experience integrating data from platforms such as Salesforce


• Microsoft Fabric or Azure data certifications

A company with a commitment to building strong relationships with our clients and employees for almost 40 years. AIS has a valued and long‑term partnership with the Microsoft Corporation dating back to 1994 when Microsoft first launched its partner program. Since then, we have focused on growing our technical competencies to complement Microsoft’s product innovations and new feature releases. As one of the first 15 partners to attain all possible Microsoft Solution Partner Designations, we are continually aiming to progress the enterprise‑level innovations of our clients.