Applications Development Tech Lead Analyst

Citi • Irving, TX

2d • $157,414 - $180,000 • Hybrid

About The Position

Citibank, N.A. seeks an Applications Development Tech Lead Analyst for its Irving, TX location.
DUTIES: Develop and implement database solutions for the ROCK ICG Data Command Center Portal application. Design, develop, and maintain ETL processes to integrate data from various source systems into the central repository. Implement data quality checks, reconciliations, and standardization procedures to ensure data integrity and compliance with regulatory standards. Participate in whiteboard design sessions with business stakeholders to analyze and identify appropriate source systems for data extraction. Analyze business requirements and project objectives outlined in BRDs (Business Requirement Documents). Collaborate with stakeholders, including business users, data analysts, and source system experts, to understand data flow and system functionalities. Identify and document key data metrics, insights, use cases, data transformation logic, and visualization requirements. Design and structure the database and ETL (Extract, Transform, Load) processes based on business requirements. Define data specifications, modeling rules, and business rules for data onboarding into the data visualization portal (Qliksense/ Tableau). Collaborate with UX/UI teams to design effective visualizations that meet business needs. A telecommuting/hybrid work schedule may be permitted within a commutable distance from the worksite in accordance with Citi policies and protocols.

Requirements

• Bachelor’s degree, or foreign equivalent, in Computer Science, Electronic Engineering, Software Engineering, Information Technology, or a related field, and six (6) years of experience in the job offered or in a related IT occupation performing database development and maintaining ETL processes.
• Six (6) years of experience must include: Designing and developing ETL processes using Talend including analyzing business requirements, identifying source systems, designing data mappings and workflows, and implementing data quality checks and standardization procedures
• Developing and implementing database solutions using SQL including designing and creating database schemas, writing complex SQL queries, stored procedures, and functions to ensure data integrity and compliance
• Utilizing Big Data technologies like Kafka to support real-time data streaming and processing solutions and data-driven decision-making
• Implementing and managing CI/CD pipelines using Jenkins, Tekton, and Harness
• Utilizing data visualization tools like Qliksense or Tableau to design and develop interactive dashboards and reports to effectively communicate data insights to stakeholders
• Collaborating with stakeholders to gather and analyze business requirements to support conducting whiteboard sessions, documenting requirements, and translating business needs into technical specifications
• Utilizing Agile methodologies and tools like JIRA which includes participating in Agile sprints, managing tasks, and collaborating effectively with development teams.
• 40 hrs./wk.

Responsibilities

• Develop and implement database solutions for the ROCK ICG Data Command Center Portal application.
• Design, develop, and maintain ETL processes to integrate data from various source systems into the central repository.
• Implement data quality checks, reconciliations, and standardization procedures to ensure data integrity and compliance with regulatory standards.
• Participate in whiteboard design sessions with business stakeholders to analyze and identify appropriate source systems for data extraction.
• Analyze business requirements and project objectives outlined in BRDs (Business Requirement Documents).
• Collaborate with stakeholders, including business users, data analysts, and source system experts, to understand data flow and system functionalities.
• Identify and document key data metrics, insights, use cases, data transformation logic, and visualization requirements.
• Design and structure the database and ETL (Extract, Transform, Load) processes based on business requirements.
• Define data specifications, modeling rules, and business rules for data onboarding into the data visualization portal (Qliksense/ Tableau).
• Collaborate with UX/UI teams to design effective visualizations that meet business needs.

Benefits

• In addition to salary, Citi’s offerings may also include, for eligible employees, discretionary and formulaic incentive and retention awards.
• Citi offers competitive employee benefits, including: medical, dental & vision coverage; 401(k); life, accident, and disability insurance; and wellness programs.
• Citi also offers paid time off packages, including planned time off (vacation), unplanned time off (sick leave), and paid holidays.
• For additional information regarding Citi employee benefits, please visit citibenefits.com.
• Available offerings may vary by jurisdiction, job level, and date of hire.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level