Data Analytics Senior Associate

The Depository Trust & Clearing Corporation (DTCC); Tampa (FL); Hybrid; USD 95,000 - 140,000; Full time

Benefits offered by this job

Competitive compensation

Comprehensive health and life insurance

Pension / Retirement benefits

Paid Time Off

Flexible/hybrid work model

Job summary

A financial services company based in Tampa, Florida, is looking for an experienced Data Analytics professional to join their Risk Management team. This role focuses on advancing risk management through data warehousing and analysis. The ideal candidate will have at least 6 years of experience, strong skills in SQL, and knowledge of financial risk management. Responsibilities include collaborating with stakeholders, writing requirements, and performing user acceptance testing. A collaborative, hybrid work environment is offered.

Qualifications

• Minimum of 6 years of related experience.
• Bachelor's degree preferred or equivalent experience.
• Experience with data warehousing and risk data management preferred.

Responsibilities

• Communicate with internal stakeholders to understand data requirements.
• Write data business requirements and user stories related to new software development projects.
• Provide data analytics support to Business Analysts and Product Owners.
• Follow the Agile SCRUM practices for data-intensive projects.
• Perform user acceptance testing (UAT).
• Research and propose solutions for data anomalies.
• Profile data to thoroughly understand the quality, anomalies and patterns.
• Identify, plan and oversee consolidation of redundant data sources to establish centralized golden copy source data.
• Establish data quality processes for the data warehouse and analyze data quality reports to identify potential anomalies across multiple data sources.
• Perform ad-hoc data analysis and reporting to support internal customers.
• Research and propose solutions for data anomalies; Escalate data issues to appropriate stakeholders in a timely manner.
• Aligns risk and control processes into day to day responsibilities to monitor and mitigate risk; escalates appropriately.

Skills

Financial risk management

Advanced SQL skills

Business intelligence tools

Python

R

Education

Bachelor's degree or equivalent experience

Tools

Tableau

Power BI

SQL Server

Job description

Are you ready to make an impact at DTCC?

Do you want to work on innovative projects, collaborate with a dynamic and supportive team, and receive investment in your professional development? At DTCC, we are at the forefront of innovation in the financial markets. We are committed to helping our employees grow and succeed. We believe that you have the skills and drive to make a real impact. We foster a thriving internal community and are committed to creating a workplace that looks like the world that we serve.

Our Risk Management teams work to protect the safety and soundness of our systems and are responsible for identifying, managing, measuring and mitigating a spectrum of key risk types including credit, market, liquidity, systemic, operational and technology in all existing and new products, activities, processes and systems.

Pay And Benefits

• Competitive compensation, including base pay and annual incentive
• Comprehensive health and life insurance and well-being benefits, based on location
• Pension / Retirement benefits
• Paid Time Off and Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being.
• DTCC offers a flexible/hybrid model of 3 days onsite and 2 days remote (onsite Tuesdays, Wednesdays and a third day unique to each team or employee).

The Impact You Will Have In This Role

The Data Analytics team is responsible for the advancement and integration of the Data Warehouse into all aspects of risk management, DTCC, and external clients. The successful candidate will have proven experience in managing data, including data warehousing, data analysis, and problem solving. They will have a structured approach to business analysis and a proven track record of implementing solutions. Be a point of contact for risk data warehouse activities, including business requirements gathering, data modeling, data documentation, user acceptance testing, and ad-hoc data queries.

Your Primary Responsibilities

• Communicate with internal stakeholders to understand data requirements.
• Write data business requirements and user stories related to new software development projects.
• Provide data analytics support to Business Analysts and Product Owners.
• Follow the Agile SCRUM practices for data-intensive projects covering software development, data warehousing, customer reporting, and data analytics.
• Perform user acceptance testing (UAT)
• Participate in pre and post-release testing to validate requirements have been met.
• Profile data to thoroughly understand the quality, anomalies and patterns.
• Identify, plan and oversee consolidation of redundant data sources to establish centralized golden copy source data.
• Establish data quality processes for the data warehouse and analyze data quality reports to identify potential anomalies across multiple data sources.
• Perform ad-hoc data analysis and reporting to support internal customers.
• Research and propose solutions for data anomalies; Escalate data issues to appropriate stakeholders in a timely manner.
• Aligns risk and control processes into day to day responsibilities to monitor and mitigate risk; escalates appropriately.

Qualifications

• Minimum of 6 years of related experience
• Bachelor's degree preferred or equivalent experience

Talents Needed For Success

• Experience in financial risk management and/or Fintech preferred
• Advanced knowledge of financial services industry
• Hands-on experience writing and executing complex SQL queries
• Experience with various business intelligence tools is required
• Experience with Python, R, or other programming languages is required

The salary range is indicative for roles at the same level within DTCC across all US locations. Actual salary is determined based on the role, location, individual experience, skills, and other considerations. We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.