Alteryx Developer - ETL (4-7 yrs)

Job Description :

Role & Responsibilities :

- Design and develop ETL workflows and Datasets/Datamarts in Alteryx to be used for visualization.

- Solid, deep experience with data extract, transform and load (ETL) tools as Alteryx and high-level knowledge on data visualization tools (Pref Tableau/Power BI).

- Prepare technical specifications and documentation for Alteryx workflows.

- ETL specific for creating datasets (to be used by Tableau Data Extract for BI)

- Write Complex SQL queries on multiple tables using complex joins.

- Perform end to end Data validation.

- Ability to interact with business users and understand their requirements.

- Develop impactful presentations and documents.

- Communicate complex topics to team through both written and oral communications.

- Ensure data is stored effectively and provide the ability to maintain the data analytics platform, so that data can effectively be mined for information later.

- Conduct unit tests and develop database queries to analyse the effects and troubleshoot any issues that arise.

- Evaluate and improve existing systems that are in place as well as collaborating with teams within the business to integrate these new systems to streamline workflows.

- Develop and update technical documentation for senior leaders and colleagues to serve as a reference guide.

- Understand if there is technical or business limitation to implement technology control/configuration.

- Understand and document the compensating control for managing or mitigating security risk that might exist due to the technical or business limitation.

- Provide recommendations to strengthen current processes, controls pertaining to technology platforms.

- Provide regular updates on assign tasks to team members.

Technical Mind Set :

- Alteryx (Mandatory)

- 2+ years of related experience with Alteryx

- Hands-on skills and experience in Alteryx Designer, Alteryx Scheduler, Alteryx Server (good to have), and the tools with Alteryx such as Predictive, Parsing, Transforms, Interface (good to have)

- Experience with data ETL (SQL, Alteryx) and ability to manipulate data and draw insights from large data sets.

- 2+ years writing SQL queries against any RDBMS with query optimization.

- Strong analytical, problem solving, and troubleshooting abilities.

- Good understanding of unit testing, software change management, and software release management

- Good understanding the star schema and data models in the existing data warehouse.

(Desirable) tool knowledge :

- Python Experience will a definite plus

- Any other ETL experience will be definite plus.

Essential :

- Strong communication skills and analytics

- Self-Starter and able to self-manage.

- Ability to prepare accurate reports for all levels of staff in a language and tone appropriate to the audience.

- Good team player, ability to work on a local, regional, and global basis.

- Able to perform under pressure.

- Ability to drive to succeed and go beyond the extra mil