Citigroup is looking to solve complex data analytics problems and improve its data quality control, while also ensuring compliance with applicable laws and regulations.
Requirements
Advanced SQL coding proficiency
Deep Business Analysis skill set including a strong understanding of various form of analysis such as: Descriptive Analysis, Diagnostic Analysis, Exploratory Analysis, Inferential Analysis, Causal Analysis
Efficient coding methodologies such as use of Common Table Expressions and window analytic functions to create elegant and efficient analytical packages in SQL
Very strong proficiency in data profiling and entity relationship discovery within a standard Enterprise Data Warehouse
High competency in actual coding in SQL to interrogate the data system and obtain outputs necessary to answer business questions
Intermediate/advanced Python experience preferred
Experience with data management lifecycles and workflows
Responsibilities
Integrates subject matter and industry expertise within a defined area.
Contributes to data analytics standards around which others will operate.
Applies in-depth understanding of how data analytics collectively integrate within the sub-function as well as coordinate and contribute to the objectives of the entire function.
Development of data controls including data profiling, data analysis, logic tuning, and advanced SQL coding.
Manages the end-to-end data quality control development lifecycle and will also scope data control code releases, agreeing to and tracking business priorities, incorporating regulatory and compliance requirements.
Create and Implement data quality controls by performing audits and validations across various data sources.
Identifies solutions ranging across data analytics, reporting, CRM, Trade Workflows and trade processing
Other
6-10 years' experience
Bachelor’s/University degree or equivalent experience, potentially Master's degree
Intellectual curiosity, analytical and conceptual thinker
Proactively seeks and develops new opportunities
Ability to build networks and relationships internally and externally
