Data Architect

CTC; Michigan; A distancia; USD 110.000 - 170.000; A tiempo parcial

Descripción de la vacante

CTC seeks an experienced Data Architect to design scalable cloud-based data solutions, enabling enterprise analytics, reporting, and governance. You will shape data architecture across ERP interfaces, data warehouses, and lakehouses, ensuring robust data flows and governance.

The role emphasizes advanced SQL, data modeling, ETL/ELT design, and collaboration with engineering and business teams to deliver secure, scalable data platforms on AWS/Azure/GCP. This is a remote USA contract position.

Formación

• Design and implement enterprise data and cloud architecture solutions with a focus on scalability and governance.
• Develop scalable data models, integration frameworks, and data pipelines for analytics."
• Architect data warehouse and lakehouse environments supporting reporting and dashboards.

Responsabilidades

• Design and implement enterprise data and cloud architecture solutions.
• Develop scalable data models, integration frameworks, and data pipelines.
• Architect data warehouse and lakehouse environments for analytics and reporting.
• Define data integration strategies across ERP, operational, and reporting systems.
• Collaborate with engineering, governance, and business teams to ensure data consistency and accessibility.
• Establish best practices for data lineage, security, performance, and scalability.
• Support source-system analysis, data migration, and modernization initiatives.

Conocimientos

Data Architecture

Cloud Architecture

SQL

Data Modeling

ETL/ELT

Data Integration

Data Warehouse & Lakehouse

Stakeholder Management

APIs & Source-System Analysis

Herramientas

Snowflake

Databricks

AWS

Azure

GCP

Informatica

dbt

ERwin/IDERA

SQL tooling

Descripción del empleo

Data Architect

Role: Data Architect
Location: Remote (USA)
Duration: Contract

Job Summary

We are seeking an experienced Data Architect to design and implement scalable cloud-based data solutions that support enterprise analytics, reporting, and governance initiatives. The ideal candidate will have strong expertise in data architecture, cloud platforms, data modeling, SQL, and modern data engineering practices. Experience designing data flows between ERP systems, data warehouses/lakehouses, and reporting platforms is highly preferred.

Key Responsibilities

• Design and implement enterprise data and cloud architecture solutions.
• Develop scalable data models, integration frameworks, and data pipelines.
• Architect data warehouse and lakehouse environments for analytics and reporting.
• Define data integration strategies across ERP, operational, and reporting systems.
• Collaborate with engineering, governance, and business teams to ensure data consistency and accessibility.
• Establish best practices for data lineage, security, performance, and scalability.
• Support source-system analysis, data migration, and modernization initiatives.

Required Skills

• Strong experience in Data Architecture and Cloud Architecture
• Advanced SQL skills for data analysis, modeling, and optimization
• Expertise in Data Modeling (Conceptual, Logical, and Physical)
• Experience with ETL/ELT design and implementation
• Strong knowledge of data integration, APIs, and source-system analysis
• Experience designing Data Warehouse and Lakehouse architectures
• Understanding of financial data flows, reporting processes, and data lineage
• Strong stakeholder management and solution design skills

Preferred / Strong Differentiator

• Experience designing end-to-end architectures connecting ERP Data Warehouse/Lakehouse Reporting & Analytics Platforms
• Experience supporting financial reporting and enterprise data transformation initiatives

Tools & Technologies

• Snowflake
• Databricks
• AWS / Azure / GCP
• Informatica
• dbt
• ERwin / IDERA
• SQL