Business Analyst - DMO Data Lineage

Business Analyst - Data Management Office

Financial Services

Company: Treliant Capital Markets

Website: www.Treliant.com

Location: New York

Permanent/Contract: either

We are looking for Business Analyst - Data Management Office professional to join our New York team where you will work on a variety of projects supporting our Investment Banking clients.

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

The scope and nature of the projects on which you'll work will vary however, examples of duties/responsibilities include:

• Provide Technical services for the DMO team to support the following activities DMO performs:
• Data Quality:
  • Maintain Data Quality rules in IBM InfoSphere for select processes onboarded by DMO
  • Work with DMO Function Leads and their supports to create new Data Quality Rules by interpreting technical details / SQL Queries etc. that would help create logic for capturing data quality issues
  • Rationalize Data Quality rules to maintain an up to date list and delete redundant rules based on system's structure
  • Troubleshoot IBM technical issues and manage upgrades
  • Support DMO production processes on daily basis
  • Utilize Manta tool for producing Data lineage automatically
  • Technical documentation, Data Flow diagrams, SQL Queries, Stored Procedures, and SSIS packages in order to document Data Lineage manually
  • Troubleshoot Manta technical issues and manage upgrades
  • Automate DMO function monitoring

Who are we looking for?

Qualifications & Experience:

• 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 knowledge of Banking products
• At least 5+ Years working with Data management tools such as IBM InfoSphere and Manta, implementation of Data Quality Rules, and Manual/Automated Source to Target data lineage
• Advanced SQL Writing skills
• Programming experience in VBA / .NET / C#, Advanced Excel skills
• Good understanding of investment banking organizations, processes and platforms
• Able to operate at both high level and also at low level of detail
• Strong affinity for data and a good understanding of best practice for ensuring high data quality in processes
• Excellent communication skills, comfortable engaging with management and stakeholders, business and technology

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

Why Treliant?

Career Development - We put an emphasis on personal and professional growth and provide all the training you'll need to become a highly skilled Treliant consultant, with programs covering Finance, Regulatory, Technology and Operational aspects of investment banking. On top of that, we also provide support in obtaining highly sought-after industry-recognised 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 giving you the opportunity to learn from, work with and build relationships with the very best within those companies.

Rewards - Treliant offer our permanent staff an excellent compensation package, including generous Base Salary, Bonus, Holiday package, Medical, Dental, Vision and Life Insurance and Pension Scheme.

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: Innovation, Nurture, Solutions, Potential, Inclusiveness, Resilience & Evolution.

Diversity & Inclusion - We value inclusiveness and aspire to reflect this in our workforce. We welcome applications from people from all sections of the community, irrespective of ethnicity, gender, age, disability, sexual orientation, religion or belief.

 

Right to Work

Treliant Capital Markets 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 Capital Markets 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.