Data Architect

TMF Group; Bogotá ciudad; Presencial; COP 110.000.000 - 190.000.000; Jornada completa

Descripción de la vacante

TMF Group is seeking an experienced Data Architect to shape how data is structured, governed and delivered across the organization. You will define the enterprise data architecture, drive standards, and guide teams in building scalable, secure data solutions across the lake, lakehouse and data warehouse layers.

You will own logical and physical models, canonical entities, and semantic layers, enabling trusted BI and analytics.

Formación

• Bachelor's degree in computer science, information systems, data analytics, software engineering, mathematics or related field.
• 10+ years of experience in data management, data engineering or business intelligence, including 4+ years in data architecture for warehouses/lakes/lakehouses.
• Expert-level data modelling (dimensional/Kimball, 3NF, data vault) with modelling tools.
• Hands-on experience with Microsoft Azure data services (Azure Data Factory, Azure SQL, Azure Synapse, Azure Databricks) and Microsoft Fabric; Snowflake is a plus.
• Advanced SQL and database design across SQL Server, Azure SQL, Snowflake, Oracle, Redshift, with performance tuning.
• Experience designing integration architectures using ETL/ELT, CDC, event-driven and REST API patterns.

Responsabilidades

• Define target-state data architecture for the Data Intelligence practice with roadmaps aligned to business priorities.
• Set architecture standards, patterns and reference implementations for engineering teams.
• Translate business needs into end-to-end architectures covering data ingestion, storage, integration and consumption.
• Produce and maintain architecture artefacts including data models, data flow diagrams and architecture decisions.
• Lead or participate in design reviews to ensure compliance with standards.

Conocimientos

Data architecture

Data modelling

SQL

Python

ETL/ELT

Educación

Bachelor's degree in CS/IS/related field

Master's degree (plus)

Herramientas

Azure Data Factory

Azure Synapse

Azure Databricks

Snowflake

Power BI

Descripción del empleo

We never ask for payment as part of our selection process, and we always contact candidates via our corporate accounts and platforms. If you are approached for payment, this is likely to be fraudulent. Please check to see whether the role you are interested in is posted on our career website.

ABOUT TMF GROUP

TMF Group is a leading provider of administrative services, helping clients invest and operate safely around the world. As we’re a global company with 11,000+ colleagues based in over 125 offices across 87 jurisdictions, we actively seek out people with the talent and potential to flourish at TMF Group, whatever their background, and offer job opportunities to the broadest spectrum of people. Once on board we nurture and promote talented individuals, making sure that senior positions are open to all.

DISCOVER THE ROLE

TMF Group is looking for an experienced Data Architect to join its Data Intelligence practice. In this role you will define how data is structured, integrated, governed and delivered across the organization. You will set the architectural direction for our enterprise data platform and turn business needs into scalable, secure and well-governed data solutions.

KEY RESPONSIBILITIES:

Architecture Strategy and Standards

• Define, document and maintain the target-state data architecture for the Data Intelligence practice, covering ingestion, storage (lake, lakehouse and warehouse), integration, semantic and consumption layers, with a roadmap tied to business priorities.
• Set architecture principles, standards and reusable reference patterns (e.g., medallion layering, change data capture, API-based integration, semantic modelling) that engineering teams apply consistently.
• Evaluate emerging data and AI technologies, lead proofs of concept and make evidence-based build, buy and platform recommendations.

Solution Architecture and Design

• Translate business and client requirements into end-to-end solution architectures that meet functional needs and non-functional requirements for scalability, performance, availability, security and cost.
• Produce and maintain architecture artefacts, including solution designs, data flow and lineage diagrams, integration specifications and architecture decision records.
• Lead or take part in design and architecture reviews to make sure solutions follow agreed standards before build and release.
• Own conceptual, logical and physical data models across enterprise and domain areas, including dimensional models, normalized models and data vault where appropriate.
• Design canonical models for core business entities such as clients, legal entities, funds, investors, accounts and transactions across financial and operational source systems.
• Design semantic layers and certified datasets that give BI and self-service analytics users consistent, trusted definitions.

Data Integration and Platform

• Define integration patterns (batch, CDC, event and streaming, REST APIs) for moving data between business applications, databases and the enterprise data platform.
• Guide platform design on Microsoft Azure, Microsoft Fabric, Databricks and Snowflake, including storage and partitioning strategy, performance tuning, workload management and cost optimization.
• Work with data engineers on the design of ingestion and transformation pipelines (ETL/ELT), reviewing their approach and building prototypes of complex components when needed.

Data Governance, Quality and Security

• Work with data governance and business data owners to put ownership, stewardship, metadata management, cataloguing and lineage into practice.
• Define the data quality framework, covering profiling standards, data quality rules, monitoring, thresholds and remediation workflows, and see that it is built into delivery pipelines.
• Design master and reference data management for key entities to provide a single, reconciled view across systems.
• Build security and privacy into the architecture through data classification, role-based access, masking, encryption and retention, in line with GDPR, other applicable regulations and client contractual obligations.

Analytics and AI Enablement

• Design data foundations that support advanced analytics, machine learning and generative AI use cases, including feature-ready data, governed access and integration with MLOps practices.
• Work with analytics and data science teams so that models and AI solutions are built on trusted, well-documented data.

Leadership and Collaboration

• Provide technical leadership and mentoring to data engineers and BI developers through design guidance, code and model reviews, and knowledge sharing.
• Take part in client-facing activities, including requirements workshops, solution presentations and design reviews, and explain technical trade-offs and business benefits in plain language.
• Investigate complex data defects and performance issues, identify root causes and recommend improvements to architecture, processes and policies.
• Work within agile delivery teams, contributing to backlog refinement, estimation and delivery planning.

KEY REQUIREMENTS:

Required:

• Bachelor’s degree in computer science, Information Systems, Data Analytics, Software Engineering, Mathematics or a related field. A master’s degree is a plus.
• 10+ years of experience in data management, data engineering or business intelligence, including at least 4 years in a data architecture role designing enterprise data warehouses, data lakes or lakehouses.
• Expert-level data modelling (dimensional/Kimball, 3NF, data vault) and experience with modelling tools.
• Deep, hands-on experience with Microsoft Azure data services (Azure Data Factory, Azure SQL, Azure Synapse Analytics, Azure Databricks) and Microsoft Fabric. Snowflake experience is a plus.
• Advanced SQL and database design skills across platforms such as SQL Server, Azure SQL, Snowflake, Oracle and Redshift, including performance tuning, indexing, query plan analysis, partitioning and handling high data volumes.
• Proven experience designing integration architectures using ETL/ELT, CDC, event-driven and REST API patterns across multiple applications and databases.
• Experience putting data governance, data quality, master data management and metadata or lineage tooling into practice (e.g., Microsoft Purview, Unity Catalog).
• Experience designing semantic layers, data marts and certified datasets for BI tools such as Power BI or Anaplan.
• Proficiency in Python and/or PySpark. Scripting in PowerShell or similar is a plus.
• Working knowledge of DevOps and DataOps practices, including version control (Azure DevOps, GitHub, Bitbucket) and CI/CD for data solutions. Infrastructure as code (Terraform) is a plus.
• Experience working in agile delivery teams using tools such as Jira.

Nice to have:

• Experience designing data architecture for Analytics, Data Delivery, ML/AI solutions and MLOps, including model data pipelines and feature management.
• Knowledge of private funds, fund administration, investment management, accounting, or capital markets and credit/debt servicing.
• Experience with industry platforms such as private equity (Investran, Archway, eFront), real estate (Yardi, MRI) or credit servicing (Sentry or Loan IQ).
• Relevant certifications, such as Microsoft Certified: Azure Solutions Architect Expert, Fabric Analytics Engineer Associate, Databricks, SnowPro, or DAMA CDMP

WAHT'S IN FOR YOU?

• An international and dynamic environment.
• Exceptional people and atmosphere
• Business Academy: Online platform with multiple learning resources such as trainings and written materials.
• Local benefits apply according to local office policies.
• Make An Impact, you’ll help us make the world a simpler place for our clients to do business.