Data Analyst

Data Analyst/ Business Analyst - Process Automation & Reporting

Client: Bank

Location: Charlotte, NC 28202 – Hybrid Schedule (2 day remote weekly)

Duration: 6 months contract to start, potential to extend down the road

Typical Hours: 40 hrs/ wk

Pay-range: 45-47/hr

Note: Please only Apply - If you are Local and can go onsite - 3 day.

Must Haves:

• Xceptor or Alteryx
• 4 years of building out process improvement/automation solutions
• Capital Markets/Investment Banking Background
• Can be: fixed income cash (bonds), OTC Derivatives (interest rate, commodities, equities, fx options), Core FX (swaps forwards), equity cash (stocks, exchange traded, convertible bonds)

Plus:

• PowerApps
• STP processing, process simplifications, operational control enhancement
• AI exposure
• Strong reporting skill

Day to Day:

• This Process Automation Engineer will join the Corporate Investment Banking Operations LOB at bank.
• This person will be in charge of the end to end data analytics and reporting lifecycle for a few different workstreams within the group.
• They will take over the current manual reporting work and build scalable, automated data frameworks with the help of the technology team.
• A day in the life looks like pulling data from multiple different systems within CIB Operations, creating custom logic / approximations, and consolidating it to present to senior leadership.
• As an example, some of these reports could be used for capacity planning, STP/RFT reporting, etc.
• Since this person will be working with owners of different operational data, it's imperative this person has a background in capital markets. It doesn't have to be an expert, but this person should be able to distinguish bonds vs derivatives, or futures vs options.
• Data sets can range from 5 rows to 1500 rows depending on the report, so this person should have very senior analytical skill, as well as be able to utilize python to simplify the analytics process.

Project Background - Why/Mission:

• Te HM is seeking a Process Automation Engineer to join her team within the Corporate Investment Banking Operations LOB at bank.
• This person will be working within the Intelligent Automation space, building out solutions for automating the CIB operations processes.
• A lot of the current processes are manual and often require excel extractions.
• This person will be in charge of building out solutions utilizing XCeptor, and/or PowerApps to automate those different processes.

The Company offers the following benefits for this position, subject to applicable eligibility requirements: medical insurance, dental insurance, vision insurance, 401(k) retirement plan, life insurance, long-term disability insurance, short-term disability insurance, paid parking/public transportation, paid time off, paid sick and safe time, hours of paid vacation time, weeks of paid parental leave, and paid holidays annually – as applicable.