Job Description We are seeking a Senior Data Architect to join our team at Encora Inc. - You will design, develop, and maintain high-quality software solutions that meet the business requirements of our clients. - You will collaborate with cross-functional teams to understand business needs and translate them into scalable and efficient software applications. - You will lead technical projects, mentor junior engineers, and continuously improve software development practices to ensure the delivery of robust and reliable software systems. Responsibilities - 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. - Ensure 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 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.