Database Developer (SQL)

Embrace Software Inc

United States

Remote

USD 110,000 - 160,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Embrace Legal Group is seeking a data migration and integration developer to design, build, and run migration solutions across diverse source systems and databases. You will analyze schemas, map data, and implement robust transformations using SQL, Python, and ETL techniques, with a focus on reliability and auditability.

You will collaborate with customer-facing implementation and internal engineering teams, validate data quality, and document mappings and procedures while embracing AI-assisted

Qualifications

  • 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 and at least two other database systems; Python scripting.
  • Experience using AI-assisted coding tools and ability to review AI-generated SQL and scripts.

Responsibilities

  • Analyze source database schemas, map to target schemas, and identify data quality issues.
  • Develop and maintain SQL queries, ETL processes, and data transformation routines.
  • Leverage AI-assisted development to speed schema analysis and script generation.
  • Test migrations, validate data against business rules, and document mappings.
  • Collaborate with implementation and engineering teams, maintain technical docs.

Skills

SQL
PostgreSQL
Python
ETL
Data migration
AI-assisted tools
Data profiling
Troubleshooting

Tools

ODBC
JDBC
ADS (Advantage Database Server)

Job description

This is a remote position. Embrace Legal Group is a trusted legal technology solutions provider within the Embrace portfolio of companies.

Position Overview

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.

Key Responsibilities
  1. 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.
  2. 2. Data Transformation & Migration Development 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.
  3. 3. AI‑Assisted Development & Automation 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.
  4. 4. Testing, Validation & Data Quality 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.
  5. 5. Collaboration & Documentation 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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Database Engineer
Database Engineer

Changeis, Inc. • United States

On-site
USD 110,000 - 150,000
Remote SQL Data Migration Specialist (AI Tools)
Remote SQL Data Migration Specialist (AI Tools)

Embrace Software Inc • United States

Remote
USD 110,000 - 160,000
Database Consultant - REMOTE
Database Consultant - REMOTE

Fortified Data • Raleigh (NC)

Remote
USD 90,000 - 130,000
Data Engineering Solution Lead
Data Engineering Solution Lead

Jobgether • United States

Remote
USD 105,000 - 155,000
Remote work
Medical, dental, and vision insurance
401(k) retirement plan with company •?
+4
Database Administrator
Database Administrator

UNAVAILABLE • McLean (VA)

On-site
USD 90,000 - 140,000
Senior Database Architect (SQL Server & PostgreSQL) - B2B / Freelancers
Senior Database Architect (SQL Server & PostgreSQL) - B2B / Freelancers

xebiacee • United States

Remote
USD 120,000 - 180,000
Remote work in EU-based setup
Senior Data Engineer - 1018994
Senior Data Engineer - 1018994

Dexian • Covington (KY)

On-site
USD 120,000 - 160,000
Database Analyst
Database Analyst

Delan Associates, Inc • Florida

On-site
USD 85,000 - 120,000
Senior Developer, Data Migration
Senior Developer, Data Migration

Calliere • United States

Remote
USD 120,000 - 180,000
Job Title SQL Developer / Data Migration Specialist
Job Title SQL Developer / Data Migration Specialist

Communitybrands • United States

Remote
USD 90,000 - 130,000
Remote work flexibility
Health, dental and vision coverage
Matched retirement savings plan