Senior Database, ETL Developer – PostgreSQL, Data Migration

πŸ•’ October 28

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

⏰ Full Time

🟑 Mid-level

🟠 Senior

πŸ“Š Analytics 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 52 minutes 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 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

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 26

University of the Cumberlands

201 - 500

πŸ“š Education

BI & Analytics Engineer owning University of the Cumberlands' Power BI reporting and Snowflake/dbt data models. Defining trusted metrics and semantic foundations for reporting and AI.

πŸ•’ October 24

EXL

10,000+ employees

πŸ₯ Healthcare

πŸ›‘οΈ Insurance

πŸ“¦ Logistics

Power BI developer building insurance dashboards and SQL reporting solutions. Translating insurance data into KPIs and actionable business insights.

πŸ•’ October 23

Rocket Money (formerly Truebill)

51 - 200

πŸ’Έ Finance

πŸ’³ Fintech

πŸ‘₯ B2C

Senior Analytics Engineer building scalable dbt and BigQuery models for Rocket Money’s personal finance platform. Improving data quality, governance, and stakeholder self-service analytics.

πŸ•’ October 23

Stord

501 - 1000

πŸ’Ό Consulting

🍽️ Food & Beverage

πŸ₯ Healthcare

BI Analytics Engineer building executive dashboards, financial reporting, and scalable analytics for Stord’s commerce-enablement and fulfillment platform. Turning complex business data into insights for leadership, investors, and the Board.

πŸ•’ October 23

Convene

501 - 1000

πŸ’Ό Consulting

πŸ“¦ Logistics

πŸ“£ Marketing

Analytics Engineer building trusted data products for Convene Hospitality Group’s hospitality destinations. Owning ingestion, dbt modeling, semantic layers, governance, and conversational analytics.

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