Platform Architect

Job Title: Platform Architect/ BI Data Modeling Architect

Location: Remote (Brazil/Mexico)

Employment Type: Contract Position

Overview

Client is seeking a Platform Architect with a strong focus on Data Architecture, Cloud Platform Strategy, and Enterprise Analytics Design to help define the future-state architecture of its modern freight technology ecosystem.

This is a highly strategic architecture role focused on scalability, security, modernization, and long-term platform design rather than day-to-day development. The ideal candidate combines enterprise data platform architecture expertise with deep dimensional data modeling knowledge and can partner with both business and technical stakeholders to develop a sustainable, business-driven data strategy.

The environment is heavily centered on AWS and Databricks, with an emphasis on building modern cloud-native data platforms, lakehouse architectures, analytics solutions, and enterprise reporting capabilities.

Responsibilities

• Lead the architectural vision for client's cloud and data platform modernization initiatives.
• Define enterprise data architecture standards, governance frameworks, and platform design principles.
• Design scalable data platforms supporting integrations, reporting, business intelligence, and advanced analytics.
• Architect end-to-end data flows from operational source systems through transformation and consumption layers.
• Partner with business stakeholders to translate reporting and analytics requirements into scalable data solutions.
• Design and maintain enterprise analytical data models using dimensional modeling best practices.
• Create and govern fact tables, dimension tables, star schemas, and enterprise reporting structures.
• Define and manage SCD Type 1 and Type 2 strategies.
• Establish standards around data quality, lineage, metadata management, and governance.
• Collaborate with engineering teams on ETL/ELT architecture, pipeline design, and platform implementation.
• Guide modernization efforts involving Databricks, AWS, cloud-native analytics platforms, and enterprise integrations.
• Participate in architecture reviews and provide technical leadership on platform scalability, security, and performance.
• Ensure the platform is positioned to support future business growth and evolving freight technology needs.

Required Skills & Experience

Data & Platform Architecture

• Strong experience with enterprise Data Architecture and Data Platform Architecture.
• Experience designing cloud-based data platforms and modern analytics ecosystems.
• Proven experience leading large-scale modernization, migration, or transformation initiatives.
• Strong understanding of enterprise integration architecture and data movement strategies.
• Experience with data governance, lineage, metadata management, and security best practices.

Data Modeling & Analytics

• Advanced expertise in dimensional data modeling.
• Strong experience designing fact tables and dimension tables.
• Expertise with star schema architecture.
• Experience implementing Slowly Changing Dimensions (SCD Type 1 & Type 2).
• Strong understanding of enterprise reporting and Business Intelligence environments.
• Ability to translate business requirements into scalable analytical data models.

Cloud & Engineering

• Hands-on experience with Databricks.
• Strong experience within AWS environments.
• Experience designing and supporting ETL/ELT frameworks.
• Experience building scalable data pipelines and integration architectures.
• Strong SQL skills.

Preferred Skills

• PySpark experience.
• Python and Spark knowledge.
• Modern Lakehouse and Data Lake architecture experience.
• CI/CD and DevOps exposure.
• Infrastructure-as-Code experience.
• Experience in logistics, transportation, supply chain, or freight technology environments.
• Familiarity with AJEX, Transfix, or similar transportation management platforms.
• Experience supporting enterprise BI, analytics, and reporting initiatives.