Data Engineer

Job Description: You will be a Data Engineer with expertise in Microsoft Fabric, focusing on technologies like OneLake, Data Warehouse, Dataflows, and Data Factory. Your primary responsibility will involve creating, enhancing, and managing scalable data pipelines, integrating various data sources, and enabling analytics and reporting within the Microsoft Fabric ecosystem. Key Responsibilities: - Design and execute comprehensive data solutions using Microsoft Fabric's unified analytics platform. - Develop and sustain data pipelines utilizing OneLake, Dataflows Gen2, and Data Factory pipelines. - Construct and oversee enterprise-level data warehouse models in Microsoft Fabric. - Enhance performance and storage efficiency by implementing best practices in Lakehouse and data warehousing. - Collaborate with data analysts, BI developers, and business stakeholders to ensure data accuracy and usability. - Implement and enforce data governance, security, and compliance policies within the Fabric environment. - Monitor data jobs and address any failures or performance issues promptly. - Contribute to architectural discussions and create best practice documentation for data platform design. Required Qualifications: - 3-6 years of experience in data engineering or related roles. - Proficient in Microsoft Fabric, including OneLake, Data Warehouse, Dataflows, and Pipelines. - Strong skills in T-SQL, DAX, and either Python or Spark for data transformations. - Experience with Power BI and its integration with Fabric datasets. - Sound knowledge of data modeling (star/snowflake schemas), ELT/ETL processes, and cloud data storage principles. - Familiarity with data governance and security practices in Azure. Company Description: Pi Systems is a global consulting firm specializing in aiding small and mid-sized enterprises in leveraging AI, Microsoft technologies, and strategic IT services for growth. With expertise in logistics, healthcare, manufacturing, and financial services, Pi Systems delivers tailored solutions through Microsoft-certified teams in India and the USA. The company prioritizes ethical delivery, measurable impact, and long-term trust. Benefits: - Health insurance - Work from home Work Location: In person,