**Important Information** Location: Peru, Colombia, Bolivia, Costa Rica or Argentina Work Mode: Remote **Job Summary** **Responsibilities and Duties** - Partner with Solution Architect to design and implement data models and database architecture: Lead the design and development of robust, scalable, and performant data models that support the client's business requirements, ensuring data integrity, quality, and accessibility across the entire project. - Develop and oversee data engineers as they implement change data capture (CDC) and data transformation workflows using tools such as Apache Airflow and AWS Glue - Develop and oversee the ETL processes, ensuring smooth data migration from SQL Server to PostgreSQL and Snowflake with mínimal downtime. - Ensure data quality and integrity: Implement data quality checks and validation procedures to ensure the accuracy, completeness, and consistency of data throughout the data lifecycle. Collaborate with the Data Governance Lead to establish and enforce data quality standards. **Qualifications and Skills** - 8+ years of experience in data architecture and database management, particularly with PostgreSQL (AWS Arora or Citus), Snowflake, and SQL Server. - Strong understanding of data warehousing concepts and techniques - Strong expertise in cloud-based architecture (preferably AWS) and experience with data migration to cloud-native solutions. - Hands-on experience with ETL tools and orchestration technologies such as AWS Glue, Apache Airflow, and dbt. - Proven experience implementing data governance and security measures within a complex data ecosystem. - Experience with data migration and transformation projects - AWS Architect Certified **Preferred Qualifications** - Familiarity with Citus and AWS Aurora for horizontal scaling of PostgreSQL or equivalent distributed database systems. - Experience with CDC technologies and real-time data streaming, such as Amazon Kinesis. - Strong understanding of data governance tools like DataHub and data validation frameworks like Great Expectations. **About Encora** Encora is a global company that offers Software and Digital Engineering solutions. Our practices include Cloud Services, Product Engineering & Application Modernization, Data & Analytics, Digital Experience & Design Services, DevSecOps, Cybersecurity, Quality Engineering, AI & LLM Engineering, among others. **At Encora, we hire professionals based solely on their skills and do not discriminate based on age, disability, religion, gender, sexual orientation, socioeconomic status, or nationality.