Business/Data Analyst (Strong Excel)

Software Guidance & Assistance, Inc., (SGA), is searching for a Business/Data Analyst (Strong Excel) for a CONTRACT assignment with one of our premier Financial Services clients in Raleigh, NC. Responsibilities :

• To work with directly with our IB Technology partners/application owners to identify critical data elements identified in IB systems of record from downstream data consumers such as Risk, Finance, Operations and Compliance
• To manage specific excel based IT Master Files which provides an historic inventory of data elements per application & line of business (i.e. Equities, Securitized Products etc)
• To support our data governance control leads & key business stakeholders in quarterly CDE ownership meetings to clearly identify such critical data elements with concise definitions as well as supporting technical details such as filenames, fields, activity types etc.to garner data ownership agreements by the various Data Stewards/Owners
• To support metadata management activities to promote all data assets into the enterprise wide tool Collibra using MS Excel templates to register each business line's critical data elements for the IB CDO division
• To work directly with the wider IB CDO Metadata Mgmt team to ensure business objects, business glossary and data lineage are uploaded and recorded in Collibra in an accurate and organized fashion

• Minimum 3-5 years' experience in a business/data analyst capacity in technology supporting a data environment/lifecycle (data lineage experience preferred)
• Minimum 2 years' experience in banking/financial institution industry
• Good understanding/literacy of investment banking/derivative products and the front to back trade lifecycle
• Strong communication skills both written and oral- lead/drive meetings when required
• Good time management skills and proven ability in meeting deadlines and working in a pressurized project team facing high pressure and results-driven team environment
• Intermediate to Advanced proficiency in Microsoft Excel to be able to manage large spreadsheets containing many data points and create macros when required
• Data Tools experience (Collibra, Tableau, Informatica) preferred but not mandatory
• Ability to interact with all SME's (Subject Matter Experts) in both business and technology in all front to back teams in IB, Ref Data, Operations, Risk & Finance & Compliance to support data lineage efforts
• Ability to work with the Enterprise Data Tooling team (EDT) to ensure successful data lineage uploads
• Ability to multi-task numerous projects and/or requirements concurrently
• Ability to communicate effectively and drive project (lineage) meetings when necessary
• Ability to produce both high level and detailed workflow diagrams and PowerPoint presentations when required and drive overall business analysis with interested parties
• Ability to create & comprehend pivot tables/formulas in MS Excel for various data analysis requests
• Ability to support various PMO job functions including maintenance of project status reports, RAID's and financial/budget requests
• Ability to forge solid rapports with all key Investment Banking teams as well as support areas in Risk, Finance, Compliance and Operations
• Ability to work under strenuous schedules when necessary (e.g. greater than 8 hrs)
• Ability to meet time sensitive deadlines largely determined by IB management