Data Engineer

Join to apply for the Data Engineer (Microsoft Fabric/Synapse) - WFH role at MicroSourcing Why join MicroSourcing Competitive Rewards: Enjoy above‑market compensation, healthcare coverage on day one, plus dependents, paid time‑off with cash conversion, group life insurance, and performance bonuses A Collaborative Spirit: Contribute to a positive and engaging work environment by participating in company‑sponsored events and activities Work‑Life Harmony: Enjoy the balance between work and life that suits you with flexible work arrangements Career Growth: Take advantage of opportunities for continuous learning and career advancement Inclusive Teamwork: Be part of a team that celebrates diversity and fosters an inclusive culture Position Summary The Data Engineer plays a foundational role in enabling enterprise‑wide data access and analytics. As a key member of the small but high‑impact Data & Analytics team—including a Power BI Developer and Data Analyst—this role is responsible for acquiring, transforming, and integrating data from a diverse range of source systems, including multiple ERPs and SaaS applications. The ideal candidate combines strong technical skills with a deep curiosity for data and problem‑solving across modern and legacy technologies. This role will be responsible for designing, managing, and enhancing our Medallion Architecture within Microsoft Fabric, ensuring a structured, scalable and high‑quality data foundation that powers downstream reporting, advanced analytics, and business insight generation. Key Responsibilities Design, build, and maintain data pipelines that ingest data from various sources including Microsoft SQL Server, PostgreSQL, IBM DB2, SaaS APIs, and flat files Prioritise data source integration based on business value and stakeholder needs Implement data ingestion patterns that support both batch and real‑time pipelines Own and evolve the Medallion Architecture (Bronze, Silver, Gold layers) within the Microsoft Fabric Lakehouse environment Structure and transform raw ingested data (Bronze) into cleansed, conformed datasets (Silver) and curated, business‑ready data models (Gold) Collaborate with the Power BI Developer and Data Analyst to ensure Gold layer datasets align with the semantic model and reporting needs Implement controls and monitoring to ensure data accuracy, freshness, and integrity at each stage of the pipeline Document data flows, transformations, and lineage from source through to Power BI Apply data access governance and classification policies in accordance with enterprise standards Troubleshoot pipeline failures and support operational continuity for business‑critical data feeds Engage with ERP/IT teams to understand schema changes and coordinate integration updates Participate in Agile planning, sprint ceremonies, and shared delivery roadmap Tooling, Automation & Innovation Use Fabric‑native tools (Dataflows Gen2, Pipelines, Notebooks) and languages like SQL, Python, or Spark to build scalable data workflows Automate routine tasks and enable self‑service data access where appropriate Explore new methods to bridge modern and legacy system integration Support & Collaboration Troubleshoot pipeline failures and support operational continuity for business‑critical data feeds Engage with ERP/IT teams to understand schema changes and coordinate integration updates Participate in Agile planning, sprint ceremonies, and shared delivery roadmap Qualifications & Experience Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or related field (or equivalent experience) Certifications in Microsoft Azure or Fabric data engineering pathways are advantageous 5+ years of experience in data engineering with exposure to hybrid cloud and on‑premise ecosystems Strong hands‑on experience working with Microsoft SQL Server, PostgreSQL, IBM DB2, or similar platforms Proven experience in building ELT/ETL pipelines across structured, semi‑structured, and API‑driven sources Practical knowledge of the Medallion Architecture and Microsoft Fabric lakehouse principles (or similar lakehouse paradigms such as Databricks Delta) High proficiency in SQL, data modelling, and data transformation Strong Python or Spark skills for data orchestration and enrichment Pragmatic approach to solving complex integration problems with incomplete or legacy documentation Collaborative mindset with strong communication skills across business and technical domains Detail‑oriented with a commitment to data quality and long‑term maintainability Note from the client We need someone with direct experience with Microsoft Fabric/Synapse OR someone with at‑least 5 to 7 years experience in Data Engineering, Data Warehouse and ETL with big data platforms like BigQuery, Snowflake, Databricks. Seniority level Mid‑Senior level Employment type Full‑time Job function Information Technology #J-18808-Ljbffr