Data Engineer - MS Fabric Experience- Contract to Hire

Note : Since this is contract to hire opportunity, we are looking for someone who does not need sponsorship in now or future. Major Financial Firm seeking an Data Engineer to play a key role in modernizing the firm's data platform and advancing its data and analytics capabilities. This is a transformational role directly aligned with Real Estate's commitment to leveraging data, analytics, and technology to proactively address business challenges and unlock new opportunities . The Data Engineer will be responsible for supporting and enhancing existing ETL processes for the on- prem data lake (PostgreSQL) while leading the evolution and migration of these processes to Microsoft Fabric. This role will focus heavily on developing and maintaining SQL-based transformation logic to ensure high quality, trusted, and analytics ready dat a. Working closely with the Data Management team, the Data Engineer will help identify, remediate, and prevent data quality issues by encoding validation rules and controls directly into data pipelines. The role will also contribute to the evaluation and implementation of tools and frameworks supporting data governance, architecture, and data quality as the platform continues to evol ve. Duties & Responsibiliti • es: Support and enhance existing ETL pipelines for an on‐premises data lake environment, primarily backed by Postgre • SQL.Refactor and migrate data ingestion, transformation, and orchestration processes to Microsoft Fabric using modern cloud-native patte • rns.Design, develop, and maintain complex SQL-based transformation logic, including views, functions, and analytical datas • ets.Build and optimize data models to support analytics and reporting use cases, including Power BI semantic mod • els.Perform aggregations and transformations across multiple data models (e.g., normalized, dimensional, lakehouse) to enable reliable insig • hts.Partner closely with data analytics and reporting teams to understand consumption needs and ensure data is structured for performance, usability, and scalabil • ity.Implement and enforce data quality rules, validation checks, and automated error detection within ETL and transformation workfl • ows.Support master and reference data processes, including defining data quality criteria, uniqueness rules, and remediation approac • hes.Collaborate with domain owners and data stewards to analyze root causes of data quality issues and drive corrective acti • ons.Monitor cross-domain data provisioning to ensure data is sourced from approved and governed syst • ems.Contribute to the evaluation and implementation of data governance, architecture, and quality tools in partnership with Global Technology te • ams.Document data pipelines, transformation logic, and architectural decisions to support maintainability and knowledge shar ing. Preferred Qualificat ions:The successful candidate brings a structured, detail-oriented approach and a hands-on mindset toward advancing the organization's data platform moderniza • tion.Bachelor's degree requ • ired.Minimum of 3+ years of experience in a data engineering or analytics engineering • role.Strong hands-on experience with SQL, including complex transformations, performance tuning, and data mode • ling.Experience supporting ETL pipelines in an on‐prem or hybrid data lake environment; exposure to PostgreSQL strongly prefe • rred.Experience migrating or modernizing data platforms to Azure and/or Microsoft Fabric (Lakehouse, Pipelines, or related servi • ces).Solid understanding of modern data lake and warehousing architect • ures.Working knowledge of data engineering tools and languages such as SQL, Python, Spark, or similar technolo • gies.Experience with at least one relational database platform (PostgreSQL, SQL Server, My • SQL).Familiarity with data governance, data quality, or MDM concepts and too • ling.Experience working in an agile, collaborative, cross-functional environ • ment.Strong written and verbal communication skills; able to translate business requirements into technical solut • ions.Highly analytical, detail-oriented problem solver with a proactive, self‐starter menta • lity.Comfortable working in evolving environments and translating conceptual requirements into pragmatic, scalable solut ions.