Analytics and Automation Engineer

Analytics & Automation Engineer _Consultant

Excel VBA, Alteryx , SQL

Level: 4-6 Years (Con Level)

Location: Preferably Bangalore.

 

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  EXCEl VBA, Alteryx, PowerBi

• Experience with version control systems such as Git.
• Understanding of databases and SQL, experience with PostgreSQL, MySQL, or similar databases.
• Excellent communication and teamwork skills.
• Strong problem-solving and debugging skills.edit

• Expert level knowledge in using Excel VBA, MS-Access.

• 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

#KGS

#LI-NP1

B.Tech\BE

Experience Level

Senior Level