Lead Analyst - Knowledge Services

Job description

## **Job Description:** - 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 ## **Key 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 Requirements:** - 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 ## **Preferred Skills:** Digital Business