Develop and execute database migration and integration solutions across relational and legacy systems. Analyze schemas, map source data to target databases, build SQL and Python ETL transformations, validate data quality, reconcile migrations, troubleshoot failures, and optimize large-scale processes. Use AI-assisted development tools responsibly to accelerate coding and documentation. Collaborate with implementation and engineering teams while maintaining reusable scripts, documentation, and reliable migration workflows.
This is a remote position.
Embrace Legal Group is a trusted legal technology solutions provider within the Embrace portfolio of companies.
We are seeking an experienced, hands-on Data Migration & Integration Developer to design, develop, and execute data migration solutions from various source systems into our enterprise applications, including modern relational databases and legacy database platforms.
The ideal candidate will have strong SQL, database analysis, data mapping, and scripting skills, along with the ability to leverage AI-assisted development tools to accelerate schema analysis, transformation development, troubleshooting, and documentation.
Source databases may vary significantly across customers, so the candidate must be comfortable working with unfamiliar database structures, understanding relationships, identifying data quality issues, and developing reliable transformation processes across different database platforms.
This is a technical, hands-on role that will work closely with our customer-facing implementation team and internal engineering team.
1. Database Analysis & Data Mapping
- Analyze source database schemas from a variety of relational and legacy database systems.
- Understand table structures, relationships, constraints, data types, and dependencies.
- Map source data structures to target database schemas, including PostgreSQL and legacy database platforms.
- Identify data inconsistencies, missing values, duplicates, and potential migration challenges.
- Translate documented business requirements into technical mapping and transformation rules.
- Work with internal stakeholders to clarify mapping requirements and resolve technical gaps.
- Develop and maintain SQL queries, scripts, and ETL processes to extract, transform, and load data across different database platforms.
- Learn, maintain, and enhance existing SQL-based staging and conversion processes used for external system data migrations.
- Build reusable transformation scripts and migration utilities using SQL, Python, or other appropriate technologies.
- Handle complex transformations involving multiple tables, relationships, data formats, and business rules.
- Implement data validation, reconciliation, error handling, and logging.
- Troubleshoot migration failures, performance issues, and data discrepancies.
- Optimize migration processes for large datasets and complex database structures.
- Actively leverage AI coding assistants to improve the speed and efficiency of data mapping, transformation, and migration development.
- Use AI tools to assist with source schema analysis, SQL generation, Python scripting, debugging, and documentation.
- Independently review, validate, and optimize AI-generated code before execution.
- Identify opportunities to automate repetitive mapping, validation, and migration activities.
- Contribute to building reusable AI-assisted migration workflows and internal tools.
- Follow company data security policies, ensuring customer data is not exposed to unauthorized external AI services.
- Perform data profiling and quality assessments before migration.
- Validate transformed data against source records and documented business rules.
- Develop reconciliation queries to verify record counts, relationships, financial values, and data integrity.
- Identify and resolve data conversion errors before production migration.
- Support test migrations, production migrations, and post-migration verification.
- Ensure migration processes are accurate, repeatable, and recoverable.
- Work with the customer-facing implementation team to receive source schemas, requirements, and business rules.
- Collaborate with engineering and database teams to understand destination database structures and conversion requirements.
- Document source-to-target mappings, transformation logic, scripts, assumptions, and validation procedures.
- Maintain reusable migration scripts and technical documentation in version control.
- Support troubleshooting and continuous improvement of existing migration processes.
- Reduce dependency on individual team members by creating standardized and well-documented migration solutions.
Requirements
- 4–7 years of hands-on experience in database development, data migration, ETL, or data integration.
- Strong proficiency in SQL, including complex joins, subqueries, stored procedures, and query optimization.
- Practical experience with PostgreSQL.
- Experience working with at least two other database systems, such as SQL Server, MySQL, Oracle, DB2, or legacy relational databases.
- Experience analyzing unfamiliar database schemas and identifying relationships between tables.
- Hands-on experience developing data transformation and migration scripts using Python and SQL.
- Experience handling large datasets, data quality issues, and complex business transformation rules.
- Familiarity with ETL concepts, data validation, reconciliation, and migration best practices.
- Experience using AI-assisted coding tools such as ChatGPT, Claude, GitHub Copilot, or similar tools.
- Ability to independently evaluate and correct AI-generated SQL and scripts.
- Strong troubleshooting, analytical, and problem-solving skills.
- Good written communication and technical documentation skills.
- Ability to work independently in a remote environment and collaborate with distributed teams.
Preferred Qualifications
- Familiarity with Advantage Database Server (ADS) is a plus, but not required.
- Experience with SQL-based staging databases and intermediate data transformation processes.
- Experience building reusable ETL frameworks or automated migration utilities.
- Familiarity with database connectivity technologies such as ODBC and JDBC.
- Experience with AI-assisted workflow automation and scripting.
- Knowledge of PostgreSQL performance tuning, indexing, and bulk-loading techniques.
Benefits
- Competitive salary commensurate with experience.
- Opportunities for career advancement and professional development.
- Experience collaborating with a diverse, global team within a remote work setting.
Similar Jobs
Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
The Finance Business Partnership Manager supports practice groups and growth teams through forecasting, profitability analysis, pricing and discount analysis, KPI development, dashboard reporting, and business case support. The role leads monthly financial reviews, partners with data and accounting teams, improves reporting standards, supports planning and staffing decisions, and translates financial insights into operating actions for non-finance leaders.
Artificial Intelligence • Fintech • Machine Learning • Mobile • Payments • Retail • Software
Own a mixed portfolio of grocery retailer accounts, managing onboarding, retention, expansion, account health, and long-term partnerships. Deliver data-driven account reviews, interpret performance data, identify churn risks, and tailor high-touch or scaled engagement models by account value. Collaborate with analytics, product, marketing, and operations teams to improve retailer outcomes. The role also requires public speaking, project management, creative problem-solving, and travel of up to 20%.
Cloud • Fintech • Food • Information Technology • Software • Hospitality
Lead Toast’s lending product strategy and roadmap, including Toast Capital and Easy Pay. Partner with engineering, design, data science, credit, legal, finance, marketing, and external financial partners to develop, launch, and optimize B2B financial products. Responsibilities include defining requirements, managing backlogs, facilitating agile ceremonies, building business cases, gathering customer feedback, and measuring product outcomes.
Top Skills:
SQL
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
