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
What you’ll need:
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 macros is beneficial
Strong logical & analytical concepts in databases, schemas, dimensional modelling
Good to have: Basic understanding of scripting languages (R, Python, etc.)
Good to have: Experience with BI tools (Power BI, Tableau, Qlikview, Datastudio, 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 rigour in automating repetitive tasks
Good to have: understanding of e-commerce/ retail business