Job Search
Senior Business Analyst, Data Migration at Treliant
Senior Business Analyst, Data Migration
@
Treliant

Key information

Apply now
Posted on: 
September 11, 2023
Views count:
0

Summary of the Senior Business Analyst, Data Migration job at Treliant

Treliant is hiring a Senior Business Analyst, Data Migration with 5 - 10 years of experience. Based in United States - New York, NY and with Hybrid ways of working. The expected salary range for this role is $157,500 - $232,500
About Treliant

Treliant is an essential, consulting firm serving banks, mortgage originators and servicers, fintechs, and other companies providing financial services globally. 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 across the United States, Europe, and Asia.

Senior Business Analyst, Data Migration - Job Role & Responsibilities

We are currently 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.

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
Senior Business Analyst, Data Migration - Job requirements

Qualifications & Experience

  • Strong educational background - Degree (Masters would be an advantage)
  • 1 0+ 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 anomalies for review

Decision-making – ability to make decisions in a fast-paced and pressurized environment.

Commitment – strong work ethic and delivery focused

What we offer at Treliant

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

Please mention “I found this job at DataAnalyst.com!” in your application, it will help us offer you more opportunities

insertpageurl
Thank you for reporting
Oops! Something went wrong while submitting the form.

What about the salary?

Average business analyst salary in the Consulting industry is $106,285.
Salary Guide

Apply now

Please mention: “I found this job at BusinessAnalyst.com” in your application, it will help us offer you more opportunities.

Apply now
Treliant

Treliant

is hiring

Senior Business Analyst, Data Migration

Website:
Posted on: 
May 27, 2024

About Our Company

Treliant is an essential, consulting firm serving banks, mortgage originators and servicers, fintechs, and other companies providing financial services globally. 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 across the United States, Europe, and Asia.

Job Description & Responsibilities

We are currently 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.

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

Requirements

Qualifications & Experience

  • Strong educational background - Degree (Masters would be an advantage)
  • 1 0+ 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 anomalies for review

Decision-making – ability to make decisions in a fast-paced and pressurized environment.

Commitment – strong work ethic and delivery focused

What we offer

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

Apply now

Featured business analyst jobs