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
  
  

(ref:hirist.tech)