Data Architect – ETL & Data Warehousing

Greetings from ALIQAN Technologies!!

Job Title:Data Architect ETL & Data Warehousing (BFSI Focus)

Organisation:NEC Corporation India Pvt. Ltd.

Location:Chennai

Employment Type: Contractual for 6 months

Experience:1015 years

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:

• 1015 years in data architecture engineering and warehousing.
• Strong experience in BFSI data platformscore 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:

• Bachelors or Masters in Computer Science Information Systems or related fields.
• Cloud or data architecture certifications preferred.