Business Systems Analyst / Hadoop HIVE and Big Data 19888 (T5.4:10a)

Company: Yoh, A Day & Zimmermann Company
Location: Albuquerque
Posted on: May 4, 2021

Job Description:

MUST have Video chat/Interview on file



Resource is being brought in to support Hammer regulatory required project. The scope of the project has increased and rolling over to other legal entities the bank is working on



The opportunity will provide the candidate to work with the latest technologies including Hadoop HIVE and Big Data - and will also allow the candidate to build relationships with the business side which learning finance and product control domain knowledge. The team is highly motivated and looking to expand as part of the future vision.



Day in Role:

- Working on Data mining

- Communicating with the business teams and liase requirements

- Ensuring documentation is up to date

- Writing requirements for batch and streaming architecture feeds

- Creating mapping documents with enrichment and transformation logic

- Working with product and technology team to enhance the design and functionality and perform SIT and support UAT for the program

- Assist the Manager/ Project Manager in resolving highly complex, multi-faceted problems.

- Participate in the systems implementation process

- Provide input regarding the assessment of the risk and quality of changes and enhancements

- Provide ongoing feedback to management of project progress

- Works with key stakeholders within all business functions to align technology solutions with business strategies

- Gathers requirements from business units and translates those to programmers and developers

- Prepares cost-benefit and return-on-investment analyses to aid in decisions on system implementation

- Demonstrates an informed knowledge of business functions to resolve problems and capitalize on improvement opportunities

- Supports one or more highly complex business processes

- Works on multiple projects as a project team member

- Serves as a liaison between the business community and the IT organization in order to provide technical solutions to meet user needs



Must Have Skills/Requirements:

- 10+ years of experience in a similar Senior IT Business Analyst Role

- 8+ years of experience working in Feed development projects for Financial and Regulatory reporting

- 8+ years of experience dealing with Product Control IT and obtaining requirements on a clean slate state around trade feed enhancement, MIS reporting and reconciliations

- 8+ years of experience in developing feeds that have amount calculations such as Market Value, Accruals, etc.

- 8 + years of Experience of E2E implementation with the Data Warehousing / Data Factory model

- Advanced SQL and MS Excel skills

- Knowledge of Fed Reports FFIEC 002, 2900, 2644, TIC, etc. - demonstrated in 2+ recent projects

- Strong analytical mindset and be able to perform data mining, ad-hoc SQL scripts, testing (especially be able to turn around reconciliations and testing analysis with some automation in MS Excel)



Nice to Have/Highly Preferred Skills:

- AXIOM/OFSAA reporting experience is highly preferred

- Knowledge of sub-ledgers and intermediate level accounting a plus



Education and Certifications:

- CFA/CPA is a plus

- Degree in accounting/finance discipline preferred



Soft Skills:

- Excellent English verbal and written communication skills are essential

- The role requires leadership skills, hands-on technical experience, and a can-do approach towards environment automation / management and continuous improvement for efficiency and cost effectiveness

- Must be reliable, proactive, results-oriented, customer-focused and attentive to details.

- Must be flexible to adapt to a dynamic environment, make quick and sound decisions under pressure

- Strong organizational skills, excellent problem-solving, communication, and collaboration skills

- Strong analytical mindset and be able to perform data mining, ad-hoc SQL scripts, testing (especially be able to turn around reconciliations and testing analysis with some automation in MS Excel)



Interview Process:

1 Step Process: 1 Skype/Microsoft Interview

2nd round if necessary





Yoh, a Day & Zimmermann company, is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. Visit https://www.yoh.com/applicants-with-disabilities to contact us if you are an individual with a disability and require accommodation in the application process.PandoLogic.Category: Technology, Keywords: Business Systems Analyst

Keywords: Yoh, A Day & Zimmermann Company, Albuquerque , Business Systems Analyst / Hadoop HIVE and Big Data 19888 (T5.4:10a), Professions , Albuquerque, New Mexico