Data Analyst

JD

· Gather user requirements for new reports and enhance existing reports. Interpret needs and design reports to meet end user expectations.

· Create and maintain reporting tools and applications to support all strategic and tactical needs of the company. Dashboard development and generation for daily, weekly, monthly and all reporting needs

· Design and develop complex data queries to move and transform data from operational data sources to analytical databases.

· Test all new reports/deliverables and periodically review them for quality control.

Technical capabilities:

· Strong experience in SQL - should be able to build complex and optimized queries.

· Strong experience in Excel - should be comfortable with advanced functions. Understanding of macros is beneficial.

· Strong logical & analytical concepts in databases, schemas, dimensional modelling

· Experience with BI tools (Power BI, Tableau, QlikView, Data studio etc.)

· Basic understanding of ETL Pipelines.

· Good understanding of Big Data Concepts, Patterns etc.

· Good to have: Basic understanding of scripting languages (R, Python, etc.)

· Good to have: Working knowledge of data warehousing infra tools like Hive.

Required abilities / competencies:

· Attention to detail and strong data orientation.

· Ability to adapt to and learn new tools/ techniques quickly.

· Very good written and verbal communication skills

· Ability to multitask and work on a diverse range of requirements.

· Strong rigor in automating repetitive tasks.

· Good to have the understanding of ecommerce/ retail business.