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
Primary Responsibility
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