Data Architect

Important Information

Location: PAN India

Experience: 15+ Years

Job Mode: Full-time

Work Mode: Work from home

Job Summary

We are seeking a seasoned Data Architect to design data models and database architecture for a long-term data modernization project. The ideal candidate will bring a strong background in data architecture and extensive experience in managing complex data migration and transformation projects. In this role, you will be responsible for ensuring data integrity, quality, and accessibility, and will oversee data migration strategies. Collaborating closely with the Solution Architect and Data Engineers, you will implement efficient data solutions aligned with project goals, focusing on migrating from fragmented legacy systems to an integrated data environment using open-source technologies and cloud-native solutions. This is a unique opportunity to work on high-impact projects that reshape how enterprises harness and leverage their data to unlock transformative insights.

Responsibilities and Duties

Data Architecture & Modeling:

• 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.
• Oversee data migration strategies: Develop and oversee the execution of comprehensive data migration strategies, ensuring a smooth transition from legacy systems to the new data platform, working closely with data engineers to implement the migration plan and address any challenges
  
  

Data Migration & ETL:

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

Data Governance & Security:

• 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.
• Collaborate with the client on role-based access controls and audit trails to ensure data privacy and regulatory adherence.
  
  

Collaboration & Communication:

• Collaborate with cross-functional teams: Work closely with the Solution Architect to ensure alignment between the overall data platform architecture and the specific data models and database implementations. Collaborate effectively with Data Engineers to ensure efficient implementation of data solutions and participate in technical discussions and decision-making processes.
• Facilitate knowledge transfer and provide technical guidance to client's in-house data engineering team.
  
  

Optimization & Performance Tuning:

• Conduct performance tuning for PostgreSQL (e.g. AWS Aurora) and Snowflake to enhance scalability, efficiency, and cost-effectiveness.
• Assist in decommissioning legacy SQL Server systems while ensuring data integrity and continuity.
  
  

Required Qualifications

• 10+ 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 architectures (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
  
  

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.
  
  

Soft Skills

• Exceptional problem-solving skills with a proactive approach to identifying and mitigating risks.
• Strong collaboration and communication skills, capable of engaging with stakeholders and guiding cross-functional teams.
• Proven ability to work within agile teams and collaborate across different time zones.
• Detail-oriented with a focus on maintaining data quality, integrity, and security.
  
  

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.