Lead Analyst - Knowledge Services

We are seeking an experienced and highly skilled SQL(Data Modelling) + ETL Developer with Cloud experience to join our Reporting COE team. The ideal candidate will have extensive hands-on experience with SQL database development, ETL processes, and cloud platforms, enabling scalable and efficient data solutions.
Roles & Responsibilities

• Data Modelling:
  o Strong proficiency in SQL (queries, procedures, views, functions, indexing).
  o Hands-on experience in data modelling using tools like ER/Studio, ERWin, SQL Server Management Studio, Lucidchart, etc.
  o Solid understanding of database normalization, relational modelling, and schema design principles.
  o Experience working with large datasets and optimizing database performance.
  o Familiarity with star schema, snowflake schema, and dimensional modelling principles.
• ETL Development:
  o Design, implement, and manage Extract, Transform, Load (ETL) processes to move and transform data from various source systems into target data warehouses or databases.
  o Develop, monitor, and troubleshoot ETL workflows to ensure smooth and accurate data integration.
  o Work with business and technical teams to understand data requirements and ensure seamless integration of systems.
  Cloud Data Engineering
• Design and implement data solutions using cloud platforms such as AWS, Azure, or GCP
• Develop and manage data pipelines using cloud-native tools (e.g., Azure Data Factory, AWS Glue, etc.).
• Work with cloud storage solutions like Data Lakes, Blob Storage, or S3.
• Ensure scalability, reliability, and security of cloud-based data solutions.
• Monitor and optimize cloud data workflows for performance and cost efficiency.
  Technical Requirement
  Required Skills and Experience:
• Data Modelling: 8+ years of experience in creating Dimensional Modeling, Data Base Normalization and writing complex SQL queries, stored procedures, and optimizing database performance.
• ETL Tools: 8+ years of Strong experience with ETL tools (such as SSIS or ADF) for data extraction, transformation, and loading.
• Cloud Experience: At least 4 years of hands-on experience in cloud platforms (Azure/AWS/GCP),
  including: Data pipeline development, Data lake and warehouse concepts , Cloud-based ETL tools
  Educational Requirement
  Graduate
  Preferred Skills
  Digital Business
  Service Line
  BPO Service Line