Data Engineer, Data Migration & Integration Developer

πŸ•’ October 28

πŸ‡ΊπŸ‡Έ United States – Remote

⏰ Full Time

🟑 Mid-level

🟠 Senior

🚰 Data Engineer

Where this job comes from

Posted on Embrace Software Inc's careers page β†—Embrace Software Inc's careers page, not through a job board

First seen by Remote Rocketship October 28

Still open on Embrace Software Inc's site. Checked 2 hours ago.

Apply Now
Logo of Embrace Software Inc

Embrace Software Inc

201 - 500 employees

Founded 2021

πŸ’Ό Consulting

πŸ’Έ Finance

Consulting β€’ Software β€’ Finance

Embrace Software Inc. is a business investment company that specializes in acquiring and building world-class software businesses across various industrial sectors. With a focus on mission-critical software, Embrace aims to add value to its portfolio of companies, which range from small and medium-sized businesses to Fortune 500 firms. The company supports its acquired businesses by providing resources and operational expertise to foster growth and enhance customer satisfaction.

πŸ“‹ Description

β€’ Analyze source database schemas from relational and legacy database systems β€’ Understand table structures, relationships, constraints, data types, and dependencies β€’ Map source data structures to target schemas, including PostgreSQL and legacy platforms β€’ Identify data inconsistencies, missing values, duplicates, and migration challenges β€’ Translate business requirements into technical mapping and transformation rules β€’ Develop and maintain SQL queries, scripts, and ETL processes to extract, transform, and load data β€’ Maintain and enhance SQL-based staging and conversion processes β€’ Build reusable transformation scripts and migration utilities using SQL, Python, or other technologies β€’ 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 β€’ Leverage AI coding assistants for schema analysis, SQL generation, Python scripting, debugging, and documentation β€’ Review, validate, and optimize AI-generated code before execution β€’ Identify opportunities to automate mapping, validation, and migration activities β€’ Contribute to reusable AI-assisted migration workflows and internal tools while following data security policies β€’ Perform data profiling and quality assessments before migration β€’ Validate transformed data against source records and business rules β€’ Develop reconciliation queries to verify record counts, relationships, financial values, and data integrity β€’ Support test migrations, production migrations, and post-migration verification β€’ Ensure migration processes are accurate, repeatable, and recoverable β€’ Collaborate with customer-facing implementation, engineering, and database teams β€’ Document mappings, transformation logic, scripts, assumptions, and validation procedures β€’ Maintain reusable migration scripts and technical documentation in version control β€’ Support troubleshooting and continuous improvement of migration processes

🎯 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 β€’ 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

Apply Now

πŸ“Š Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Similar Jobs

πŸ•’ October 27

ICA, Inc.

51 - 200

πŸ₯ Healthcare

πŸ“¦ Logistics

πŸ“£ Marketing

Data Engineer building Python and SQL pipelines in AWS for ICA, a federal consulting and analytics company. Supporting dependable datasets for research, applications, and AI initiatives.

πŸ•’ October 27

Virtusa

10,000+ employees

πŸ’Ό Consulting

🏒 Enterprise

πŸ€– Artificial Intelligence

Tech Lead architecting secure Snowflake data platforms for pharmaceutical and life sciences analytics. Driving ETL/ELT, governance, compliance, DataOps, and engineering mentorship.

πŸ•’ October 27

Palmetto

201 - 500

⚑ Energy

πŸ’Έ Finance

Staff Data Engineer designing Palmetto’s governed data platform for home energy products and AI agents. Building secure pipelines, access interfaces, and trusted data products.

πŸ•’ October 27

Peraton

10,000+ employees

πŸ’Ό Consulting

πŸ₯ Healthcare

πŸ“¦ Logistics

Data Architect at Peraton building SQL, Tableau, and Python analytics for national security missions. Developing enterprise data warehouses, ETL workflows, dashboards, and reporting solutions.

πŸ•’ October 27

Mom's Meals | A Purfoods Company

501 - 1000

πŸ₯ Healthcare

πŸ“¦ Logistics

πŸ’Ό Consulting

Senior Data Engineer designing and operating Databricks, Azure, dbt, and Power BI platforms for Mom’s Meals’ home-delivered nutrition services. Leading reliable, secure healthcare data integrations and mentoring engineers.

Built byΒ Lior Neu-ner. I'd love to hear your feedback β€” Get in touch via DM or support@remoterocketship.com
Follow Remote Rocketship on LinkedInFollow Remote Rocketship on InstagramFollow Remote Rocketship on FacebookFollow Remote Rocketship on TikTok