Job Purpose
As part of the Data and Technology services practice, you will be working with the data analytics and reporting requirements of a US Regional bank as part of Acuity’s Center of Excellence model.
Global technology megatrends, regulatory developments, competitive landscape and rise of alternative data are changing the way capital markets operate. At the Data and Technology services operations, we partner with some of the largest financial services firms and corporations in this transformative journey. We are looking for professionals who are hands on, passionate about the work and have the ambition to drive disruptive changes to global business models.
Desired Skills and experience
- Strong proficiency in SQL and Python for data extraction, transformation, and analysis.
- Ability to understand and translate loan servicing business concepts into data models, reporting logics and further into automations.
- Solid understanding of data structures across relational databases and cloud platforms.
- Proven experience in stakeholder management and cross-functional collaboration.
- Exposure to GCP and SAS is a plus, but not mandatory.
Key Responsibilities
Collaborate with stakeholders across Consumer and Commercial Lending to understand data needs and translate them into actionable insights.Retrieve, clean, and integrate data from diverse databases and platforms to support reporting and analytics.Ensure data accuracy, consistency, and integrity across all reporting solutions.Perform data preparation activities in support of analytics, reporting and automation. Develop and manage bespoke extract, transform, load (ETL) processes. Create centralized, analytical data marts across various projects to support analysis across multiple business unitsPerform data transformation using Python and SQL for downstream reporting.Support ad-hoc data requests and deep-dive analyses for business and regulatory needs.Translate client challenges into actionable business intelligence solutions by partnering with the subject matter experts at