Analyst, Data Analytics - GOSC 1

Extract data from multiple sources, cleanse, transform and load the data into a central repository Analyze complex data and derive insights and foresights and present to leadership Create various reports, dashboards, and visualizations for design solutions Identify, analyze, and interpret trends, patterns, and relationships in complex data sets Identify process improvement opportunities and automate any manual tasks Must Have Skills: Bachelor s degree or equivalent with 2-5 years of experience in the following skills, tools & technologies including but not limited to Data cleansing, transformation and validation in Power BI using Power Query and loading the data into a relational database for further processing Writing complex SQL queries in any relational database environment like Oracle, MySQL etc. Experience in analyzing complex business data and deriving insights and creating dashboards, reports and visualizations using Power BI Data analysis using Microsoft Excel including but not limited to pivot tables, data cleaning and validation, VLOOKUP, text, date & time functions, data visualizations, sorting and filtering etc. Nice to Have Skills: Experience in supply chain, logistics, distribution, or related industry/environment. Experience in ETL tools like Pentaho, Informatica, SSIS etc., that includes data ingestion, transformation, cleansing and data loading. Experience in creating and understanding of data models. Experience in advanced analytics and tools like Python, R etc. Experience in visualization tools like Tableau. Adept at creating presentations and presenting them to stake holders, senior leadership etc. Understanding of machine learning, data mining and experience in algorithmic program development and coding