IT Business Lead Analyst

Position Citibank, N.A. seeks an IT Business Lead Analyst for its Irving, Texas location. Responsibilities Develop Hive and Oracle SQL queries to analyze data. Analyze data patterns and trends from various source systems to produce meaningful and measurable reports. Access data using Hive Command Line Interface, HQL and Beeline. Perform data mapping and gap analysis, and devise solutions to minimize gap. Maintain business data mapping and derivation logic in data dictionaries for upstream system consumption. Define, configure and validate new business rules for products supported by the application, including sensitivity analysis, benchmarking, back testing, and other quality reliability tests. Maintain the data management system in Genesis Retail Technology by gathering feed acquisition requirements, analyzing updated data demands, and implementing changes in upstream and downstream. Study detailed business processes of existing application and data sources, and create high‑level functional requirement documents. Evaluate new IT developments and evolving business requirements, recommending appropriate systems alternatives and enhancements based on business processes, systems, and industry standards. Drive projects in accordance with plans and process framework. Telecommuting/hybrid work schedule may be permitted within a commutable distance from the worksite, per Citi policies. Requirements Bachelor’s degree or foreign equivalent in Electronic Engineering, Software Engineering, or related field. 6 years of progressive, post‑baccalaureate experience as a Business Intelligence Analyst, Software Engineer, Senior Software Engineer, or related position involving business intelligence management system development and enhancement within the global financial services industry. Experience with data structures and advanced database systems development; data profiling and validation routines analysis and development; SQL and Hive queries development; data access using Hive CLI, HQL, Beeline; object‑oriented analysis and development; business requirements analysis and documentation; functional requirements and operational processes analysis and documentation; data mapping, gap analysis, gap minimization; data dictionaries development and maintenance; software quality reliability testing including sensitivity analysis, benchmarking, back testing. Compensation Wage Range: $160,600 to $175,000. Location & Employment Primary Location: Irving, Texas, United States. Time Type: Full time. Job Family Group: Technology. Job Family: Business Analysis/Client Services. Benefits Medical, dental and vision coverage. 401(k) retirement plan. Life, accident and disability insurance. Wellness programs. Paid time off packages, including planned vacation, unplanned sick leave, and paid holidays. Equal Opportunity Employer 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 the Accessibility at Citi resources. #J-18808-Ljbffr