Roles and responsibilities

Understand the client objectives, and design the analytical solution/framework. Be able to translate the client objectives/analytical plan into clear deliverables with associated priorities and constraints
Organize/Prepare/Manage data and conduct quality checks to ensure that the analysis dataset is ready
Conduct sanity checks of the analysis output based on reasoning and common sense, and be able to do a rigorous self QC, as well as of the work assigned to junior analysts to ensure an error free output
Build, develop reporting systems, data automation systems, dashboards that support key business decisions
Manage and optimize processes for data intake, validation, mining and engineering as well as visualization
Be able to take client calls relatively independently, and interact with onsite leads on a daily basis
Recruit, train, develop and lead a team of data analysts
Strong logical reasoning skills and business intelligence. The ability to communicate effectively is essential. If you also have solid industry experience, we’d like to meet you.

Client Management

Act as client lead and maintain client relationship; make independent key decisions related to client management
Be a part of deliverable discussions with clients over telephonic calls, and guide the project team on the next steps and way forward

Technical Requirements:

Design and develop ETL workflows and datasets in Alteryx to be used by the BI Reporting tool
Experience and knowledge of how to connect Database with Alteryx : snowflake, SQL DB etc.
Perform end to end Data validation and prepare technical specifications and documentation for Alteryx workflows supporting BI reports.
Working knowledge of data mining principles: mapping, collecting data from multiple data systems
Strong SQL skills, ability to perform effective querying involving multiple tables and subqueries
Read data from a DB and write it back to a database
Working of macros to avoid repetition of task, and enabling schedulers to run work flow(s)

Ideal Candidate

We are looking for someone with at least 5-7 years of relevant experience in managing, drawing insights from data and someone with at least 3 years of experience leading a team
Proven expertise on transportation analytics, analyzing data on daily traffic patterns volumes
ETL data processes and Developing Dashboards to guide critical Business Decisions (using Alteryx, Tableau and SQL)
Working experience in developing tableau driven dashboards
Ability to interpret technical or dashboard structure and translate complex business requirements to technical specifications
Experience in managing, cleaning and analyzing large datasets using tools like Python, R or SAS is plus
Experience in handling client calls and working independently with clients
Domain knowledge of consumer businesses such as pharma and supply chain
Knowledge of working across multiple data types and files like flat files, RDBMS files; Alteryx workflows, Alteryx server, and multiple data platforms (SQL Server, Teradata, Hadoop, Spark); on premise or on the cloud
Basic knowledge of advanced statistical techniques like Decision trees, different types of regressions, clustering, forecasting

Other Skills

Manager - Alteryx