Data Analyst

Job Description Experience: 2 to 5 years Joining: Immediate / Within a month Worked with PowerBi / SQL in a professional environment. Power Bi: V Lookup Data Sanitization Calculation & Advanced DAX Power Query or M language Visualizations Good understanding of Filters SQL: Query Writing (Alteration & Amendment) Aggregation Functions Windowing functions Views & Stored Procedures Filtering & Optimization Play an integral role in gathering, cleansing and analysing data from multiple business systems. Development of key performance indicators and dashboards for business and recommend design, usability and information architecture based on insights from data analytics Work with internal and external experts in Information Technology, Business Intelligence, and other teams Provides operational support in terms of documentation, training and administration. Extracts/generates quantitative information from a single or multiple tools (Business Intelligence Tools ... ie: Tableau, SQL, etc) and/or from databases using queries. Conducts research to gather qualitative information (market need, market size, ethnography, competitive product information, industry trends, and check product specifications) from internal & external sources that will be used for analysis. Formats extracted data based on expected report output (with batching capability and multiple data formatting requirements). Categorizes and segments extracted data using tools to convert data to information relevant to the report (excel, macro, database). Consolidates and combines extracted data from multiple resources using automated tools (excel, macro, database), and/or from different system tools in one single database using queries (SQL, Tableau, Power BI) standardize data structure from different data sources. Conceptualizes report design contents and methodologies based from gathered data and/or analysis for static or dynamic reports. Job Type: Full-time Schedule: Day shift Ability to commute/relocate: Mumbai, Maharashtra: Reliably commute or planning to relocate before starting work (Required) Experience: total work: 1 year (Preferred,

This job is provided by Shine.com