Traded Products Data Analyst Job at Insight Global, Charlotte, NC

NW9QVW40NklEcjdhZ3dOQnBoNldLM25ud3c9PQ==
  • Insight Global
  • Charlotte, NC

Job Description

Job Description Chief Financial Office (CFO) Data Management (CFO DM) is responsible for ensuring data used in key internal and regulatory reports (e.g., FFIEC 101, FRB 2052a, US/DA LCR, etc.) is timely, accurate, and properly controlled. This role will be responsible for supporting Treasury users of Traded Products data (securities, derivatives, collateral, etc), and is focused on driving strategic efforts to resolve data issues and implement data and process improvements. Core functions are: knowing the data, sourcing the data and controlling the data. This includes analysis, design, data derivations, control design, translation of business requirements, issue management, audit/governance support and process/design documentation. Candidates should have extensive work history in several of the following key responsibilities: * Assume ownership of current CFO Data Management controls across multiple finance products. Ownership will include building, delivering and monitoring daily data controls essential for Regulatory Reporting. * Unwind SQL and ETL layers in Oracle database to identify issues/root cause analysis, understand logic/derivations and work with internal and upstream tech partners to resolve issues in a timely fashion * Generate daily and monthly reports on data quality breaks and data validation shifts outside of BAU thresholds * Drives and participates in design, development and implementation of future Treasury data controls * Data Control Governance - Ensuring process controls, data validation activities, and measurement processes remain timely and relevant * Create and maintain required documentation and evidence to ensure adherence to EDM Standards and RDA requirements * Work under minimal supervision on Corporate Treasury projects that require creative solutions under very tight deadlines * Operational Excellence -- Improving CFO Data Management functions for production, data governance, data change and regulatory/audit activities * Change Management -- Validates data and signs off on reports within test environments to confirm application accuracy, functionality and EDM Standards are met * Manage relationships with diverse data partners and technology teams to support initiative work that demand aggressive timelines * Collaborate with PMO Leads to and provide updates on project timelines, deliverables and obstacles / challenging * Create reporting for senior management that proactively provides project status, issue / enhancement tracking and project implementation We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: Skills and Requirements * Traded Products/Capital Markets experience (repo, reverse repo, stock loan/stock borrow, collateral, securities, derivatives, middle office supporting global office) * SQL experience * Bachelor's degree, or higher, in Business / related field, or related work experience. * 3+ years of experience in the Financial Services industry (at BAC or a similarly-sized institution) researching and remediating data issues impacting financial, risk, or regulatory reporting functions, project management or other data management & data control environment; * Advanced knowledge of Microsoft software (Excel, Word, Power Point) including advanced excel functions such as pivot tables, Vlookup and Microsoft Visual Basic (VBA) to supplement SQL skills in data analysis exercises. * Demonstrated experience of key data analysis concepts thru creation of SQL queries (Oracle, Teradata, and/or MS-SQL) to analyze large, complex sets of data, and develop quantitative + qualitative analytical determinations * A balance of strong analytical & problem-solving skills and excellent communication & presentation skills -- the ability to dig into complex issues and then summarize in a clear, concise message to facilitate decisions and drive action; * Must be highly organized and self-motivated, able to work as part of a team in a fast-paced environment and balance multiple priorities simultaneously; * Knowledge and prior experience with Liquidity Reporting / Regulatory reporting * Basic working knowledge of Tableau * Strong knowledge and prior experience with Data Controls monitoring and/or Data Control governance practices * Banking or Financial Experience * Familiarity with BAC Enterprise Data Management Policy & Standards * Treasury background * Familiarity with ETL tools (Informatica) * BI Tools (PowerPivot, Tableau) * Reconciliation experience * Data Warehouse experience

Job Tags

Work experience placement, Work at office, Shift work,

Similar Jobs

Southern Illinois University E

Instructor exercise science Job at Southern Illinois University E

 ...see: Position Title: FA26-008: Instructor (NTT) in Exercise Science\ Location: Edwardsville, IL\ \ \ Southern Illinois University...  ...Edwardsville: School of Education, Health and Human Behavior: Exercise, Sport & Nutr Science \ Location Edwardsville, IL... 

Med Source Consultants

Geriatric Psychiatrist - 951 Job at Med Source Consultants

 ...confidential. *To schedule a time to discuss this in further detail Click Here $$$ Job Type Permanent Specialty Psychiatry/Adult State MI Location MI Port Town *Safe, affordable and recreational Michigan. *Adult or Geriatric... 

Strategic Employment

Junior UX/UI Designer Job at Strategic Employment

 ...re working with a forward-thinking software company based in Costa Mesa, CA, that is seeking a creative and detail-oriented UI/UX Designer to join their dynamic team. This company develops innovative solutions for a diverse client base and is looking for someone enthusiastic... 

Southern Glazer’s Wine and Spirits, LLC

Merchandiser (ABC/Total Wine) Venice/Sarasota, FL Job at Southern Glazer’s Wine and Spirits, LLC

What You Need To Know Shape a remarkable future with us. Build a career working for an industry leader that truly invests in their people and equips them with leading technology, continuous learning, and the ability to bring their best selves to work. As the premier...

Interim HealthCare of Redwood City, CA

- Business Development Representative (BDR) - Career Growth Job at Interim HealthCare of Redwood City, CA

Business Development Representative Redwood City and surrounding areasExperience a culture that values and rewards you for the work you do. As a Business Development Representative for Interim HealthCare, youll join a team of professionals that support each other...