{"schemaVersion":"jobsearcher.job.v1","id":"0199fa004571e4cd21b730fa","url":"https://jobsearcher.com/jobs/0199fa004571e4cd21b730fa","canonicalUrl":"https://jobsearcher.com/jobs/0199fa004571e4cd21b730fa","title":"Data Architect, Client Integrations & Migrations (Remote)","description":"Data Architect, Client Integrations & MigrationsLocation: Remote (US) – 9-5 ESTDuration: 6+ months plus extension or conversionOwns the integrity and design of the data model underneath P3's multi-tenant configuration system — ID allocation, database migration safety, and cross-program data consistency — and personally runs data migrations when onboarding clients moving off a legacy system. Client-facing on data specifically: sits directly with manufacturer stakeholders to work out how their data gets migrated or extracted, rather than designing the pipeline from secondhand requirements.Key Responsibilities:Own ID allocation strategy and the safeguards that prevent ID collisions and protect already-deployed database migrations from being silently rewritten.Design and review database migrations generated by the configuration compiler for correctness and safety before they reach production.Catch and resolve data-identity drift (e.g., mismatched entity IDs across environments) before it becomes a production incident.Design and run one-off ETL/data-migration pipelines for new client onboarding, mapping legacy client data into the platform's schema.Work directly with manufacturer stakeholders and their technical/IT contacts to scope how existing data gets migrated or extracted — including feeding an external analytics system or integrating with a remote/third-party CRM the manufacturer uses — and turn that into a concrete plan.Partner with the Staff Configuration Platform Engineer on the shared data-model contract between the compiler and the production Education and Experience:Bachelor’s degree required.Strong relational data modeling background, with production-scale PostgreSQL (or equivalent) experience.Hands-on EF Core (or equivalent ORM) migration experience in a multi-tenant system.Real ETL/data-migration experience — designing and running one-off legacy-to-new-schema pipelines, not just steady-state data modeling.Experience with ID/key allocation strategy in a distributed or multi-tenant system.Direct client-facing experience scoping data migration, extraction, or integration work with an external party — able to run that conversation with a manufacturer's IT/data team, understand their constraints (what an analytics system needs, what a remote CRM's API supports), and turn it into an executable plan without an intermediary Qualifications:Healthcare data experience (HIPAA-aware handling of PHI) strongly preferred.Target industries: Healthcare, Healthcare Insurance.Soft Skills:People who are proud of the work they do.Individuals who love solving problems.Consulting backgrounds are great.High IQ.Curious and inquisitive.People who have side passion projects related to the field.People with an AI FIRST mindset.People who have a systems mindset.“10x Software/Platform Engineers” – folks that are highly productive because they automate where they can and use AI to solve problems faster.Skills:Strong relational data modeling with production-scale PostgreSQL (or equivalent). - Required - YearsHands-on EF Core (or equivalent ORM) migration experience in a multi-tenant system. - Required - YearsReal ETL/data-migration experience – one-off legacy-to-new-schema pipelines. - Required - YearsExperience designing data pipelines from scratch. - Required - YearsExperience with ID/key allocation strategy in a distributed or multi-tenant system. - Required - YearsDirect client-facing experience scoping data migration, extraction, or integration work with an external party. - Required - YearsSQL scripting skills. - Required - YearsExperience architecting complex workflows. - Required - YearsMS stack –.NET, SQL Databases, NodeJS. - Required - YearsClause AI First Approach (AI-first development, per the intake form). - Required - YearsBachelor’s degree. - Required - –Healthcare data experience (HIPAA-aware handling of PHI). - Desired","company":"Serigor","rawCompany":"serigor","city":"Brooklyn","state":"NY","isRemote":true,"isActive":false,"createdAt":"2026-09-11T06:35:12.501Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1242.00","title":"Database Administrators","slug":"database-administrators"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"541519","title":"Other Computer Related Services","slug":"other-computer-related-services"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Data Architect, Client Integrations & Migrations (Remote)","description":"Data Architect, Client Integrations & MigrationsLocation: Remote (US) – 9-5 ESTDuration: 6+ months plus extension or conversionOwns the integrity and design of the data model underneath P3's multi-tenant configuration system — ID allocation, database migration safety, and cross-program data consistency — and personally runs data migrations when onboarding clients moving off a legacy system. Client-facing on data specifically: sits directly with manufacturer stakeholders to work out how their data gets migrated or extracted, rather than designing the pipeline from secondhand requirements.Key Responsibilities:Own ID allocation strategy and the safeguards that prevent ID collisions and protect already-deployed database migrations from being silently rewritten.Design and review database migrations generated by the configuration compiler for correctness and safety before they reach production.Catch and resolve data-identity drift (e.g., mismatched entity IDs across environments) before it becomes a production incident.Design and run one-off ETL/data-migration pipelines for new client onboarding, mapping legacy client data into the platform's schema.Work directly with manufacturer stakeholders and their technical/IT contacts to scope how existing data gets migrated or extracted — including feeding an external analytics system or integrating with a remote/third-party CRM the manufacturer uses — and turn that into a concrete plan.Partner with the Staff Configuration Platform Engineer on the shared data-model contract between the compiler and the production Education and Experience:Bachelor’s degree required.Strong relational data modeling background, with production-scale PostgreSQL (or equivalent) experience.Hands-on EF Core (or equivalent ORM) migration experience in a multi-tenant system.Real ETL/data-migration experience — designing and running one-off legacy-to-new-schema pipelines, not just steady-state data modeling.Experience with ID/key allocation strategy in a distributed or multi-tenant system.Direct client-facing experience scoping data migration, extraction, or integration work with an external party — able to run that conversation with a manufacturer's IT/data team, understand their constraints (what an analytics system needs, what a remote CRM's API supports), and turn it into an executable plan without an intermediary Qualifications:Healthcare data experience (HIPAA-aware handling of PHI) strongly preferred.Target industries: Healthcare, Healthcare Insurance.Soft Skills:People who are proud of the work they do.Individuals who love solving problems.Consulting backgrounds are great.High IQ.Curious and inquisitive.People who have side passion projects related to the field.People with an AI FIRST mindset.People who have a systems mindset.“10x Software/Platform Engineers” – folks that are highly productive because they automate where they can and use AI to solve problems faster.Skills:Strong relational data modeling with production-scale PostgreSQL (or equivalent). - Required - YearsHands-on EF Core (or equivalent ORM) migration experience in a multi-tenant system. - Required - YearsReal ETL/data-migration experience – one-off legacy-to-new-schema pipelines. - Required - YearsExperience designing data pipelines from scratch. - Required - YearsExperience with ID/key allocation strategy in a distributed or multi-tenant system. - Required - YearsDirect client-facing experience scoping data migration, extraction, or integration work with an external party. - Required - YearsSQL scripting skills. - Required - YearsExperience architecting complex workflows. - Required - YearsMS stack –.NET, SQL Databases, NodeJS. - Required - YearsClause AI First Approach (AI-first development, per the intake form). - Required - YearsBachelor’s degree. - Required - –Healthcare data experience (HIPAA-aware handling of PHI). - Desired","datePosted":"2026-09-11T06:35:12.501Z","dateModified":"2026-09-11T06:35:12.501Z","hiringOrganization":{"@type":"Organization","name":"Serigor","sameAs":"https://jobsearcher.com"},"jobLocationType":"TELECOMMUTE","applicantLocationRequirements":{"@type":"Country","name":"US"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Brooklyn","addressRegion":"NY","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"0199fa004571e4cd21b730fa"},"url":"https://jobsearcher.com/jobs/0199fa004571e4cd21b730fa"}}