Data Architect – ETL & Data Warehousing (BFSI Focus)

Job Title:

Location:

Employment Type: Contractual for 6 months

Experience:

Role Overview:

The Data Architect will lead the design, modernisation, and optimisation of enterprise data

ecosystems, focusing on ETL, data warehousing, and cloud data solutions. BFSI experience is highly preferred due to domain-specific requirements involving regulatory reporting, customer data, risk systems, and core banking data flows.

This role requires more than just following instructions — we need someone who proactively identifies issues, understands the "why" behind the request, and takes ownership of designing and implementing solutions. Flexibility beyond assigned roles is key in our culture.

Key Responsibilities:

• Work closely with business units and product teams to elicit and structure often-implicit data requirements and convert them into business-relevant information.
• Design enterprise-scale data architecture across ingestion, ETL/ELT, warehousing, and analytics layers.
• Build data models (conceptual, logical, physical) tailored to BFSI domains such as deposits, lending, payments, KYC, AML, credit risk, regulatory reporting, and treasury.

• Architect ETL/ELT pipelines using Databricks, Azure.

• Design and optimise data warehouse and data mart solutions (Kimball/Inmon/Data Vault).

• Implement cloud-native data solutions on Azure with a focus on security,

• compliance, and performance

  .

• Ensure adherence to BFSI regulatory standards (RBI, Basel, IFRS, GDPR – Any of these).

• Collaborate with business, risk, compliance, and IT teams to translate BFSI data needs into scalable architecture.
• Define and enforce standards for data governance, lineage, metadata, and data quality.
• Conduct impact analysis and stakeholder communication when new data sources or structural changes are introduced to the system.

Required Skills & Experience:

• 10–15 years in data architecture, engineering, and warehousing.
• Strong experience in BFSI data platforms—core banking, risk systems, AML/KYC platforms, data lakes for regulatory needs.
• Expertise in ETL tools: ETL, data engineering, data warehousing, governance, and cloud transformation, Databricks, Data analytics and Azure data pipeline
• Hands-on experience with Databrics, Bigdata or Oracle.
• Strong SQL, data modelling, and distributed data processing. 

  – Any database will work –

• PL SQL is preferred

• Experience with cloud data services and big data tools like Spark or Databricks.

Professional Skills:

• Strong analytical mindset with excellent problem-solving and critical-thinking abilities.
• Excellent communication and storytelling skills to convey complex analyses to non-technical stakeholders.
• Ability to manage multiple priorities and deliver under tight timelines.
• Proactive, innovative, and collaborative attitude with a passion for continuous learning.
• Experience working with BFSI compliance, governance, and risk management teams.

Good to have:

• Experience working with non-technical stakeholders.
• Experience working in or with Japanese-oriented companies or clients.
• Databricks certification or equivalent cloud platform credentials (e.g., AWS/Azure/ GCP).

Education:

• Bachelor’s or Master’s in Computer Science, Information Systems, or related fields.
• Cloud or data architecture certifications preferred.