Important Information
Location: Peru, Colombia, Bolivia, Costa Rica or Argentina
Work Mode: Remote
Job Summary
As a Senior Data Architect (14992), you will be responsible for designing, developing, and maintaining high-quality software solutions. You will collaborate with cross-functional teams to understand business requirements and translate them into scalable and efficient software applications. Your role will involve leading technical projects, mentoring junior engineers, and continuously improving software development practices to ensure the delivery of robust and reliable software systems.
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 minimal 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.
