Senior Data Support Analyst

Jobtailor; New Jersey; On-site; USD 80,000 - 120,000; Full time

Job summary

Jobtailor seeks a data governance specialist in New Jersey to manage large data sets, develop SQL queries, and ensure data lineage and quality across risk reporting systems.

You will collaborate with Risk, Technology, Compliance, and Operations to implement controls and improve data accuracy through EUC and PDE lineage documentation, while leveraging AI tools to automate governance tasks.

Qualifications

• 2+ years experience in data management with very large datasets.
• Knowledge of database architecture and large data warehouses.
• Ability to develop and interpret basic SQL statements.
• Advanced Excel skills for large, multi-tab spreadsheets.
• Ability to leverage AI to automate data governance activities.

Responsibilities

• Proactively monitor and remediate data used in risk measurement and reporting.
• Ensure completeness, validity, and accuracy of data daily.
• Work with business data users to define data use in risk systems.
• Collaborate with technology to ensure timely operation of risk models and reporting systems.
• Implement effective risk controls of data processes and systems.
• Participate in user acceptance testing of data control processes.
• Coordinate with Middle Office, Sales & Trading, Technology, Compliance, Operational Risk, and ECM for data controls over GMRM.
• Maintain EUC data lineage and PDE data lineage documentation in Enterprise tools.

Skills

Data Management

SQL Development

Microsoft Excel

Data Governance

Data Analysis

Data Quality Assurance

Data Lineage

Risk Data Aggregation

EUC Computing

Data Reporting

Data Validation

Tools

PowerPoint

DQC Toolkit

AI Copilot

Job description

• May manage or supervise a small group.
• Proactively monitor and remediate incoming data used in risk measurement and reporting.
• Ensure the completeness, validity, and accuracy of data on a daily basis.
• Work with business data users to define the use of data within risk systems.
• Work closely with technology to ensure the timely and accurate operation of risk models and reporting systems.
• Implement effective risk controls of our data processes and systems.
• Participate in user acceptance testing of data control processes.
• Work with other groups as needed, including Middle Office, Sales and Trading, Technology, Compliance, Operational Risk, and Enterprise Capital Management to ensure effective controls over data for GMRM.
• Establish and maintain compliance with the Enterprise Data Management Standards related to:
  • Work with report preparers to document, update and maintain end user (EUC) computing lineage for existing and new Risk Data Aggregation (RDA) reports
  • Integration (stitching) and sustainment of EUC and technical PDE data lineage from the report back to one hop outside of Credit Risk
  • Maintaining EUC lineage in Enterprise tools (DQC Toolkit)
  • Performing quality assurance analysis on data lineage
  • Updating asset flow diagrams
  • Facilitate validation that the inputs into the Critical Risk Figures (CRFs) are fit-for-purpose including analysis of discrepancies, tracking and coordinating remediation efforts
  • Track and report on status of project deliverables

Requirements

• 2 + years experience in data management working with very large data sets
• General knowledge of database architecture and experience working with large data warehouse systems and relational databases
• Ability to develop and interpret basic SQL statements and analyze data
• Advanced knowledge of Microsoft Excel functions and ability to manipulate/research large, complex, multi-tab spreadsheets
• Ability to leverage AI (Copilot) to simplify data governance activities and automate manual processes
• Ability to work in a fast-paced environment
• Adept at communication with ability to influence co-workers across our global team and key Technology and Compliance partners
• Strategic thinker, self-starter, organized, versatile, and capable of performing work with minimal management oversight
• Strong presentation and intermediate PowerPoint skills to prepare executive status updates
• Advanced analytical skills that demonstrate ability to navigate systems, access data, identify discrepancies and understand drivers of change
• Ability to work with stakeholders across different teams, build consensus and execute strategic objectives
• Ability to interpret data management policies and identify impacts to data management processes and artifacts

Core Competencies

Demonstrates expertise in data management, including the ability to analyze large datasets, develop SQL statements, and ensure data accuracy and compliance with Enterprise Data Management Standards. Proficient in leveraging advanced tools like Microsoft Excel and AI technologies to enhance data governance and reporting processes.

Highest-signal resume keywords

• Data Management
• SQL Development
• Microsoft Excel
• Data Governance
• Analytical Skills

ATS Optimization Keywords

Hard Skills

• Data Management
• SQL Development
• Database Architecture
• Data Analysis
• Data Quality Assurance
• Data Lineage
• Risk Data Aggregation
• EUC Computing
• Data Reporting
• Data Validation

Soft Skills

• Communication
• Strategic Thinking
• Organization
• Influencing
• Collaboration

Industry Keywords

• Risk Measurement
• Data Governance
• Operational Risk
• Enterprise Data Management
• Compliance

Tools & Technologies

• Microsoft Excel
• PowerPoint
• DQC Toolkit
• AI (Copilot)