Valuation Controller - Automation, Developer - Associate

As a Automation Associate in our Finance team, you will spend each day defining, refining and delivering set goals for our firm The Valuation Control Group (VCG) is organized along business lines, including Corporate & Investment Bank (Macro Products, Credit, Equities, Securitized Products, IB Risk), CIO, Treasury & Corporate (CTC), Asset Management, Consumer & Community Banking (CCB), and Commercial Banking (CB). Your clients will include senior management, business heads, regulators, and both internal and external audit teams. The group also collaborates closely with Traders, CFOs, Market Risk, and Middle Office to ensure a comprehensive understanding of business issues and the accurate execution of valuation policy. As an Associate within the VCG team, your primary responsibility will be to work on automation and redesign of existing implementations using tools such as Python, Alteryx, Excel VBA, and BI tools like Tableau. Job responsibilities Automate Excel tasks by developing Python scripts with openpyxl, pandas, and xlrd, focusing on data extraction, transformation, and generating reports with charts and pivot tables. Design and deploy interactive web applications using Streamlit, enabling real-time data interaction and integrating advanced analytics. Utilize Matplotlib and Seaborn to create charts and graphs, adding interactive features for dynamic data exploration tailored to specific business needs. Design intuitive user interfaces with PyQt or Flask, integrating data visualizations and ensuring secure access through authentication mechanisms. Perform data manipulation and exploratory analysis using Pandas and NumPy, and develop data pipelines to maintain data quality and support analytics. Write scripts to connect to external APIs, process data in JSON and XML formats, and ensure reliable data retrieval with robust error handling. Collaborate with cross-functional teams to gather requirements, provide technical guidance, and ensure alignment on project goals, fostering open communication. Demonstrate excellent problem-solving skills and the ability to troubleshoot and resolve technical issues. Adhere to the control, governance, and development standards for intelligent solutions. Exhibit strong communication skills and the ability to work collaboratively with different teams. Required qualifications, capabilities, and skills Bachelors degree in Computer Science, Engineering, or a related field. Proven experience in Python programming and automation. Experience with Python libraries such as Pandas, NumPy, PyQt, Streamlit, Matplotlib, Seaborn, openpyxl, xlrd, Flask, PyPDF2, pdfplumber and SQLite . Analytical, quantitative aptitude, and attention to detail. Strong verbal and written communication skills.