Data Platform Architect

Job Title: Data Architect

Location: Remote, US

Mode: Contract - W2

Job Summary:

We are looking for a Data Engineer with strong experience in Snowflake, Matillion, Talend, and Advanced SQL to develop, troubleshoot, and optimize data integration and transformation pipelines. The ideal candidate will have hands-on experience resolving data quality issues and delivering reliable, scalable data solutions.

Key Responsibilities:

• Develop and maintain ETL/ELT data pipelines using Matillion and Talend.

• Design and optimize data solutions using Snowflake and advanced SQL.

• Perform data transformation, mapping, cleansing, and validation across multiple data sources.

• Diagnose and resolve Data Quality & Control Issues (DQCI) across ingestion, integration, and consumption layers.

• Identify root causes of data defects and implement sustainable fixes at the appropriate layer.

• Integrate data through REST APIs and other enterprise data sources .

• Improve pipeline performance, reliability, scalability, and data accuracy.

• Monitor data pipelines and troubleshoot failures, performance issues, and data discrepancies.

• Collaborate with business, data, and application teams to understand data requirements.

• Use Azure DevOps for source control, work tracking, CI/CD, and deployment activities.

• Document data mappings, transformation logic, remediation solutions, and technical processes.

Required Skills:

• Strong hands-on experience with Snowflake Development
• Matillion ETL/ELT
• Talend Data Integration
• Advanced SQL
• ETL/ELT and Data Pipeline Development
• Data Transformation & Mapping
• API Integration
• Data Quality, validation, and remediation
• Azure DevOps
• Strong troubleshooting and root-cause analysis skills.