IT Architect - Data

Job Description:

We are seeking an experienced Data Architect to design, build, and optimize scalable data solutions. The ideal candidate will have deep expertise in AWS Glue, ETL pipelines/Tools (like Talend), EDI interfaces, SQL, data modeling, and data analysis, ensuring efficient data processing and integration across various platforms.

Key Responsibilities:

• Architect and implement data solutions using AWS Glue and other AWS services.
• Understand requirements, design and optimize ETL (Extract, Transform, Load) pipelines to support data ingestion, transformation, and integration.
• Develop and maintain data models for structured and semi-structured data, ensuring scalability and performance.
• Write, optimize, and manage SQL queries and stored procedures for data processing and analytics.
• Conduct data analysis to support business intelligence and decision-making.
• Ensure data quality, governance, and security best practices are followed.
• Collaborate with data engineers, analysts, and business stakeholders to define data requirements and architecture.
• Monitor and troubleshoot data pipelines to maintain system reliability and performance.
• Review work products, provide guidance to data integration developers, analysts.
• Interface with onshore architects, customers to provide solution overview and estimates.

Required Skills Qualifications:

• 10+ years of experience in data architecture, data engineering, or a related field.
• Strong expertise in AWS Glue, AWS Lambda, AWS S3, AWS IAM, and other AWS data services.
• Hands-on experience with ETL development and data pipeline orchestration.
• Proficiency in SQL and database technologies such as PostgreSQL, MySQL, Redshift, or Snowflake.
• Solid understanding of data modeling (relational and dimensional) and schema design.
• Experience with Python or Scala for data transformation and automation.
• Knowledge of data governance, security, and compliance best practices.
• Strong problem-solving skills and ability to work in a fast-paced, agile environment.

Preferred Qualifications:

• Exposure to machine learning pipelines and data lake architectures.
• Experience with Talend Data Integration
• AWS Certifications such as AWS Certified Data Analytics-Specialty or AWS Certified Solutions Architect
• Exposure to Azure Data Integration technologies