Unix Scripting Specialist Officer

The Reconciliation Developer – Officer (C11) is a hands-on technical individual contributor responsible for developing, configuring, testing, and supporting data reconciliations and automated data controls.

Working under the guidance of senior technical leads, the developer focuses on implementing matching rules, maintaining data feeds, resolving technical breaks, and executing scheduled and ad-hoc reconciliation requests across financial systems and data distribution pipelines.

Hybrid Schedule: 2 or 3 full days per week on-site in the office, with remaining days worked remotely in accordance with enterprise hybrid work policies.

Reconciliation Rule Build: Configure, test, and maintain multi-way matching rules, tolerance checks, and automated exception routing on enterprise reconciliation platforms (e.g., TLM SmartStream, Duco, Gresham, or internal reconciliation engines).

Break Analysis & Triage: Investigate reconciliation breaks and discrepancies, identify root causes in data transformations, and apply rule adjustments or fixes.

Data Processing & Scripting: Write and optimize Python scripts and SQL queries to extract, transform, and load transactional and ledger data into reconciliation engines.

Requirements Implementation: Review Business Requirement Documents (BRDs) and technical specifications to implement mapping rules, data schemas, and validation checks.

Data Feed Maintenance: Monitor daily reconciliation runs, batch feeds, and automated jobs, ensuring successful data ingestion from upstream systems.

Assisting Backlog Remediation: Actively deliver user stories and tasks to address the operational backlog of scheduled and ad-hoc reconciliation requests.

Testing & Deployment Support: Perform unit testing, assist with User Acceptance Testing (UAT), and prepare deployment artifacts using Git and CI/CD pipelines

Team Participation: Participate in daily stand-ups, sprint planning, and backlog refinement sessions within an Agile framework.

Operational Collaboration: Work closely with operations users, business analysts, and quality assurance testers to clarify requirements and resolve defect tickets.

Technology Adoption: Learn and apply emerging tools and automation techniques, including data processing utilities (e.g., PySpark, Airflow) and automated anomaly detection workflows.

• Bachelor’s degree in Computer Science, Information Technology, Software Engineering, Data Analytics, or related field.

• 4-8 years of hands-on software development, data manipulation, or reconciliation configuration experience in Financial Services or IT.

• Solid foundation as a technical individual contributor executing assigned tasks with quality.

• Python: Practical experience with data manipulation (pandas, numpy), data parsing, and scripting.

• SQL: Strong proficiency in writing queries, joins, aggregations, subqueries, and working with relational databases (Oracle, PostgreSQL, etc.).

• Basic Understanding: Familiarity with Java, Scala, or C# is a plus.

• Working knowledge of batch data processing (e.g., Apache Spark/PySpark basics).

• Familiarity with scheduled workflow tools (e.g., Apache Airflow) and messaging/event concepts (e.g., Kafka).

• Exposure to cloud data platforms (e.g., Snowflake, AWS, or GCP) is advantageous.

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

Job Family Group:

Technology

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

Job Family:

Applications Development

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

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.