Principal Data Engineer

Aspire Inc.

United States

1 day ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Temporary contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Application Programming Interfaces (APIs) Amazon Web Services Amazon S3 Databases Continuous Integration Data Architecture Data Governance DevOps PostgreSQL Metadata Metadata Repositories Microsoft SQL Server

+9 more

Performance Tuning Migration Manager SQL Databases Indexer Event Driven Architecture AWS Aurora Terraform Databricks Microservices

Job description

Lead enterprise data architecture, modeling, database modernization, and migration, with a focus on SQL Server to Amazon Aurora PostgreSQL. Own strategy while providing hands-on technical leadership across assessment, migration, validation, and stabilization., * Define enterprise data/database architecture, standards, models, and target-state strategy.

Lead SQL Server * PostgreSQL/Aurora PostgreSQL migration planning and execution.
Drive schema conversion, stored code remediation, CDC, reconciliation, cutover, rollback, and validation.
Establish database DevOps, IaC, schema-as-code, governance, security, and performance standards.
Optimize indexing, queries, partitioning, connections, and workloads.
Lead and mentor cross-functional teams and communicate architecture decisions, risks, and trade-offs.

Requirements

Strong enterprise data/database architecture and data modeling experience.
Proven SQL Server to PostgreSQL/Aurora PostgreSQL migration experience.
Expertise in SQL Server & PostgreSQL internals, SQL, performance tuning, indexing, transactions, and locking.
Hands-on AWS Aurora PostgreSQL, AWS DMS, and AWS Schema Conversion Tool experience.
Experience with ER/Studio, data governance, metadata, lineage, quality, security, and resilience.
Strong technical leadership and stakeholder management skills.

Desired

Databricks, S3, Lakehouse/Medallion, Data Catalogs
CI/CD, Terraform, Database DevOps
Microservices, APIs, event-driven architecture
Experience in energy, trading, retail, financial services, or regulated environments., All applicants must submit accurate information; misrepresentation may disqualify candidacy.