Sr. Data Engineer Microsoft Technologies (Ahmedabad, India)

Overview : Artic Consulting is a dynamic IT and consulting services firm, delivering digital transformation through innovative solutions in data, cloud, and business analytics. We are seeking a skilled Data Engineer with a strong focus on the Microsoft Fabric ecosystem, who can design and implement scalable data solutions for our clients. Key Responsibilities: - Design, develop, and maintain Power BI reports, dashboards, DAX expressions, KPIs, and scorecards using both Import and Direct Query modes. - Build and orchestrate scalable ETL/ELT workflows using Fabric Data Pipelines, Dataflows Gen2, and Azure Data Factory. - Write and tune complex T-SQL and KQL queries, stored procedures, and views for performance in Synapse SQL and SQL Server environments. - Implement data models based on star/snowflake schemas and support modern data warehousing and Lakehouse architectures using Microsoft Fabric. - integrate structured and unstructured data sources (e.g., SQL, Excel, APIs, Blob Storage), and transform them efficiently using Fabric Notebooks (Spark/PySpark) or Dataflows. - Diagnose and resolve pipeline failures, logic errors, and performance bottlenecks across the data engineering lifecycle. - Automate repetitive data processes using Azure Functions, Logic Apps, PowerShell, or Python scripting within the Fabric ecosystem. - Collaborate with stakeholders to gather business requirements and translate them into scalable data solutions. - Ensure data governance, privacy, and compliance standards (e.g., GDPR, HIPAA, ISO) are adhered to, including sensitive data handling policies. - Apply best practices for item-level security, workspace-based access models, and data lineage using Microsoft One Lake and Fabric tools. Required Qualifications: - Bachelor's or master's degree in computer science, Information Systems, or related field. - Minimum 3 years of experience in Power BI development and data engineering. - Strong expertise in T-SQL and KQL, with demonstrated query optimization skills. - Proficiency in Microsoft Fabric tools: Data Pipelines, Dataflows Gen2, OneLake, Notebooks. - Hands-on experience with Spark/PySpark and data integration from varied sources. - Microsoft Power BI certification (PL-300) or equivalent Microsoft certifications. Preferred Skills: - Experience debugging and optimizing advanced SQL queries, database objects, and legacy components. - Ability to implement database security models and data protection policies . - Expertise in implementing row-level security, dynamic data masking, and role-based access control within Microsoft Fabric and Power BI environments. - Familiarity with Microsoft OneLake architecture, including data cataloging, lineage tracking, item-level security, and workspace-based access management. - Proven ability to operate effectively in energetic, client-facing environments, delivering scalable and compliant data solutions with a focus on performance and quality. Why Join Artic Consulting - Work with cutting-edge Microsoft technologies in a dynamic and collaborative environment. - Flexible work culture with opportunities for growth and certifications. - Be part of a mission to deliver impactful digital transformation for clients globally. Job Type: Full-time Compensation: 1,200,000.00 - 2,200,000.00 per year .