Senior Database, ETL Developer – PostgreSQL, Data Migration

🕒 5 days ago

🇺🇸 United States – Remote

⏰ Full Time

🟠 Senior

📊 Analytics Engineer

👻 Ghost score 25%

What it means: the chance that no one is really hiring for this job.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Embrace Software Inc

WebsiteLinkedInAll Job Openings

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 across database platforms • 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 • 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 • Document mappings, transformation logic, scripts, assumptions, and validation procedures • Collaborate with customer-facing implementation, engineering, and database teams • 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

📊 Check your resume score for this job

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

Upload Resume