Data Architect

**We’re Hiring: Data Architect**
**Bogotá, Colombia | Hybrid**

**Who We Are**:
Our Bogotá tech hub works closely with teams across North America, Europe, and Asia to evolve our **Freight Operating System**, enabling smarter, faster, and more reliable logistics operations.

We foster a fast-paced, inclusive environment where **innovation, ownership, and problem-solving** thrive—and where data plays a critical role in shaping the future of logistics.

**Job Summary**:
We are seeking a **Data Architect** to define, stabilize, and evolve our **enterprise data architecture** across legacy platforms and next-generation cloud systems.
This is a **strategic and hands-on role**, responsible for designing scalable and well-governed data models, leading modernization initiatives, supporting production stabilization, and enabling **analytics, AI, and vector-based workloads**.

You will serve as the **technical authority for data architecture**, working closely with data engineers, DBAs, BI teams, and IT to ensure data integrity, performance, observability, and long-term sustainability across **Cortex and related platforms**.

**Core Responsibilities**:
**1. Data Strategy & Architecture**:

- Define enterprise-level data architecture for Cortex and related platforms.
- Design scalable, secure, and well-governed schemas, evolving from MVP designs to long-term maintainable models.
- Own and enforce data modeling standards across the organization.
- Guide the evolution of hybrid **on-prem and cloud** data platforms.
- Act as the architectural authority for data design (not a purely operational role).

**2. Data Modeling**:

- Lead hands-on data modeling, including:

- Relational and non-relational modeling
- Dimensional modeling (star / snowflake)
- **Data Vault modeling** (DBT + Data Vault patterns)
- Modernize legacy data models into cloud-ready architectures.
- Align models with **domain-driven design** in collaboration with Solution Architects.

**3. Platform Stabilization (Short-Medium Term)**:

- Support and improve existing production data platforms—not only greenfield initiatives.
- Provide architectural guidance to reduce:

- Production failures
- Duplicate records
- Data merge anomalies
- Partner closely with production support and data engineering teams while maintaining a long-term architectural vision.

**4. Data Pipelines & ETL**:

- Design and oversee reliable, observable, and governed **ETL / ELT pipelines**.
- Lead migration from legacy **SSIS** pipelines to modern frameworks.
- Hands-on experience with:

- **DBT**:

- Batch and incremental pipelines
- Integrate multiple data sources, including TMS, CargoWise, finance systems, collaboration telemetry, and external operational feeds.
- Support CI/CD for data pipelines using **Azure DevOps**.

**Technologies & Platforms**:
**Core & Hybrid Platforms**
- Microsoft SQL Server (2019): SSMS, SSIS, SSRS
- Hybrid architectures integrating on-prem SQL Server with cloud platforms

**Cloud & Azure Stack**
- Microsoft Azure
- Microsoft Fabric
- Power BI
- Azure DevOps
- Strong understanding of cloud data warehouse design

**Databases & Storage**
- PostgreSQL (explicit requirement for Cortex)
- Supabase (PostgreSQL-based)

**Vector & AI-Ready Data Stores (mandatory)**
- Pinecone, Weaviate, PostgreSQL + pgvector
- Schema design for embeddings, vector search, RAG, and semantic workloads

**Governance, Security & Observability**
- RBAC, environment isolation, compliance-ready architectures (SOC 2, ISO 27001, GDPR principles)
- Monitoring standards for pipelines, data quality, failures, and anomalies

**Collaboration & Leadership**:

- Act as the **data lead within Engineering**, not an IT-only DBA role.
- Provide architectural guidance to DBAs, data engineers, and BI teams.
- Bridge Engineering, IT, DevOps, Security, and Analytics.
- Drive documentation of data models, pipelines, migrations, lineage, and standards.

** Qualifications**:

- Bachelor’s or Master’s degree in Computer Science, Data Engineering, or related field.
- **7+ years of experience** in data architecture, data engineering, or platform roles.
- Expert knowledge of SQL Server, PostgreSQL, data modeling, and hybrid architectures.
- **English fluency (C1+)** required.

**Preferred Certifications**
- Microsoft Azure Data Engineer Associate
- Microsoft Azure Database Administrator Associate

Join a global team where **data architecture powers AI, analytics, and the future of logistics**.

TrafficTech #Hiring #DataArchitect #DataEngineering #AIData #CloudData #BogotáJobs