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.

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)
• 5+ 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)
• Experience with Axiom / Axiom Controller View / AxiomSL / Adenza
• Experience with some or all of the following reports preferred: FR Y-14 Series (CCAR 14M, 14Q, 14A), FR Y-9C & FFIEC 031/041(Call Reports), FR 2052a, FR Y-15
• Good experience with SQL and sourcing and transforming data from enterprise data warehouses
• Advanced ability to manipulate data in Excel to perform analysis
• Experience with Snowflake or Python a plus
• Experience applying changes to reports and customizing fields
• Good knowledge in one or more of the following products: bonds, financings, OTC derivatives, FX, loans, deposits, money markets, facilities, trade finance
• Ability to form effective working relationships with developers, stakeholders, and other business analysts
• Demonstrated willingness to take ownership of streams and issues and drive them to resolution
• Experience working in an Agile environment, ideally using JIRA
• Experience designing and delivering testing and migration plans

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