Associate Consultant - Data Analytics and ETL Specialist

Associate Consultant

General:

• Understand the requirements, design, develop and unit test the code

• Take complete ownership of the requirements and deliver

• Workflow should be properly unit tested before delivering

• Create and maintain necessary artefacts

• Participate in design and other team meetings

• Cross train to avoid single point of failure

 

Skills:

• Expert level knowledge on Data transformation using Alteryx

• Expert level knowledge in using Alteryx Data Blending, and Advanced Analytics tools

• Expert level knowledge in Data loading, Data parsing, Data preparation, filtering and reporting tools

• Expert level knowledge in building Alteryx App using interface tools

• Develop and implement ETL processes using Alteryx or SSIS tools, visualizations, and SQL queries

• Extensive knowledge in building and/or reviewing Alteryx Data models/solutions, and a strong understanding of ETL best

practice.

• Must be comfortable working with large datasets from Excel files, flat files, or SQL data tables

• Understanding in Business Intelligence and Reporting Tools – Power Pivot, Power View, and Power BI

• Working knowledge in Relational Database and Data Manipulation

• The candidate should have in-depth knowledge in various stages of SDLC

• Hands on experience in requirement gathering, analyzing, developing and testing a product/data model/project

Responsibilities:

• Understand high level requirements from Global team and work closely with product owners to plan and budget projects

accordingly

• Manage the assignment of specific responsibilities relating to project by coordinating with peers within the team for

relevant roles and job functions

• Interact with client, do requirement analysis, propose solution, estimation, listing down assumptions and risks

• Create working proof of concept for projects

• Must be good in reviewing client/peer build data models and evaluate the pros and cons

• Basic exposure to Power BI or similar BI tool will be helpful

• Good understanding in relational databases

• Handle large database of in GBs with ability to write/edit/modify Alteryx Workflows and build reports using Alteryx

 

Reporting

• Analyze complex data sets and convert them into the information which drives business decisions

• Express strong voice for data integrity and reporting quality utilizing best practices and industry standards

• Experience writing technical documentation and user guides; providing end-user training and support

• Driven and accountable self-starter, with ability to identify and communicate priorities, and work independently in a fast paced

industry in a rapidly growing team

Qualifications

Education / professional qualifications

BE / BTech / MCA or Equivalent

Candidates with certifications in Database, Business Intelligence or Data Analytical will be a great addition.

Experience Level

Mid Level