Data Architect
- EXL
- 9 - 14 years
- Pune
- 20 hours ago
- Email to a friend
- Report this job
Job Description
Essential Duties
- 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.
- Model priority domains iteratively:
- Underwriting (UW) first (known/priority domain)
- Claims logical model next (claim lifecycle, reserves, payments, recoveries, parties, events)
- Define target-state architecture for migration to Azure/Databricks (ingestion transformation serving).
- Provide patterns and guardrails for:
- Batch/CDC ingestion strategies, landing zones
- Lakehouse layering (e.g., Bronze/Silver/Gold or equivalent)
- Transformation strategy (Databricks notebooks/jobs/workflows)
- Serving patterns for reporting and downstream consumption (marts/semantic models/APIs as applicable)
- Implement a data-products centric approach:
- Define domain boundaries (UW, Claims, etc.) and ownership
- Establish data product contracts (schema, SLAs, DQ expectations, refresh frequency)
- Support federated domain teams while enforcing enterprise standards
- Establish enterprise-wide naming conventions, definition standards, and modeling patterns (keys, timestamps, code/desc, audit fields).
- Build and maintain a business glossary and definitions aligned to ACORD/Blueprint 2.
- Define modeling guardrails such as:
- Grain-first modeling rules
- Identity/key strategy across domains
- History strategy (event vs snapshot, SCD approach)
- Conformance strategy for shared dimensions/reference data
- Embed governance into design and delivery:
- Register datasets, lineage, and glossary terms in Purview
- Enforce access controls, ownership, and data permissions via Unity Catalog
- Ensure classification/sensitivity tagging and documentation completeness
- Understanding data integration processes (batch or real-time) using tools such as Informatica PowerCenter and/or Cloud, Microsoft SSIS, MuleSoft, DataStage, Sqoop, etc.
- Create functional & technical documentation e.g. data integration architecture documentation, data models, data dictionaries, data integration specifications, data testing plans, etc.
- Define and operationalize a data quality rule catalog (completeness, validity, uniqueness, referential integrity).
- Implement reconciliation and control checks between source and target.
- Produce architecture and delivery artifacts:
- EDM & domain models
- Mapping documents, DQ rule catalog, lineage, runbooks
- Decision log and architecture standards documentation
- 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
- 9+ 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.)
- 3-5 years of management experience required
- 3-5 years consulting experience preferred
- Bachelors degree or equivalent experience, Masters Degree Preferred
- Experience in data analysis and profiling
- 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)
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: Software DevelopmentRole: Solution ArchitectEmployement Type: Full timeContact Details:
Company: EXLLocation(s): Pune+ View Contact
Keyskills: Azure Databricks Data Modeling Data Architecture Microsoft Purview Data Warehousing Data Governance SQL
Fraud Alert to job seekers!
₹ 0-40 Lacs P.A
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in