Senior Technical Architect

Technology, Data & Digital · Data, AI & Analytics · Data Engineering · Data Analysis · Software Engineering

In short

As a Senior Technical Architect in Pune, India, you will be instrumental in designing and expanding a global data integration platform for Wealth businesses. Responsibilities include gathering data requirements, creating data models and metadata, and defining changes to data flows and architecture in collaboration with various teams.

Responsibilities

  • Assist stakeholders with their data requirements.
  • Gather and manage in-depth knowledge of the data platform’s data models.
  • Create and maintain data models and metadata.
  • Design changes and extensions to the platform’s data models and data flows.
  • Perform impact assessment for required changes.
  • Define requirements and lead problem-solving in the data architecture space.
  • Identify and assess potential data sources.
  • Carry out Impact Assessment and create user stories.
  • Define business transformation rules from source system through to consumer interface.
  • Build and maintain knowledge of data sources and what data is used by a particular Consumer.
  • Definition of data models and metadata in line with business requirements and metadata standards.
  • Validate data model is in line with projected data growth, non-functional requirements and changing consumer patterns.
  • Educate users on the platform’s capabilities, the data available, what it means and how to access it.

Requirements

  • Data modelling (definition of data schemata) and data analysis skills in a data warehouse type environment, including both star schema and third normal form.
  • Using ER Studio or similar tool.
  • Strong SQL skills. Comfortable at the SQL command prompt.
  • Experience of working in Financial domain with understanding of key data entities in Investments and Client domain.
  • Understand types of data schema and when to use them (3NF, star, flat, etc); mapping/translation between these.
  • Express key structural points of complex data model in accessible terms.
  • Experience understanding source data models with limited documentation and access to experts.
  • Understanding of the principles of data quality and data governance.

Desired Qualifications

  • Strong analytical skills.
  • Experience of inferring a data model and lineage from an existing database with limited documentation.
  • Python and Pandas for data manipulation.
  • Data warehouse background.
  • Experience of data science and machine learning principles and techniques.
  • ETL tools; ability to use and enhance new tooling.
  • Amazon Web Services (AWS) – AWS Glue, Athena, S3.
  • Data catalogue e.g. Alation.
  • Working in agile mode.
  • Graduate preferably with a technology based degree.

Benefits

  • You'll supercharge your potential.
  • You'll find your career.
  • And you'll find your spark.
  • All at a place that knows that helping its customers stay on top starts by putting its people first.
#Data#Architecture#Data Modelling#Data Integration#Wealth Management#Financial Services#Data Warehouse#Metadata#SQL#AWS
HCLTech Logo

Company

HCLTech

Job Posted

2 weeks ago

Employment Type

Full Time

WorkMode

On Site

Experience Level

Senior

Locations

Pune, India

Qualification

Undergraduate

Applicants

Be an early applicant