Job description
Important Information:
Years of Experience: 10+ years
Job Mode: Full-time
Work Mode: Remote
Job Summary:
We are seeking a highly experienced Senior Data Architect to lead the design and implementation of data models and database architecture for a long-term data modernization initiative. This role will focus on migrating fragmented legacy systems to an integrated, cloud-native environment using open-source technologies. You will play a central role in ensuring data quality, performance, and accessibility, while collaborating closely with Solution Architects, Data Engineers, and other cross-functional teams. This is a high-impact opportunity to shape the way enterprise clients leverage their data for transformative business outcomes.
Responsibilities and Duties:
Design scalable and performant data models aligned with business requirements
Collaborate with Solution Architects to ensure alignment with the broader data platform architecture
Ensure data quality, consistency, and accessibility across the solution lifecycle
Lead data migration strategies from legacy systems to modern platforms
Oversee the development and execution of ETL pipelines using tools such as AWS Glue, Apache Airflow, and dbt
Guide data engineers in implementing change data capture (CDC) and transformation workflows
Implement data validation, quality checks, and enforce data governance standards
Collaborate with clients to define and apply role-based access controls and audit mechanisms
Facilitate knowledge transfer to client’s in-house engineering teams
Actively participate in technical discussions and decision-making with cross-functional teams
Provide guidance and mentorship to data engineers throughout the implementation process
Optimize PostgreSQL (e.g. AWS Aurora) and Snowflake environments for performance and cost
Lead decommissioning efforts for legacy SQL Server systems while ensuring data integrity
Qualifications and Skills:
Minimum 10 years of experience in data architecture and data engineering roles
Strong background in database design and development using PostgreSQL (Aurora or Citus), Snowflake, and SQL Server
Expertise in data warehousing concepts and modern data architecture patterns
Hands-on experience in cloud-native environments, preferably AWS
Proven ability to implement enterprise-grade data governance and security measures
Experience with complex data migration and transformation projects
Role-specific Requirements:
Demonstrated leadership in overseeing large-scale data modernization efforts
Experience working with cross-functional stakeholders across different time zones
Detail-oriented and proactive in mitigating data quality and migration risks
Technologies:
PostgreSQL (AWS Aurora or Citus)
Snowflake
SQL Server
AWS Glue
Apache Airflow
dbt
Amazon Kinesis (preferred)
DataHub (preferred)
Great Expectations (preferred)
Skillset Competencies:
Data modeling and architecture
Cloud-native solution design
Data migration strategy and execution
ETL pipeline development
Data governance and access control
Performance tuning and optimization
Technical leadership and cross-functional collaboration
About Encora
Encora is the preferred digital engineering and modernization partner of some of the world’s leading enterprises and digital native companies. With over 9,000 experts in 47+ offices and innovation labs worldwide, Encora’s technology practices include Product Engineering & Development, Cloud Services, Quality Engineering, DevSecOps, Data & Analytics, Digital Experience, Cybersecurity, and AI & LLM Engineering.
At Encora, we hire professionals based solely on their skills and qualifications, and do not discriminate based on age, disability, religion, gender, sexual orientation, socioeconomic status, or nationality.
