Business Analytics Int Analyst - C11 - BANGALORE

About AIM:
Analytics and Information Management (AIM) is a global community that is driving data driven transformation across Citi in multiple functions with the objective to create actionable intelligence for our business leaders. We are a fast-growing organization working with Citi businesses and functions across the world.

Job Description: 

The Business Analytics Int Analyst is a developing professional role. Deals with most problems independently and has some latitude to solve complex problems. Integrates in-depth specialty area knowledge with a solid understanding of industry standards and practices. Good understanding of how the team and area integrate with others in accomplishing the objectives of the sub function/ job family. Applies analytical thinking and knowledge of data analysis tools and methodologies. Requires attention to detail when making judgments and recommendations based on the analysis of factual information. Typically deals with variable issues with potentially broader business impact. Applies professional judgment when interpreting data and results. Breaks down information in a systematic and communicable manner. Developed communication and diplomacy skills are required in order to exchange potentially complex/sensitive information. Moderate but direct impact through close contact with the businesses' core activities. Quality and timeliness of service provided will affect the effectiveness of own team and other closely related teams.

We are seeking a highly skilled, detail-oriented, and motivated PL/SQL & ETL SME (Automation Developer) to join our team. The ideal candidate will be responsible for developing and maintaining data quality automation solutions using PL/SQL & ETL. This role requires a deep understanding of data quality principles, proficiency in PL/SQL & ETL, and experience with data processing and analysis.

Key Responsibilities:
Requirements understanding, develop, and implement data quality automation processes to identify, measure, and improve data quality.
Write and optimize complex PL/SQL scripts, procedures, and packages to support data quality initiatives. 
Use PL/SQL for data manipulation and processing.
Develop and enhance ETL processes to ensure accurate and timely data integration and transformation. 
Maintain Oracle databases, ensuring data integrity, performance optimization, and efficient data storage. 
Analyze data sets to identify data quality issues, trends, and anomalies, providing actionable insights and recommendations for improvement. Support manual DQ efforts as required. 
Develop and execute test plans to validate the effectiveness of data quality solutions, ensuring high standards of data accuracy and consistency. 
Maintain comprehensive documentation of data quality processes, procedures, and standards. 
Work closely with data analysts, data engineers, Manual DQ testers and other team members and stakeholders to understand data requirements and deliver high-quality data solutions. 

Required Skills:
Proficiency in PL/SQL, SQL, and Oracle database technologies. 
Experience with data quality tools and frameworks. 
Strong understanding of ETL processes and data integration. Talend experience is a big plus. 
Excellent analytical and problem-solving skills with a keen attention to detail. 
Familiarity with data governance and data management principles. 
Strong verbal & written communication skills, with the ability to explain tech. concepts to non-tech. audience. 
Ability to work effectively both independently and as part of a team.

Qualifications:
Minimum of 5 years of experience in data quality automation and PL/SQL & ETL development with Master's degree in Computer Science, Information Technology, Data Science, or a related field (or) minimum of 7 years of experience in data quality automation and PL/SQL & ETL development with Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field. Advanced degree is a plus.

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

Job Family Group:

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

Job Family:

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

Time Type:

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

Most Relevant Skills

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

Other Relevant Skills

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

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.