Financial Data Warehouse

Greetings,

We have an immediate vacancy for a Financial Data Warehouse with 7 years of experience at Synechron, based in Glasgow

Job Role: - Financial Data Warehouse

Job Location: - Glasgow

About Company:

At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps, Data, and Software Engineering, servicing an array of noteworthy financial services and technology firms. Through research and development initiatives in our FinLabs we develop solutions for modernization, from Artificial Intelligence and Blockchain to Data Science models, Digital Underwriting, mobile-first applications and more. Over the last 20+ years, our company has been honored with multiple employer awards, recognizing our commitment to our talented teams. With top clients to boast about, Synechron has a global workforce of 14,700+, and has 58 offices in 21 countries within key global markets. For more information on the company, please visit ourwebsiteorLinkedIn community.

Diversity, Equity, and Inclusion

Synechron’s Diversity, Equity, and Inclusion (DEI) program, Same Difference, was developed because we believe in a culture of listening, respect, and opportunity.

We each bring unique backgrounds, thoughts, talents, and experiences with us to work every day, and we know that by embracing them, we are creating an even greater Synechron. The best way to build a strong team is to value individual differences. So, it doesn’t matter where you’re from or what you’ve had to do to get here – if you have the skills, enthusiasm, and drive to make your mark, we’ll support you like we support each other. Choose a career with us and let’s pursue innovation, together.

About the Department:

Treasury, Planning & Capital Technology - Deliver the technology products used to size and manage the firm's liquidity, unsecured funding and capital resources. This includes intraday liquidity and cash management; calculation, forecasting and stress testing of liquidity and capital measures; resolution planning; budgeting and financial planning including forecasting of revenue, expenses, and balance sheet; accessing unsecured funding markets; and delivering firmwide management reporting and analytics. Our key internal clients include Treasury, Capital Planning, Financial Planning & Analysis (FP&A), Cash Management Operations, Global Corporate Controllers (GCC) and the ISG, Wealth Management and Investment Management Finance Teams.

1. Overview of Current Challenges:

• There is a collection of ad hoc requirements being built without a cohesive strategy.
• The data ecosystem is fragmented, lacking integration across various components including subledgers, general ledgers, and forecasting.
• Derivatives trading market values feed into approximately 30 different finance processes, with data sourced from 5 or 6 hubs used across different processes and platforms.

2. Finance Data Warehouse (FDW) Development:

• Around five years ago, the initiative to develop a Finance Data Warehouse (FDW) was launched to create a consolidated entry point into finance.
• The FDW serves as a distribution point for all downstream processes, allowing for data sourcing, control, adjustment, curation, and distribution.
• A significant volume of data enters the FDW, with numerous consumers relying on it.
• The data landscape is more varied and disparate than previously anticipated.

3. Data Challenges and Evolution:

• Loans data has expanded from 5 use cases to 30 use cases, highlighting the need for a solid foundation.
• The project initially focused on derivatives, which presented substantial challenges due to the complexity of 7 upstream systems and multiple asset classes.
• The data model evolved significantly from being product-specific to a product-agnostic model that branches into more granular asset-class types.
• Although the process of getting data into the warehouse was relatively straightforward, encouraging downstream consumers to adopt this data has proven very difficult.
• The quality of data remains a critical issue, with poor data quality leading to economic impacts for the firm.

4. Current Goals:

• Goal 1: Accelerate the adoption of data within the FDW, ensuring that the purpose of FDW data is incorporated into downstream processes.
• Goal 2: Position the FDW as a platform for effort and risk reduction, enhancing controls over finance and helping to manage data-related risks. The benefits of adoption from a control perspective have not met expectations, necessitating the development of automated controls to facilitate greater adoption.
• Goal 3: Address regulatory focus on data governance. Recent audits (BCBS 239 and Co-Rep) have emphasized the need for transaction testing and data lineage. The FDW should align with increasingly stringent regulatory standards for governance and control.

5. Discussion Points:

• Downstream Consumers:

• The majority are end-user computing (EUC) applications and enterprise user applications (EUA), with a total of 12,000 EUCs in use.
• The FDW acts as a pre-processed finance data platform, facilitating calculation and curation.
• While some EUCs are directly connected to the FDW, most operate on industrial-strength systems.

6. Projects and Initiatives:

• Pat is currently working on an EUC decommissioning program.
• Preparations for the Comprehensive Capital Analysis and Review (CCAR) audit are underway, focusing on ensuring data lineage and governance controls.
• The FDW is currently based on a Teradata database but is transitioning to Snowflake, with some early adopters already utilizing the new system. Pat's team is exclusively focused on cloud solutions, replicating and copying data into Snowflake, while managing a dual-environment situation.

7. Additional Notes:

• Snowflake provides automatic lineage tracking for data, enhancing visibility from table to view and across the data stack.
• The FDW is connected to the firm’s data program, which includes a firm-wide data catalogue detailing key data elements.

Skills Required

• Java and/or Scala Backends
• Distributed compute concepts: Spark, Data Bricks, Apache Beam etc
• Full Stack experience
• Azure Cloud Technologies
• Angular/Similar front end
• Cloud DB / Relational DB: Snowflake / Sybase
• Unix experience

Job Responsibilities

• Designing and developing server-side components that meet the business requirements in an effective and efficient manner.
• Directly interfacing with business users in understanding the requirement and providing solutions.
• Assisting & guiding team members in design and development.
• Partnering along with the leads to identify and mitigate risks and escalate issues as necessary.
• Ensure code quality and automated testing standards, be a part of regular code reviews and ensure quality gates are upheld and enhanced.
• Working on the cloud migration efforts to build the next generation platform for Treasury
• 7-10 years of work experience in software development.
• Should have hands-on experience with Java, Scala, Spark, and SQL.
• Strong knowledge of multi-threading and high-volume server-side development.
• Experience with Snowflake, PowerBI and Cloud platforms is a plus.
• Should possess good architectural knowledge and be aware of enterprise application design patterns.
• Basic working knowledge of Unix/Linux.
• Exposure to Test and Behaviour Driven Development in agile setup is a huge plus
• Exposure to JavaScript framework like Angular is desirable
• Excellent communication, team-work and interpersonal skills.
• Desire to learn the business domain and partner with stakeholders to specify new business features
• Strong analytical capability and problem-solving skills.
• Bachelor of Science in Computer Science or relevant technical degree.