• Design and develop ETL workflows and datasets in Alteryx to be used by the BI
• Solid, deep experience with data extract, transform and load (ETL) tools as Alteryx and data visualization tools
• Prepare technical specifications and documentation for Alteryx workflows supporting BI reports
• Create dashboards and reports within Tableau based on written requirements
• Design, build, and deploy proof of concept solutions and create advanced BI visualization
• Reporting tool. 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 at a later date
• Conduct unit tests and develop database queries to analyze 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
Mandatory:
Alteryx (Mandatory)
• 2+ years of related experience with Alteryx
• Hands-on skills and experience in Alteryx Designer, Alteryx Server, and the tools with Alteryx such as Predictive, Parsing, and Transforms.
• 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:
• 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 mile
• Other programming experience
• Financial services industry experience
• General knowledge/skills: Databases, Excel, PowerPoint
Source link
