Job description
JOB DESCRIPTION
Background:
- HBI Finance is implementing a transformational data platform solution to become the “single source of truth” for financial data.
- A large driver of the transformation is to create a new infrastructure to ensure Finance end-users are provided reconciled and validated atomic data. This is in stark contrast to the existing data environment where material manipulations happen in an under-documented fashion through multiple systems’ ETLs
- The bank has prioritized regulatory reporting and liquidity stress testing as the most urgent end users who need clean data. Asset/Liability Management (and the QRM system in particular) is a fast follower
- We expect that some – but not all – of the work cleaning data used by reg reporting and liquidity will be beneficial to the ALM team / QRM system, but there are material gaps that need to be addressed specific to modeling use-cases.
- A key aspect of this transformation is to migrate where in the data flow to perform ALM/QRM-specific transformations, e.g., product or risk segmentations bespoke to the QRM engine:
- Currently, most of these happen in the final data step (during the creation of the Current Position Data table or CPD), and then ingested into QRM
- We envision changing this so that the final pre-QRM data step only contains atomic data shared across Finance. QRM-specific transformations, segmentations, etc migrate into the QRM environment.
- This position will have solid-line reporting to the Head of Balance Sheet Management, and dotted-line reporting to the head of the Finance Data Transformation program. The expectation is that this individual will represent the BSM group at key scheduled and ad hoc progress meetings. This position is fully remote.
Envisioned worksteps (NOTE: DRAFT AS OF AUG 4):
- Do a full diagnostic of the data used by QRM-ALM today. Identify every field that's relevant to the successful execution of ALM forecasts
- For each data element identified above, identify which of the fields are:
- Already being migrated from existing infrastructure to the Finance data mart through Regulatory Reporting or Liquidity/2052a workstreams
- Not yet on the roadmap for migration
- For all elements in 2a, verify that the specific implementation is fit for use by the QRM engine. For all elements in 2b, work with the appropriate data partners to ensure the appropriate data element is made available in the data lake
- Reprogram the QRM application, where necessary, to migrate QRM-specific transformations out of the pre-QRM data table and into the QRM application’s ETL module
- Partner with the ALM Production team to demonstrate the regression testing that key IRR metrics exhibit no material changes driven by the change in data flows.
- Provide testing documentation describing the data lineage consumed by the QRM stratification, data validation approach, and regression model testing results.
- Develop procedural documentation for use by QRM support team to maintain the new ETL process.
TECHNICAL SKILLS
Must Have
- QRM System Experience
Job Types: Full-time, Contract
Pay: $70.00 - $80.00 per hour
Schedule:
- 8 hour shift
- Monday to Friday
Experience:
- ALM: 5 years (Required)
- QRM: 2 years (Required)
- Regulatory reporting: 1 year (Required)
- ETL: 1 year (Required)
Work Location: Remote
arclintfl.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, arclintfl.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, arclintfl.com is the ideal place to find your next job.