Citi
Posted 2d ago

Data Analysis Analyst SQL

Citi
Chennai or India
HybridFull Time
Responsibilities
  • analyzing requirements
  • exploring data
  • validating datasets
Requirements
  • Requires 3–5 years in business or data analysis
  • Data management, or business intelligence
  • Strong SQL, relational database and data modeling knowledge
  • Experience with structured data platforms
Technical tools mentioned
SQLHiveHueSnowflakeTeradataHadoopDataikuPythonPySparkTableauPower BI

Job description

Who we are

With Citi’s Analytics & Information Management (AIM) group, you will do meaningful work from Day 1. Our collaborative and respectful culture lets people grow and make a difference in one of the world’s leading Financial Services Organizations. The purpose of the group is to enable building Citi’s data assets and to analyze information and create actionable intelligence for our business leaders. We value what makes you unique so that you have opportunity to shine. You also get the opportunity to work with the best minds and top leaders in the analytics space.

What the Role Is
We are hiring for the position of Officer – Data Management / Business Analyst2 C10 role within Citi’s AIM Wealth Data Strategy team, based in Chennai India. In this role, you will contribute to the design and implementation of enterprise data solutions that enable consistent reporting, analytics, and business insights across Wealth. You will work closely with business stakeholders, product owners, data modelers, and technology teams to understand business requirements, identify and analyze source data, define mapping specifications, support Unified Data Model (UDM) development, and validate delivered data assets. This role offers the opportunity to work on large-scale strategic data initiatives while gaining exposure to enterprise data architecture, governance, and modern data platforms.

Key Responsibilities: Below are the high level job responsibilities.
Business Requirement Analysis: Work with business stakeholders to understand reporting, analytics and data requirements.
Data Sourcing and Exploration: Identify relevant source systems, files, tables and attributes required to support business use cases.
Data Quality and Governance: Support identification of Critical Data Elements and relevant data quality rules. Assist with data classification, lineage, metadata and governance documentation.
Testing and Validation: Perform UAT and validate delivered tables, attributes, relationships and transformation logic. Compare source and target data, investigate discrepancies and track defects through closure.
 

Qualifications:
Experience:
3 to 5 years of experience in business analysis, data analysis, data management, business intelligence or a related area.
Experience working with structured data, source systems, data warehouses or enterprise data platforms.
Experience in banking, financial services or Wealth Management is preferred.
Technical Skills:
Strong SQL skills for data exploration, profiling, reconciliation and validation.
Good understanding of relational databases, data modelling concepts, keys, relationships and data lineage.
Experience working with large datasets and analyzing source-to-target data flows.
Familiarity with tools such as Hive, Hue, Snowflake, Teradata, Hadoop, Dataiku, Python or PySpark is an advantage.
Exposure to Tableau, Power BI or other reporting tools is useful.
Business Analysis Skills:
Ability to gather, analyze and document business and data requirements.
Ability to translate business concepts into entities, attributes, mapping rules and validation criteria.
Strong documentation skills, including requirements, mapping documents, data dictionaries and process flows.
Ability to review sample data and determine whether it meets the intended business purpose.
Soft Skills:
Strong analytical and problem-solving ability.
Clear written and verbal communication.
Strong attention to detail and willingness to challenge unclear definitions or mappings.
Ability to manage multiple priorities and take ownership of assigned deliverables.
Proactive learning mindset and willingness to develop deeper expertise in Wealth data and One Wealth architecture.

------------------------------------------------------

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.

About Citi

Providing global banking, investment, and wealth management services.

Similar jobs

Data Analyst roles near Chennai, Tamil Nadu
1d
Save
Mark Applied
Hide
Senior Data Analyst
Chennai or Thiruvananthapuram or Gurugram
OnsiteFull Time
Guidehouse
Guidehouse: Provides management and technology consulting services to diverse organizations.
3+ YOEBachelor’s degree in science, business, IT, analytics, or related field; 3+ years of data analysis and reporting experience; statistics, analytical, communication, and presentation skills required.
Microsoft Excel, Power Platform, PowerApps, Power Automate, SQL, ETL, Python
2d
Save
Mark Applied
Hide
Data Analyst
Chennai, Tamil Nadu, India
HybridFull Time
U.S. Bank
U.S. BankNYSE: USB: Provider of personal, business, and institutional financial services.
5+ YOEBachelor’s degree or equivalent experience, 5+ years in analytics, reporting, business intelligence, or statistics, SQL, Excel, BI tools, and knowledge of data visualization and quality concepts.
SQL, Microsoft Excel, Power BI, Tableau, Python, R
2d
Save
Mark Applied
Hide
Workforce Management - Reporting
Bangalore or Chennai
RemoteFull Time
Gainwell Technologies
Gainwell Technologies: Delivers technology solutions for public health and Medicaid programs.
3+ YOEBachelor's degree or equivalent, 3+ years in workforce management, reporting, analytics, or related operations, with strong analytical, communication, and dashboarding skills.
Verint, Microsoft Excel, Power BI, NICE
2d
Save
Mark Applied
Hide
Senior Data Analyst
Mumbai or Hyderabad or Chennai
OnsiteFull Time
FedEx
FedExNYSE: FDX: Global provider of courier, logistics, and transportation services.
5+ YOEBachelor's degree and 5+ years in data or business analysis, data modeling, or supply chain systems; requires SQL, relational databases, data governance, and strong stakeholder and analytical skills.
SQL
3d
Save
Mark Applied
Hide
Senior Data Analyst
Mumbai or Hyderabad or Chennai
OnsiteFull Time
FedEx
FedExNYSE: FDX: Global provider of express delivery and logistics services.
5+ YOEBachelor's degree in a related discipline and 5+ years in data or business analysis, data modeling, or supply chain systems; requires logistics knowledge, data expertise, SQL, and stakeholder facilitation.
SQL
4d
Save
Mark Applied
Hide
Data Analyst Specialist
Chennai, Tamil Nadu, India
HybridFull Time
Capgemini
CapgeminiEuronext Paris: CAP: Provides global IT consulting and digital transformation services.
Bachelor's degree in a relevant quantitative or technical field; hands-on Microsoft Excel and Power BI experience, including automation, data modeling, DAX, dashboards, and reporting.
Microsoft Excel, Power BI, Power Query, VBA, DAX
1w
Save
Mark Applied
Hide
Data Analyst III
Chennai or Bengaluru
OnsiteFull Time
RELX
RELXLondon Stock Exchange: REL: Provides information-based analytics and decision tools for professional customers.
3+ YOEThree years of experience, programming and SQL skills, and experience with Pandas, Apache Spark/Databricks, Snowflake SQL, Collibra, data analysis, governance, and metadata management.
Databricks, Python, SQL, Pandas, Apache Spark, Snowflake SQL, Collibra, Tableau, Power BI, JIRA
1w
Save
Mark Applied
Hide
Data Analyst III
Chennai or Bengaluru
HybridFull Time
Elsevier
ElsevierLondon Stock Exchange: REL: Provides scientific, technical, and medical research information and analytics.
3+ YOEThree years of experience, programming and SQL skills, and experience with Pandas, Apache Spark/Databricks, Snowflake SQL, Collibra, data analysis, governance, and metadata management.
Databricks, Python, SQL, regular expressions, Pandas, Apache Spark, Snowflake SQL, Collibra, Tableau, Power BI, JIRA