Data Engineer

Greetings from AIS!!

AIS (Applied Information Sciences) is a highly regarded software and systems engineering firm providing professional application development services to commercial and government clients since 1982. One of Microsoft's oldest and largest Managed Gold partners in the U.S., AIS is exclusively focused on building enterprise-class custom applications using Microsoft technologies. As we continue to experience extraordinary growth, we are seeking professionals to join our AIS Team

For more information, please visit

http://www.ais.com

https://blog.ais.com

Role: Data Engineer

Exp : 7+

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.

The Role:

• 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 Skills:

• 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.

Preferred Skills:

Experience with dbt.

• 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.

If you are interested, please inbox your profile to [email protected]

Thanks & Regards,

Navya N

Talent Acquisition Business Partner

Email: [email protected]