Responsibilities
- Respond promptly and accurately to on-demand data requests and regulatory examination queries from Compliance and Legal teams, delivering necessary data and analytical support.
- Design, develop, and maintain data marts and Sigma reporting tools used for key regulatory operations such as CAT, EBS, trade surveillance, and AML, as well as internal supervisory monitoring, ensuring timely, accurate outputs through efficient, well-tested code.
- Continuously assess and enhance data models, SQL queries, and Sigma reports to improve performance, reduce costs, and support scalability, advancing the quality of the regulatory technology data infrastructure.
- Implement monitoring systems to detect and report upstream data irregularities and pipeline disruptions, conducting root cause analysis and issuing daily exception reports to data providers.
- Define, implement, and thoroughly document the business logic and data transformations within data marts to ensure precise computation and aggregation of all regulatory and compliance metrics.
- Maintain oversight of incoming regulatory data files and real-time feeds by establishing reliable monitoring to confirm timely delivery, data integrity, and proper ingestion into the data environment.
- Collaborate with business stakeholders and Compliance to interpret new or updated regulatory requirements and convert them into clear data engineering specifications and data pipeline designs.
- Partner with Quality Assurance to design and execute a comprehensive automated testing framework, including dbt data tests, unit testing for critical logic, and automated regression testing to guarantee defect-free deployment of regulatory data solutions.
Work Arrangement
Hybrid — New York, NY, Chicago, IL
Other
- This position is available only to candidates based in New York, NY or Chicago, IL.
- The role follows a hybrid work model, with in-office attendance expected according to team-specific schedules set by management.
- Applicants must have authorization to work for any employer in the United States.
- Employment visa sponsorship is not offered or assumed for this role at this time.
No
