Data Analyst- Tableau and SQL
Citi · India · 1d ago
Job Description
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's 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 and the publics 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.
The Operations MIS team focuses on creating reports, dashboards, and performance metrics to provide actionable insights for various business functions, including USPB WFM & Customer Service and Wealth Ops MIS. They are responsible for building and maintaining datamarts, migrating legacy BI tools to modern platforms like Tableau, and automating data refreshes for dashboards. Projects include tracking ATM availability and performance, managing service tickets, and upgrading software for uninterrupted service. They aim to empower business stakeholders with accurate and timely information for strategic decision-making. Their work also supports capacity planning and issue remediation efforts.
The Data/Information Analyst is a developing professional role. Applies specialty area knowledge in monitoring, assessing, analyzing and/or evaluating processes and data. Identifies policy gaps and formulates policies. Interprets data and makes recommendations. Researches and interprets factual information. Identifies inconsistencies in data or results, defines business issues and formulates recommendations on policies, procedures or practices. Integrates established disciplinary knowledge within own specialty area with basic understanding of related industry practices. Good understanding of how the team interacts with others in accomplishing the objectives of the area. Develops working knowledge of industry practices and standards. Limited but direct impact on the business through the quality of the tasks/services provided. Impact of the job holder is restricted to own team.
In this role, you're expected to:
- Gathers operational data from various cross functional stakeholders to examine past business performance
- Identifies data patterns & trends, and provides insights to enhance business decision making capability in business planning, process improvement, solution assessment etc.
- Recommends actions for future developments & strategic business opportunities, as well as enhancements to operational policies.
- May be involved in exploratory data analysis, confirmatory data analysis and/or qualitative analysis.
- Translate data into consumer or customer behavioral insights to drive targeting and segmentation strategies, and communicate clearly and effectively to business partners and senior leaders all findings
- Continuously improve processes and strategies by exploring and evaluating new data sources, tools, and capabilities
- Work closely with internal and external business partners in building, implementing, tracking and improving decision strategies
- Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.
As a successful candidate, should ideally have the following skills and exposure:
- Data Warehousing & BI Tools: Strong understanding of data warehousing concepts, ETL processes, and experience working with Business Intelligence platforms ( Expertise in Tableau).
- Reporting & Dashboard Development: Proficiency in developing reports, dashboards, and performance metrics using reporting tools and data visualization techniques. Ability to create clear and concise visualizations of key data.
- Data Management & SQL: Expertise in data management principles, SQL programming for data extraction and manipulation, and database management systems.
Proficiency in SQL server to manage end to end data flow.
- Communication & Stakeholder Management: Ability to effectively communicate technical information to non-technical stakeholders and collaborate with business partners to understand reporting requirements.
- Automation & Scripting: Experience with scripting languages (e.g., Python) and automation tools (e.g., SSIS) for automating report generation, data refreshes, and other routine tasks.
Use MSBI(SSIS) efficiently to create data pipelines for Datamart
Qualifications:
- Work experience: 5-8 years experience working with Tableau, with a proven track record of creating high-impact dashboards as an individual contributor. Experience in managing end to end reporting lifecycle.
- Tableau: Tableau Desktop (Expert) and Tableau Server (Intermediate). Experience in Tableau Prep is a plus but not mandatory.
- SQL: Strong SQL skills for data extraction and preparation. SQL Server (Expert) and Oracle SQL (Basic)
- Data Warehousing: Understanding of data warehousing concepts and experience working with various data sources. MSBI (Intermediate)
- AI Tools: Microsoft Copilot, VS Code is as added advantage
- Strong analytical and problem-solving skills, with the ability to identify and quantify opportunities for improvement.
- Excellent communication and interpersonal skills
- Banking Knowledge: Good understanding of the banking domain, banking products and Operations in banking is preferred.
- Soft Skills: Ability to multi-task effectively and efficiently in a fast-paced environment. Excellent interpersonal skills and a positive, proactive attitude ,Strong problem-solving skills,
------------------------------------------------------
Job Family Group:
Decision Management------------------------------------------------------
Job Family:
Data/Information Management------------------------------------------------------
Time Type:
Full time------------------------------------------------------
Most Relevant Skills
Please see the requirements listed above.------------------------------------------------------
Other Relevant Skills
For complementary skills, please see above and/or contact the recruiter.------------------------------------------------------
Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.
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 Citi’s EEO Policy Statement and the Know Your Rights poster.