EY Senior Consultant; Data Management Financial Product in Albany, New York
Senior Consultant; Data Management Financial Product
Requisition # UNI00HN3
Post Date Mar 21, 2021
EY is the only professional services firm with a separate business unit (“FSO”) that is dedicated to the financial services marketplace. Our FSO teams have been at the forefront of every event that has reshaped and redefined the financial services industry. If you have a passion for rallying together to solve the most complex challenges in the financial services industry, come join our dynamic FSO team!
We are currently seeking highly motivated senior consultants to support financial product subledger implementations at financial institutions, and to help support various internal and account-driven business development activities related to financial products, finance data and finance technology. The ideal candidate has financial product accounting, reporting and/or data experience within banking, insurance or asset management.
Support project workstream(s) within multi-faceted financial product subledger implementation projects at large financial services institutions including data modeling & finance reporting
Demonstrate technical capabilities across financial products, including accounting, reporting and data including:
Documenting and maintaining data requirements for the subledger application including Instrument data (e.g., security master), Portfolio static data (portfolios, bank accounts, custodians, settlement instructions, etc.), Market data (prices, rates, etc.), Accounting reference data (chart of accounts, posting rules, etc.), Accounting event data, Subledger postings & balances data
Working with software vendor subject matter experts to gain a working knowledge of the software product business logic and data architecture
Configuring / developing data input & extract routines for inbound and outbound interfaces
Developing and refining data conversion scripts to convert subledger data from old system to new system
Executing multiple data conversion rehearsals to refine conversion scripts & processes
Reconciling opening subledger account balances to the legacy system and general ledger
Researching and resolving testing defects that are caused by inaccurate or missing data
Producing ad hoc queries and reports to assist in business analysis and project execution
Leading the final data conversion for Production deployments
Training system users (including static data team members) on data maintenance issues and procedures.
Providing post- “go-live” support to system end users for data related matters
Participating in project planning and status updates
Assisting project managers in developing schedules and budgets for data conversion workstream activities.
Deliver high-quality client solutions/work products that meet and exceed client expectations and are delivered on-time and within agreed to budget.
Support service delivery including but not limited to defining project approach, leading and motivating project work streams, monitoring and managing project risks, managing stakeholders, and successfully delivering client solutions.
Demonstrate technical capabilities and professional knowledge, and stay current with industry practices and accounting & regulatory guidance.
Minimum of 2 years of professional work experience at a financial services company (bank, insurance or asset management company) or comparable experience working as an advisor to a financial services company orminimum of 2 years of consulting experience, providing advisory services in finance area (finance and accounting systems implementations a plus.
1+ years of experience with relational databases (Oracle, Teradata, SQL Server, DB2, etc.)
Data Management Skills & Experience:
Knowledge in ETL tools, SQL query tools and Transact SQL (SQL Server v2005-2008), Experience in the use and creation of data lineage models. Experience with the use of entity relationship models. Experience with SQL server performance tuning and monitoring.
Experience building data models for financial products including payments, deposits, loans, securities, debt, derivatives, insurance contracts, reinsurance, etc.
Experience in assisting with design/ implementation of data and technology solutions related to financial product subledgers (i.e., SAP AFI, Oracle FAH, SimCorp, PAM, Calypso, Mysis Summit, Microgen Aptitude etc.)
Financial services industry experience
Experience participating/leading resources through full life-cycle improvement efforts
Documentation skills including data requirements, data flows, data lineage
Working collaboratively in a team environment
Ability to develop / foster business relationships with mid to senior-level executives / sponsors
Excellent oral and written communication skills
Strong analytical and problem solving skills
Project management skills
Willingness to travel
Bachelors degree in Computer Science, Information Systems, Business Management, etc.
MBA and/or professional certification (e.g. CPA, CFA) preferred.
Technical/vendor certifications a plus but not mandatory.
What we look for
We look for the individual who has the ability to adapt and willing to collaborate in changing circumstances. You will have the dedication and commitment to lead the project and guide junior team members to reach the end goal efficiently and effectively.
What working at EY offers
We offer a competitive compensation package where you’ll be rewarded based on your performance and recognized for the value you bring to our business. In addition, our Total Rewards package includes medical and dental coverage, both pension and 401(k) plans, a minimum of 15 days of vacation plus ten observed holidays and three paid personal days, and a range of programs and benefits designed to support your physical, financial and social well-being. Plus, we offer:
The opportunity to manage a portfolio of talent within a designated service line
A collaborative environment where everyone works together to create a better working world
Excellent training and development prospects, both through established programs and on-the-job training
An excellent team of senior colleagues, dedicated to managing and varying your workload
As a global leader in assurance, tax, transaction and advisory services, we hire and develop the most passionate people in their field to help build a better working world. This starts with a culture that believes in giving you the training, opportunities and creative freedom to make things better. So that whenever you join, however long you stay, the exceptional EY experience lasts a lifetime.
Make your mark.
EY provides equal employment opportunities to applicants and employees without regard to race, color, religion, age, sex, sexual orientation, gender identity/expression, national origin, protected veteran status, disability status, or any other legally protected basis, in accordance with applicable law.