Azure Data Architect

EXL; Bogotá; Híbrido; COP 200.880.000 - 312.480.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Learning platforms access

Certification programs

Hybrid or remote work depending on loc

Descripción de la vacante

EXL is seeking a Data Architect to lead an enterprise-scale cloud migration and establish an EDM from first principles. You will model and deliver domains starting with Underwriting, then Claims, enabling a first use case to reconcile reports with governed data products.

The target platform is Azure + Databricks with Unity Catalog and Purview governance aligned to ACORD and Blueprint 2 standards. You will provide technical expertise across analysis, design, development, rollout and maintenance

Formación

• 8-10 years of Enterprise Data Modelling experience required.
• Experience designing data architectures for cloud migration and modern lakehouse patterns.
• Strong experience with Azure and Databricks (Delta/Lakehouse layering).
• Proven ability to establish guardrails: standards, naming conventions, definitions.

Responsabilidades

• Design and develop conceptual, logical, and physical data models for large-scale data lake and warehouse solutions.
• Define and deliver an Enterprise Data Model approach across conceptual to physical layers.
• Establish canonical entities and conformed dimensions for cross-domain analytics.
• Provide technical supervision of the project and define target architecture (Synapse to DBX).
• Identify source systems and integration requirements.
• Model domains iteratively (UW first, then Claims).
• Understand data integration processes using Informatica, SSIS, MuleSoft, DataStage, Sqoop.
• Define and operationalize a data quality rule catalog.
• Implement reconciliation and control checks between source and target.
• Lead domain workshops with SMEs, architects, governance, and reporting teams.
• Communicate status, risks, dependencies, and decisions.
• Lead design reviews to align with standards and priorities.
• Stay current with emerging data technologies and approaches.
• Support setting data architecture direction and ensure delivery adherence.
• Coordinate with project manager and client staff on best practices.

Conocimientos

Data modeling

Cloud migration

Azure Databricks

Guardrails & standards

Data governance

Data product ownership

Documentation

Insurance domain (UW/Claims)

SQL proficiency

Stakeholder facilitation

Educación

8-10 years Enterprise Data Modelling

Experience with ERwin/ER/Studio/PowerDesigner

Experience with Oracle/SQL Server/Teradata

Data warehouse modelling (Dimensional/ODS/Data Vault)

Herramientas

Azure

Databricks

Synapse

Unity Catalog

Microsoft Purview

PowerCenter/DataStage/MuleSoft/Sqoop

Descripción del empleo

The Data Architect to lead an enterprise-scale cloud migration and establish an Enterprise Data Model (EDM) from first principles, including guardrails, standards, definitions, and naming conventions. The role will model and deliver the first few domains, starting with Underwriting (UW) and then progressing to Claims, while enabling a first use case to replicate existing reports with reconciliation, quality checks, and governed data product delivery. The target platform is Azure + Databricks, with governance using Unity Catalog and Microsoft Purview, aligned to ACORD and internal Blueprint 2 standards. He will provide technical expertise in analysis, design, development, rollout and maintenance of enterprise data models and solutions.

Provides technical expertise in needs identification, data modelling, data movement and transformation mapping (source to target), automation and testing strategies, translating business needs into technical solutions with adherence to established data guidelines and approaches from a business unit or project perspective.

Provides data understanding and coordinate data related activities with other data management groups such as master data management, data governance and metadata management. Leadership not only in the conventional sense, but also within a team we expect people to be leaders. Candidate should elicit leadership qualities such as Innovation, Critical thinking, optimism/positivity, Communication, Time Management, Collaboration, Problem-solving, Acting Independently, Knowledge sharing and Approachable.

Key Responsibilities

• Design and develop conceptual / logical / physical data models for building large scale data lake and data warehouse solutions.
• Define and deliver a pragmatic Enterprise Data Model (EDM) approach across conceptual → logical → physical layers.
• Establish and maintain canonical entities, relationships, and conformed dimensions to enable cross-domain analytics.
• Technical supervision of the project.
• Define target architecture on Synapse and later migration to DBX.
• Identification of source systems and integration requirements.
• Model priority domains iteratively: Underwriting (UW) first (known/priority domain), Claims logical model next (claim lifecycle, reserves, payments, recoveries, parties, events).
• Understanding data integration processes (batch or real-time) using tools such as Informatica PowerCenter and/or Cloud, Microsoft SSIS, MuleSoft, DataStage, Sqoop, etc.
• Define and operationalize a data quality rule catalog (completeness, validity, uniqueness, referential integrity).
• Implement reconciliation and control checks between source and target.
• Collaborate with business users to analyse and test requirements.
• Run domain workshops with SMEs (UW/Claims), architects, engineering, governance, and reporting teams.
• Provide clear status, risks, dependencies, and decisions required.
• Lead design reviews and ensure alignment with enterprise standards and delivery priorities.
• Stays current with emerging and changing technologies to best recommend and implement beneficial technologies and approaches for Data Architecture.
• Assist with and support setting the data architecture direction (including data movement approach, architecture / technology strategy, and any other data‑related considerations to ensure business value,) ensuring data architecture deliverables are developed, ensuring compliance to standards and guidelines, implementing the data architecture, and supporting technical developers at a project or business unit level.
• Coordinate and consult with the project manager, client business staff, client technical staff and project developers in data architecture best practices and anything else that is data related at the project or business unit levels.

Must Have Skills & Experience

• Strong hands‑on expertise in enterprise and domain data modeling (conceptual/logical/physical).
• Experience designing data architectures for cloud migration and modern lakehouse patterns.
• Strong experience with Azure and Databricks (Delta/Lakehouse layering, orchestration design patterns).
• Proven track record building guardrails: modeling standards, naming conventions, definitions/glossary.
• Governance experience with Unity Catalog and Microsoft Purview (cataloging, lineage, permissions, classification).
• Ability to operate effectively in a data product / domain ownership model within a broader governance program.
• Strong documentation and stakeholder facilitation skills.
• Insurance domain experience, especially Underwriting and Claims.
• Experience delivering “first use case” accelerators for reporting migration and KPI reconciliation.
• Can effectively utilise SQL and/or available BI tool to validate/elaborate business rules.
• Demonstrates an understanding of EDM architectures and applies this knowledge in collaborating with the team to design effective solutions to business problems/issues.
• Understands and leverages a multi‑layer semantic model to ensure scalability, durability, and supportability of the analytic solution.
• Understands modern data warehouse concepts (real‑time, cloud, Big Data) and how to enable such capabilities from a reporting and analytic stand‑point.
• Demonstrated ability to serve as a trusted advisor that builds influence with client management beyond simply EDM

Education & Experience

• 8-10 years of Enterprise Data Modelling.
• Experience using major data modelling tools (examples: ERwin, ER/Studio, PowerDesigner, etc.)
• Experience with major database platforms (e.g. Oracle, SQL Server, Teradata, etc.)
• Understanding and experience with major Data Architecture philosophies (Dimensional, ODS, Data Vault, etc.)
• Strong data warehousing and OLTP systems from a modelling and integration perspective.
• Strong understanding of data integration best practices and concepts.
• Strong development experience under Unix and/or Windows environments.
• Strong SQL skills required scripting (e.g., PL/SQL) preferred.
• Strong Knowledge of all phases of the system development life cycle.
• Understanding of modern data warehouse capabilities and technologies such as real‑time, cloud, Big Data.
• Understanding of on premises and cloud infrastructure architectures (e.g. Azure, AWS, Google Cloud).

What We Offer

• Indefinite‑term contract with full legal benefits.
• Hybrid or remote work model depending on location.
• Office hours, Monday to Friday.
• Access to learning platforms and certification programs.
• Opportunity to work with modern data stacks and enterprise clients.