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.

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

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