Data Automation Analyst

Domain: Banking
Job Title: Data Automation Analyst / Process Engineer

Location: Charlotte, NC 28202 (550 S Tryon)

Duration: 6 months + Contract to hire/extendable

Job Type: Hybrid Role - 3 day in office, 2 day remote weekly

Schedule: Mon-Fri: Basic Business hours

Start Date: ASAP - Apply Now!

Pay-range: $45-47/hr

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 , paid sick and safe time , hours of paid vacation time, weeks of paid parental leave, paid holidays annually - AS Applicable)

Job Description:

• This Data Automation Analyst 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 skills, as well as be able to utilize python to simplify the analytics process.

Must Haves:

• Alteryx OR Xceptor


• 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)

Skills/Plus:

• PowerApps


• STP processing, process simplifications, operational control enhancement


• AI exposure


• Strong reporting skills