Consultant - Data Analyst

Job Description

Consultant - Data Analyst

The primary responsibility of the Data Analyst will be to build and maintain the dashboard platform/processes and to address any data-related needs of the organization. This role will work across functions with other groups in analytics as well as other departments in the company and will be expected to frequently work on data requests from various stakeholders.

Expectations from the Role

• 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.
• Gather user requirements for new reports and enhance existing reports.
• Interpret needs and design reports to meet end-user expectations.
• Data modeling, and creation of both logical and physical data models for effective and efficient reporting and TAT on frequent requests.
• 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.
• Data validation and attention to detail are required as this role will be accountable for the quality of all the numbers delivered through dashboards or otherwise.
• Work effectively as part of a team to achieve individual, team, and organizational objectives, sharing knowledge and skills.
• Positively work and influence with team members to partner together to achieve individual, customer, and business goals.

Required Technical Skills

• Strong experience in building complex SQL queries Advanced Excel & Macros.
• Strong logical & analytical concepts in databases, schemas, dimensional modeling end-to-end
• Experience in building complex MIS and dashboards especially in Qlikview
• Programming languages like VB, JAVA, C will be good to have
• Experience in QlikView and Hadoop is highly desirable but not mandatory

Required Behavioral Skills

• Should be a quick learner with the ability to learn new tools/technology quickly.
• Good analytical skills and ability to understand the business and be able to relate the same to data.
• Understanding of e-commerce/retail business (preferred but not mandatory).
• Should be result & detailed oriented and must have the ability to multi-task and work under pressure with minimum supervision in the fast-paced e-commerce environment.
• Proficient in Verbal and Written Communication skills, with demonstrated ability to communicate with all levels within the company