- Ability to interact with business users and understand their requirements
- Perform end to end Data validation & Data modeling if required
- Communicate complex topics to team through both written and oral communications
- Take complete ownership of end to end project management from understanding the requirement from business, suggesting improvement (To be process flow), preparing the design document, developing, conducting unit testing and ensuring timely delivery of the project.
- 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
- Prepare technical specifications and documentation for Alteryx workflows supporting BI reports Write Complex SQL queries on multiple tables using complex joins
- Knowledge of Python, tools used and its libraries, should have some bit of hands on coding experience.
- Conduct unit tests and develop database queries to analyze the effects and troubleshoot any issues that arise
- 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
- Provide recommendations to strengthen current processes, controls pertaining to technology platforms
- Understand and document the compensating control for managing or mitigating security risk that might exist due to the technical or business limitation
- Ensure all discussions with business to be documented and change management process to be adhered
- Provide regular updates on assign tasks to team members
- Develop impactful presentations and documents
Skill Set :-
- Technical 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. .
- 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.
Sql (Mandatory) & Python good to have :-
- Develop efficient MS-SQL queries and procedures to extract reports from database Understanding of data modeling and how to implement the same
- Design, build, and maintain efficient, reusable, and efficient Python code along with other common libraries
- Exp. In Tesseract or similar OCR engine and Camelot is preferable
- Hands on experience in pdf data extraction using python libraries and Regex Unstructured to Structured text data processing experience is a plus
- Python deployment experience with pip and wheel packages
- Should be Proficient with GIT.
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 mile
- Other programming experience
- Financial services industry experience
- General knowledge/skills: Databases, Excel, PowerPoint
