Overview
Senior Associate in Data Architecture at BTVK Advisory, responsible for designing enterprise data models, integration architectures and governance standards across core business domains.
What you'll do
- Design and maintain conceptual, logical and physical data models, canonical models and reusable architecture patterns across Client, Project, Engagement, People and Finance domains.
- Translate business requirements into scalable data architecture solutions, applying reference architectures for data lakehouses, warehouses, MDM, Golden Records, streaming and API-based services, while evaluating design alternatives, risks and dependencies.
- Define and implement Master Data Management (MDM), Golden Records, reference data, matching, survivorship, synchronization and distribution patterns, ensuring consistent enterprise data definitions and authoritative sources.
- Design enterprise integration architectures using ETL/ELT, APIs, batch processing, event-driven integration and streaming, ensuring seamless data movement, reuse, scalability and interoperability across platforms.
- Establish data ingestion, transformation and promotion standards across landing, curated and consumer layers, incorporating data quality, observability, metadata, lineage, security and operational requirements.
- Define and enforce enterprise data architecture standards covering modeling, naming, metadata, classification, lineage, data quality and data products, conducting design reviews and ensuring governance compliance.
- Architect and optimize data flows across Workday, Salesforce, analytics platforms and service line applications, supporting system-of-record decisions, source-of-truth alignment and application/data deprecation strategies.
- Collaborate with Data Governance, Enterprise Architecture, Security and Privacy teams to incorporate data access, retention, classification, privacy and security controls into solution designs, ensuring policy compliance, risk mitigation and escalation of architecture exceptions.
- Develop and maintain data models, architecture diagrams, data dictionaries, lineage records, integration designs, data flows and architecture decision records, keeping documentation accurate and updated throughout the solution lifecycle.
- Serve as the Data Architecture point of contact for assigned initiatives, partnering with business stakeholders, engineering, analytics, application teams and the Senior Manager – Data Architecture to guide solution design, validate technical feasibility, resolve cross-functional dependencies and advance enterprise architecture standards.
What you'll need
- Bachelor's degree in Computer Science, Information Systems, Data Management, Engineering or a related field.
- Minimum 3 years of experience in Data Architecture, Data Engineering, Data Modeling, Analytics Architecture or Enterprise Integration, with proven experience designing solutions across multiple systems, domains and platforms.
- Strong expertise in conceptual, logical, physical, dimensional, domain and canonical data modeling, including enterprise data structures and reusable architecture patterns.
- Hands-on experience designing enterprise data integration solutions using ETL/ELT, APIs, batch processing, event-driven integration and streaming technologies.
- Experience architecting modern cloud-based data and analytics platforms, including data lakehouses and enterprise data warehouses.
- Strong understanding of Master Data Management (MDM), Golden Records, reference data, authoritative data domains and system-of-record/source-of-truth architecture.
- Experience with Data Governance, metadata management, data catalogs, lineage, classification, data quality, observability, ownership and data lifecycle management, including enterprise standards and frameworks.
- Knowledge of data privacy, security, retention, classification, compliance and Data Loss Prevention (DLP), with the ability to incorporate governance and risk controls into architecture designs.
- Experience evaluating architecture alternatives, technical trade-offs, risks and recommendations, and maintaining architecture diagrams, data models, integration designs, data flows and decision records.
- Strong technical problem-solving, analytical, stakeholder management, communication and influencing skills, with the ability to collaborate across business and technology teams, explain complex architectural concepts and guide cross-functional solution delivery.
Nice to have
- Exposure to Databricks and/or Snowflake.
- Familiarity with Workday and Salesforce.
- Familiarity with reusable data products and domain-oriented architectures.
Details
- Location: Bangalore, Karnataka, India.
Read the full description and apply on the company’s own careers page.