Data Management Senior Associate

Come and join us in reshaping the future!

As a Data Management Product Owner/Analyst with the Controls Management Data Governance team, you will be responsible for ensuring data is fit for reporting which includes ingesting data to reporting platform, ensuring all controls related to data quality are in place.

You will establish data reconciliation, metadata registration, data validation and help support outbound data feeds and feed governance.

The Controls Management mission is to solidify an effective Firm wide control framework within and across the lines of business by identifying and remediating control issues with a sense of urgency, regardless of the source.

The Controls Management team will work collaboratively with other control disciplines and will oversee existing control functions as well as the development of new control functions and protocols.

This process will enable the firm to engage the appropriate teams in a timely manner and provide the ability to quickly remediate critical control issues across all the impacted areas of the firm.

Job responsibilities-


* Demonstrate good understanding of data governance framework, data quality & data lineage.


* Implement and support Data Quality (DQ) practices.

Define and manage data validation rules/reconciliations for critical data elements and other core attributes by running complex SQL queries.


* Govern and triage DQ Issues as it progresses through the lifecycle.


* Discover and document data-lineage to trace the end-to-end data journey from point of creation to consumption.


* Set up data profiling and DQ rules leveraging DQ tools like RDHP (Reference Data Hosting Platform), Collibra, Informatica and other emerging tools


* Leverage productivity tools such as Alteryx and visualization tools such as Tableau to analyze large dataset to draw inferences.


* Collaborate & Build strong partnerships with Business stakeholders & Technology teams to support data quality efforts.


* Define data quality rules for critical data elements based on the Firmwide dimensions and obtain approval from Data Owners.


* Demonstrates Teamwork by collaborating with others to integrate ideas & achieve common goals.


* Set up ingestion of data sources to AWS public cloud and ensure data matches between source and target and support and feeds (API/KAFKA/Data Mesh) requirements.


* Review data models to understand data concepts and relationships.

Perform ad hoc analysis and data extracts using Data bricks or Hue/Impala


* Onboard new data categories on reconciliation framework to ensure consistency is maintained between source and target systems.


* Perform analysis, create visualization, presentations, wireframes and recertification steps on various data management components on ad hoc, quarterly and yearly basis.

Required qualifications, capabilities and skills-


* Quantitative background (BA/BS in Math, Statistics, Economics, Computer Science, Eng...