C

Citi

Runs banking and payments for global clients

Senior Data Platform Engineer

Data EngineeringConfirmed live in the last 24 hours
Full-time$107.1k - $160.7kHybrid

About the Job

Requirements

  • At least 4 years of relevant experience in data engineering, application development, database development, or related technology roles.
  • Hands-on experience with Python and PySpark for large-scale data processing and ETL development.
  • Proficiency in SQL/T-SQL and relational database technologies, preferably Microsoft SQL Server.
  • Experience developing and supporting complex SQL queries, stored procedures, database objects, and high-volume data-processing solutions.
  • Understanding of SQL Server performance tuning, including query execution plans, indexing, statistics, joins, locking/blocking, and query optimization.
  • Experience with Microsoft BI/SSIS or comparable enterprise ETL technologies.
  • Experience working with large datasets and distributed data platforms such as Hadoop, HDFS, and Hive.
  • Understanding of ETL architecture, data warehousing, dimensional modeling, and relational/3NF modeling.
  • Experience implementing data-quality checks, reconciliation, audit controls, exception handling, and production monitoring.
  • Experience with enterprise scheduling/orchestration tools such as AutoSys.
  • Experience with Git, CI/CD, and modern development practices.
  • Bachelor’s degree/university degree or equivalent experience.
  • Ability to work independently on complex technical assignments while collaborating across teams.

Responsibilities

  • Design, develop, test, and support scalable ETL/data-processing pipelines using Python/PySpark, Microsoft BI/SSIS, SQL, and related technologies.
  • Develop and optimize complex SQL queries, stored procedures, functions, data transformations, and database objects for high-volume applications.
  • Identify and resolve query and database performance issues through execution-plan analysis, indexing, query optimization, statistics, and appropriate database design techniques.
  • Develop and support solutions that process large data volumes across SQL Server and distributed data platforms.
  • Apply relational, dimensional, and data-warehouse modeling principles to build scalable and maintainable data solutions.
  • Analyze failed jobs, data-quality issues, performance problems, and production incidents; perform root-cause analysis and implement sustainable resolutions.
  • Develop and support enterprise batch-processing workflows using scheduling/orchestration platforms such as AutoSys.
  • Work with Hadoop ecosystem technologies including HDFS, Hive, and related distributed-processing technologies.
  • Implement validation, reconciliation, exception handling, logging, monitoring, and data-quality controls within data pipelines.
  • Participate in code reviews and enforce development standards for SQL, Python/PySpark, ETL, and data-processing components.
  • Use Git-based source control and participate in CI/CD processes; work with container technologies such as Docker/Kubernetes where applicable.
  • Follow secure data-development practices, access-control requirements, encryption standards, and organizational security policies.
  • Work closely with application developers, infrastructure teams, business teams, and other technology groups to design and deliver solutions.
  • Evaluate new technologies and leverage approved AI-assisted development tools to improve code quality, troubleshooting, refactoring, and developer productivity.
  • Assess risk in business decisions while safeguarding the firm, its clients, and assets and complying with applicable laws, rules, regulations, and policies.

Desired Qualifications

  • Familiarity with Docker/Kubernetes.
  • Familiarity with NoSQL technologies such as MongoDB.
  • Experience mentoring or providing technical guidance to other developers.

About the Company

Citi

Runs banking and payments for global clients

Citi runs banking, investment and payment services for companies, governments and individuals around the world. Its global network connects institutions with local banking systems, while its US consumer business sells credit cards and deposit accounts. Corporate clients use Citi to manage cash, finance trade and raise capital, and investors use its trading, custody and wealth services to hold and manage assets. The bank earns interest on loans and fees from payments, securities transactions, financial advice and account services. Citi traces its banking roots to 1812; the Citigroup holding company was formed in 1998, and its headquarters are in New York City.

Company size
10,001+
Company stage
IPO
Headquarters
New York City, New York
Founded
1812

Recently Posted Jobs

Explore more opportunities at Citi

See more jobs