Description

Key Responsibilities

- Design enterprise data architecture solutions supporting strategic business initiatives.
- Develop conceptual, logical, and physical data models for analytics and reporting requirements.
- Architect and implement scalable Snowflake-based data warehouse solutions.
- Define enterprise data standards, governance policies, lineage frameworks, and metadata strategies.
- Design and optimize ETL/ELT pipelines using Snowflake, Azure Data Factory, and dbt.
- Lead cloud migration and modernization initiatives from legacy databases to contemporary cloud platforms.
- Establish data ingestion frameworks, CDC mechanisms, and incremental data processing models.
- Design high-performing data pipelines handling large-scale datasets and complex transformations.
- Implement data quality controls, reconciliation processes, and audit frameworks.
- Define security architecture including RBAC, Row-Level Security, Data Masking, and compliance controls.
- Create and maintain architecture documentation, data flow diagrams, and solution blueprints.
- Collaborate with Business Analysts, Solution Architects, Product Owners, and Development teams to translate business requirements into scalable data solutions.
- Drive performance optimization initiatives across databases, warehouses, and reporting layers.
- Support analytics, BI, AI/ML, and enterprise reporting platforms through robust data architecture.

Data Architecture & Modelling

- Enterprise Data Architecture
- Data Modelling
- Dimensional Modelling
- Fact & Dimension Design
- Star & Snowflake Schema

- SCD Type 1 & Type 2
- Data Warehousing
- Cloud & Data Platforms
- Snowflake
- Azure Data Factory
- Azure Blob Storage
- Azure Data Lake Storage (ADLS Gen2)





- Azure Monitor
- Cloud Data Platform Design
- ETL / ELT & Integration
- ETL/ELT Architecture
- Data Migration
- Data Ingestion
- CDC

- Snowpipe
- Streams & Tasks
- COPY INTO
- API/Data Integration
- Database Technologies
- SQL
- SQL Server
- Oracle
- Stored Procedures

- Query Optimization
- Performance Tuning
- Data Governance & Security
- Data Governance
- Metadata Management
- Data Lineage
- Data Quality Management

- Audit & Compliance
- Dynamic Data Masking
- Row Access Policies
- RBAC
- Analytics & Transformation
- dbt Cloud
- Incremental Models

- Data Validation
- Reconciliation Frameworks
- Documentation & Lineage DAGs
- [hr align="center" size="2" width="100%"]
- Preferred Qualifications

- SnowPro Certification
- Microsoft Azure Certifications (DP-900 or equivalent)
- Strong exposure to Banking, Financial Services, or Insurance domains.
- Experience with enterprise-scale cloud transformation programs.

- Knowledge of modern analytics and reporting architectures.

Enable Skills-Based Hiring No ECMS REQ IDAdditional Details

- ECMS REQ ID : 581823
- Project Location 1 : KRNK | BANGALORE
- Project Location 2 : (No Value)
- Project Location 3 : (No Value)
- Project Location 4 : (No Value)
- Delivery SPOC : Junaid Arif Shaikh [[email protected]]
- Relevant Experience : 10+ yrs
- Mandatory skills : refer JD above
- Desired skills : refer JD above
- Domain (Industry) : any
- BGC (Before onboarding / After onboarding) : PostOB
- Total Experience (Ex. 5-7 Years) : 12+ yrs
- BGC Details : as per client
- BGC Vendor : as per client
- Mode of Interview : Face to Face
- WFO / WFH / Hybrid : Hybrid
- Please enter shift timings : 9-6
- Shift Timings : General

📌 581823- Data Architecture & Modelling- India- DX (Bengaluru)
🏢 Trigent Software
📍 Bengaluru