Database Developer (SQL)
Embrace Software Inc.
A complete application in a minute
Tailored resume and cover letter, ready to send.
Job summary
Embrace Software Inc. is seeking a hands-on Data Migration & Integration Developer to design, develop, and execute data migration solutions across diverse source systems into enterprise applications.
You will work with PostgreSQL and legacy platforms, applying SQL, Python, and AI-assisted tools to accelerate schema analysis, transformation development, and documentation. The role involves analyzing unfamiliar database schemas, creating reliable migration transformations, and collaborating with
Qualifications
- Significant hands-on data migration/ETL experience.
- Strong SQL (complex joins, stored procedures) and data mapping skills.
- Experience with PostgreSQL and multiple other DB systems.
- Proficiency with Python for transformation tasks.
- Familiarity with AI-assisted coding tools and code review practices.
Responsibilities
- Analyze source schemas from relational/legacy databases and map to target schemas.
- Develop SQL scripts, ETL processes, and migration utilities.
- Create AI-assisted migration workflows and reusable components.
- Validate migrated data with source records and business rules.
- Troubleshoot migrations, optimize performance, and ensure data quality.
- Document mappings, logic, and validation procedures.
Skills
Tools
Job description
We're rebuilding vertical software with AI — from the inside.
Embrace owns the software running inside 16% of the Fortune 500, 45+ state agencies, and 450+ banks and credit unions. We acquire entrenched vertical software businesses and rebuild them around AI — products, operations, go-to-market, all of it. Our Venture Lab launches new AI-native products into those same markets, using the distribution and customer relationships our portfolio already owns.
You'll ship AI into production against real workflows, real customers, and a P&L you can see move within a quarter.
We hire people who want scope, speed, and ownership, and who are tired of working on AI that never reaches a customer. If you want to spend the next five years shipping into software that already runs the economy, talk to us.
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.
- 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.
- 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.
- Competitive salary commensurate with experience.
- Opportunities for career advancement and professional development.
- Experience collaborating with a diverse, global team within a remote work setting.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
