Senior Business Analyst - Data Migration

Senior Business Analyst - Data Migration

Company: Treliant

Website: www.treliant.com

Location: New York

Permanent/Contract: Either 

Treliant is looking for a Senior Technical Business Analyst with knowledge of the financial industry. The successful applicant will be meticulous, objective-focused and technical.  You will perform business analysis and quality assurance to clarify business requirements and confirm business logic and field definitions..

Who are we?

Treliant is a global consulting firm serving banks, mortgage originators and servicers, FinTechs, and other companies providing financial services. We are led by practitioners from the industry and the regulatory community who bring deep domain knowledge to help our clients drive business change and address the most pressing compliance, regulatory, and operational challenges.

We provide data-driven, technology-enabled advisory, implementation, and staffing solutions to the regulatory compliance, risk, financial crimes, and capital markets functions of our clients.

Founded in 2005, Treliant is headquartered in Washington, DC, with offices in New York, London, Belfast, Northern Ireland and Łódź, Poland. For more information visit www.treliant.com.

About the role  

A large focus of the work will be ensuring data integrity and validity, including validating the required automated reconciliations. The scope and nature of the projects on which you’ll work will vary however, examples of duties/responsibilities include:

• Developing process flows
• Validating data sources
• Defining and documenting business requirements and functional specifications
• Performing SQL queries to select datasets for analysis and comparison purposes
• Contribute to solution design
• Define data integrity and validation checks, and collaborate with technology to confirm that the checks are accurately implemented
• Collaborate with business stakeholders to confirm use cases, business logic, and field definitions
• Collaborate with business stakeholders to develop test and migration plans and test cases, perform system testing, and to support UAT and applicable dress rehearsal and migration validations
• Collaborate with technology to remediate issues, and successfully migrate the in-scope data to Snowflake.

Who are we looking for?

Qualifications & Experience

Candidates should preferably have the following:

• Strong educational background - Degree (Masters would be an advantage)
• 10+ years’ experience of working on professional services projects (Ideally for Investment Bank or a Big 4 consulting firm, relevant experience within other professional industries would be acceptable)
• Good experience with SQL and enterprise data warehouses
• Advanced ability to manipulate data in Excel to perform analysis
• Experience with Snowflake or Python a plus
• Good level of product knowledge - Bonds, Repo, OTC Derivative, FX, Commercial loans, Money markets, Deposits, Facilities or Trade finance
• Ideally experience with Regulatory Reporting, Financial Reporting / GL, or Risk Management / Reporting (especially credit risk, but also liquidity risk and market risk)
• Demonstrated ability to navigate uncertainty and independently dig into data to understand data architecture
• Demonstrated willingness to take ownership of streams and issues and drive them to resolution
• Ability to form effective working relationships with developers, stakeholders, and other business analysts
• Experience designing and delivering testing and migration plans involving large data sets
• Experience working in an Agile environment, ideally using JIRA

Professional Skills  

Communication – advanced interpersonal & communication skills.  Able to liaise confidently with senior stakeholders, either over the phone or via email  

Team player – able to work well within dynamic and goal-focused teams  

Process driven – able to become quickly proficient in new processes and systems  

Detail-focused – very strong attention to detail  

Multi-tasking – highly organized and able to balance various responsibilities simultaneously  

Professionally skeptical – able to identify and flag up anomalies for review  

Decision-making – strong decision-making in a fast-paced and pressurized environment  

Commitment – strong work ethic and delivery focused  

---

Primary Location: New York City

Primary Location Salary Range: $157,500 - $232,500

---

​
Why Treliant? 

​

Career Development - We put an emphasis on personal and professional growth by providing all the training you’ll need to become a highly skilled Treliant consultant. Programs cover Finance, Regulatory, Technology, and Operational aspects of investment banking.  On top of that, we also provide support in obtaining highly sought-after industry-recognized qualifications.

Clients – As a Treliant consultant, you will be working with some of the top clients in the financial services marketplace, such as top tier Investment Banks.  Our roles place you at the cutting edge of the projects on which you’ll be working, and give you the opportunity to learn from, work with and build relationships with the very best within those companies.

Rewards – Treliant offers our permanent staff an excellent compensation package. View our full list of benefits here.

Core Values – Whether you are a client or an employee, Treliant wants the best for you.  All our relationships are based on our Core Values: Deliver Excellence, Constantly Innovate, Treasure Diversity, Be Nimble, Listen First, and Develop our People.

Diversity & Inclusion – Treliant is an Equal Opportunity Employer. Treliant, LLC is committed to equal employment opportunity and providing reasonable accommodation to applicants with physical and/or mental disabilities. We value and encourage diversity and solicit applications from all qualified applicants without regard to race, color, religion, creed, national origin or ancestry, ethnicity, sex, pregnancy, sexual orientation, gender (including gender nonconformity and status as a transgender individual), age, physical or mental disability, citizenship, past, current, or prospective service in the uniformed services, genetic information, or any other characteristic protected under applicable federal, state, or local law.​

Right to Work 

Treliant is not in the position to provide sponsorship for this current position and so applicants must be able to work in the United States without requiring sponsorship 

Please note, Treliant receive a high volume of applications for all roles.  While we will endeavour to respond to all applicants, this is not always possible. Should you not receive a response to your application within 2 weeks, it is likely that you have been unsuccessful on this occasion.  However, we would like to retain your details on our systems for 6 months and may contact you should another potentially suitable vacancy arise.