Senior Alteryx Developer

Position: Senior Alteryx Developer
Location: Northbrook, IL
Duration:12 months.

Position Summary:
The developer will be responsible for researching and extracting pertinent data points within multiple source systems (SAP, SQL etc.) while developing analytical reporting solutions.

As a Alteryx Developer, you will also be involved in automating the process which collects data from various sources, blending and performing calculations using Alteryx;

Involved in setting up Alteryx server and host a Gallery with private studio for separate accounts 
PRINCIPAL DUTIES AND JOB RESPONSIBILITIES:
Design and develop ETL workflows and datasets in Alteryx to be used by the BI reporting tool. ETL specific for creating datasets (to be used by Tableau Data Extract for BI)
Will write complex SQL queries with multiple joins to automate/manipulate these extracts in Alteryx.
Works in partnership with the other IT teams and stakeholders concerning the accuracy of data and efficiency of processes.
Prepare technical specifications and documentation for Alteryx workflows supporting BI reports.
Perform end to end Data validation to maintain accuracy of data sets
Lead discussions with business partners to identify functional requirements resulting in data acquisition for BI applications.
Translate business logic from one system (Excel, SQL, etc) into Alteryx in a quick and accurate manner.
Develop re-useable processes that can be leveraged and standardized for multiple instances
Understand the existing source system data models.
Ensure application stability and performance by monitoring existing workflows to ensure they are working correctly and that they reconcile with the source.
Provide ad-hoc data analysis and support to business functions.
Qualifications:
KNOWLEDGE AND SKILLS REQUIRED:
Advanced knowledge of SQL, database technologies and data warehouse design philosophies
Advanced skills with Microsoft Office Suite with emphasis on Excel
Ability to effectively prioritize and execute tasks
Strong analytical, problem solving, and troubleshooting abilities
Advanced knowledge of self-service analytic/ETL tools, specifically Alteryx Designer
Ability to follow detailed procedures and ensure accuracy in documentation and data
Experience working with SAP data will be strongly preferred

KNOWLEDGE AND SKILLS PREFERRED:
Competency of BI tools (Tableau)
Highly proficient in Microsoft Excel to analyze data and report results using pivot tables, charts and graphs
EDUCATION AND EXPERIENCE REQUIRED:
Bachelor's degree in Computer Science, Management Information Systems, Informatics or similar analytical field
Minimum 3 years of related experience with Alteryx.
Minimum 3 - 5 years writing SQL queries against any RDBMS with query optimization.
Ability to gather and document business requirements.
Minimum 3 - 5 years of experience in working with relational database systems OR Master's degree in a field mentioned above with 2-3 years of experience
EDUCATION AND EXPERIENCE PREFERRED:
Master's degree in any of the fields mentioned above
Alteryx Level 3 certification
Experience in building, publishing and managing reports/dashboards leveraging Tableau