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
- Excellent communication skills (both written and oral)
- Ability to create client ready deliverables in Excel and PowerPoint