Senior Alteryx Developer

07 Jun 2024

Vacancy expired!

Job Description:Position: Senior Alteryx DeveloperLocation: Northbrook, IL ( Onsite)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 setsLead 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 instancesUnderstand 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 philosophiesAdvanced skills with Microsoft Office Suite with emphasis on ExcelAbility to effectively prioritize and execute tasksStrong analytical, problem solving, and troubleshooting abilitiesAdvanced knowledge of self-service analytic/ETL tools, specifically Alteryx DesignerAbility to follow detailed procedures and ensure accuracy in documentation and dataExperience 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 fieldMinimum 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 aboveAlteryx Level 3 certificationExperience in building, publishing and managing reports/dashboards leveraging Tableau data-cke-eol="1"

  • ID: #42539899
  • State: Illinois Northbrook 60062 Northbrook USA
  • City: Northbrook
  • Salary: Depends on Experience
  • Job type: Contract
  • Showed: 2022-06-07
  • Deadline: 2022-07-30
  • Category: Et cetera