[Remote] Data Engineer

Note: The job is a remote job and is open to candidates in USA. PartnerOne is seeking a Data Engineer to design, build, and maintain robust data pipelines for the Mortgage Cadence Platform. This role focuses on executing end-to-end data workflows and requires strong SQL, ETL, and data quality skills.ResponsibilitiesDesign and build extraction, transformation, and loading (ETL) pipelines using Microsoft Fabric (Dataflow Gen2, Notebooks, or equivalent tools)Write optimized SQL queries and transformations for data ingestion from designated source systemsApply data quality rules and validation logic at each pipeline stageImplement incremental loads and manage refresh schedules for performanceEscalate to Lead for architectural decisions or complex transformation patternsDefine and implement data quality checks at ingestion, transformation, and output stagesPerform ongoing data validation to ensure pipeline outputs align with business logic and source system expectationsIdentify, document, and escalate data quality issues with root cause analysisMaintain data quality dashboards and SLA monitoringSupport UAT for new data sources or transformation logicBuild and maintain data transformations using Power Query, SQL, or Python as appropriateDevelop dimensional models and define aggregation logic aligned with analytics requirementsOptimize data structures for performance and maintainabilityDocument transformation logic, lineage, and assumptions per team standardsTroubleshoot pipeline failures and performance issues; coordinate resolution with IT/EngineeringRespond to data discrepancy reports from business users and analystsMaintain documentation of data sources, data dictionaries, and transformation specificationsSupport capacity planning and optimization of Fabric environments and pipelinesCollaborate with Lead to define semantic models and calculated metricsSkillsStrong SQL, ETL, and data quality skillsDesign and build extraction, transformation, and loading (ETL) pipelines using Microsoft Fabric (Dataflow Gen2, Notebooks, or equivalent tools)Write optimized SQL queries and transformations for data ingestion from designated source systemsApply data quality rules and validation logic at each pipeline stageImplement incremental loads and manage refresh schedules for performanceEscalate to Lead for architectural decisions or complex transformation patternsDefine and implement data quality checks at ingestion, transformation, and output stagesPerform ongoing data validation to ensure pipeline outputs align with business logic and source system expectationsIdentify, document, and escalate data quality issues with root cause analysisMaintain data quality dashboards and SLA monitoringSupport UAT for new data sources or transformation logicBuild and maintain data transformations using Power Query, SQL, or Python as appropriateDevelop dimensional models and define aggregation logic aligned with analytics requirementsOptimize data structures for performance and maintainabilityDocument transformation logic, lineage, and assumptions per team standardsTroubleshoot pipeline failures and performance issues; coordinate resolution with IT/EngineeringRespond to data discrepancy reports from business users and analystsMaintain documentation of data sources, data dictionaries, and transformation specificationsSupport capacity planning and optimization of Fabric environments and pipelinesCollaborate with Lead to define semantic models and calculated metricsAdvanced SQL — query optimization, window functions, performance tuning, debugging complex transformationsProficient with Microsoft Fabric — (Dataflow Gen2, Notebooks, Lakehouse) OR equivalent ETL tools (Python, dbt, Talend, Informatica)Strong understanding of relational database design and dimensional modelingPower Query / M — complex data shaping, merging, error handling, and transformation logicPython or similar scripting language — data manipulation, pipeline automationGit/version control basics — able to collaborate on code and track changesData quality and testing frameworks — unit tests, assertions, validation rulesAbility to interpret business requirements and design efficient data solutionsData governance mindset — understands data lineage, documentation, and quality standardsProactive about identifying edge cases and potential data issuesWorks effectively within defined standards and escalates architectural questions to LeadAble to balance speed with quality; advocates for technical excellenceMortgage/lending domain familiarity preferred; willingness to learn domain requiredCompany OverviewPartnerOne acquires and grows enterprise software companies for the long term. It was founded in 1995, and is headquartered in Montreal, Quebec, CAN, with a workforce of 201-500 employees. Its website is http://partnerone.com/.