Job Description

Who we are

• Citi\xe2\x80\x99s Treasury and Trade Solutions (TTS) group is built on the power of our network. We have offices in 101 countries, servicing clients in 160 countries, transacting on over 140 currencies, servicing 81% of the Global Fortune 500 companies and processing over 3 trillion dollars a day in payments.
• TTS\xe2\x80\x99 Program Management Organization (PMO) and Business Office is a strategic partner and thought leader at the portfolio/program level for all lines of business within TTS. It manages financial controls, communication, PMO, business, headcount, and resourcing.
• The Change management and Process Improvement Office is within the TTS PMO and Business Office department and is designed to provide dedicated support to large-scale, TTS-wide endeavors, crossing multiple LOBs, that are best driven by the PMO function.

Who you are

• Data Driven: enabling decision making and problem solving with data
• Problem Solver: asking good questions to understand challenges and come up with solution
• Team Player: building relationships and developing team- and firm-wide networks
• Strong Communicator: transmitting information clearly, concisely, and respectfully through verbal and written communication
• Self-directed: an individual contributor caring for end-to-end automation; taking initiative; seeing what needs to be done and doing it

What you do

• Data Exploration: accessing and analyzing data using multiple platforms
• Build Data Assets: developing and building multi-dimensional data assets for use in Qlik Sense
• Automation: moving to automate data reporting and flows
• Stakeholder Management: building strong independent relationships across the firm
• Process and Controls: Adhering to, developing, and monitoring process improvements and controls

Overview

Automation Reporting Analysts are experienced technical and programming professionals. They will manage and automate data flows for complex and variable processes like tech stack estate (EOVS, VTMs), infrastructure procurement (cloud and physical), program delivery benefits, investment alignment, and resourcing ratios. Reporting analysts will need to independently confirm validity of data as it will often be derived from multiple (even conflicting) sources. They need analytical skills to filter, prioritize and validate complex and dynamic material. The data managed have a substantial impact on departmental strategy and execution. The overall objective of this role is to understand, access and organize the data needs of the department, and work with team to create dynamic reporting and then automate the reporting process.

Key Responsibilities

• Develop, maintain, automate and manage advanced reporting.
• Deliver useful analytics to address business problems; identify and gain access to data, quantify effort required and establish a project plan.
• Identify key areas of automation to make the reporting processes smooth.
• Review and improve existing systems by collaborating with various teams.
• Consult users and clients to solve complex system issues through in-depth evaluation of data, business processes, systems, and industry best practices.
• Test dashboards, reports, and automation; validating results.
• Present and explain data to both technical and non-technical colleagues, including senior management.
• Work with team to design and develop Qlik Sense solutions using backend database technologies.

Tools and Platforms

• Impala
• Vanguard data mart
• SQL
• Smart automation tools (Xceptor)
• Programming language familiarity (Python, Java, .Net, etc.)
• Qlik Sense
• Relational database management systems (RDBMS)
• Excel and Excel (Macro)
• Other big data software

Required Skills

Hard skills

• Advanced knowledge of reporting automation using Impala and Vanguard
• Advanced knowledge of business intelligence development, using data analytics and technology to share business information with decision-makers
• Proficiency in analytics and database querying tools
• Advanced knowledge of RDBMS systems, Business Intelligence, and data analytics
• Able to perform and document data analysis, validation, mapping, and design
• Advanced SQL and data exploration
• Able to manipulate and blend data to support dashboard design and visualization

Soft skills

• Able to work with a high degree of autonomy
• Able to handle difficult and unexpected data analyst needs within complex business challenges
• Able to identify, clearly articulate and solve complex business problems and present them to the management in a structured and concise form
• Able to focus on speakers, understand their message, comprehend the information, and respond thoughtfully
• Well organized with excellent time management skills
• Self-motivated, focused, detailed oriented; able to prioritize and work efficiently within deadlines and competing priorities

Additional Desired Skills

• Data literacy and data analytics certification
• Able to develop and manage Qlik Sense dashboards and reports without technical oversight
• Qlik Sense qualifications or certifications
• Tableau and Power BI familiarity
• Prior experience in finance domain
• Experience working within an Agile development methodology

Qualifications

• 5-8+ years of experience in enterprise business intelligence (BI) development.
• 3+ years of hand on experience with Vanguard, Impala and Qlik Sense
• Strong experience in data mart / data warehouse design.

About Citi Citi, the leading global bank, has approximately 200 million customer accounts and does business in more than 160 countries and jurisdictions. Citi provides consumers, corporations, governments and institutions with a broad range of financial products and services, including consumer banking and credit, corporate and investment banking, securities brokerage, transaction services, and wealth management. Our core activities are safeguarding assets, lending money, making payments and accessing the capital markets on behalf of our clients. Citi\xe2\x80\x99s Mission and Value Proposition explains what we do and Citi Leadership Standards explain how we do it. Our mission is to serve as a trusted partner to our clients by responsibly providing financial services that enable growth and economic progress. We strive to earn and maintain our clients\xe2\x80\x99 and the public\xe2\x80\x99s trust by constantly adhering to the highest ethical standards and making a positive impact on the communities we serve. Our Leadership Standards is a common set of skills and expected behaviors that illustrate how our employees should work every day to be successful and strengthens our ability to execute against our strategic priorities. Diversity is a key business imperative and a source of strength at Citi. We serve clients from every walk of life, every background and every origin. Our goal is to have our workforce reflect this same diversity at all levels. Citi has made it a priority to foster a culture where the best people want to work, where individuals are promoted based on merit, where we value and demand respect for others and where opportunities to develop are widely available to all. - Job Family Group: Technology - Job Family: Applications Development - Time Type: Full time - Primary Location: New Castle Delaware United States - Primary Location Salary Range: $121,560.00 - $182,340.00 - Citi is an equal opportunity and affirmative action employer. Qualified applicants will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. Citigroup Inc. and its subsidiaries ("Citi\xe2\x80\x9d) invite all qualified interested applicants to apply for career opportunities. If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi. View the "EEO is the Law" poster. View the EEO is the Law Supplement. View the EEO Policy Statement. View the Pay Transparency Posting