Data Analytics Analyst, R SAS

Responsibilities:

• Manage and execute (run) Python and SQL scripts to support various weekly and monthly Finance process.
• Debug emerging issues.
• Optimize redundant or sluggish code.
• Maintain and occasionally develop documentation of processes and code.
• Develop new and modify existing Python and SQL scripts to enable greater automation across Finance and Treasury processes.
• Develop, QA Testing and deployment.
• Engage and support Model Governance.
• Prepare appropriate documentation.
• Develop visualizations in support of business practices including pricing and profitability analysis.
• Migrate existing excel models into Tableau.
• Employ Python solutions where feasible to improve efficiency.
• Respond to ad hoc data requests and visualization requests as needed.
• Work closely with Finance, Risk and Commercial lending teams to understand business needs.
• Prepare data and solutions for future ingestion into TFSB data lake (EDP 2.0)

• Knowledge of structured data and relational databases
• SQL
• SAS, R
• Python
• Tableau

• Programming knowledge: C#, .net or others
• Experience commercial lending products
• Web development
• API development and deployment
• Data transfer knowledge (mulesoft, MFT, etc.)