Sr Principal Data Engineer

Role: Principal Data Engineer
Location: Remote
Duration: 6 months

Position Overview:
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.

Key Responsibilities

• 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.

Essential Skills

• 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.