{bc}
Company Site

Applications Development Senior Programmer Analyst – CitiKYC MIS Cognos Reporting

Citi
Pune, IND
Full-time
Senior · 6+ years experience
Hybrid
Discovered Today
IBM Cognos AnalyticsReport StudioQuery StudioDashboardEvent StudioFramework Manager

Full Job Posting

Discover your future at Citi

Working at Citi is far more than just a job. A career with us means joining a team of approximately 219,000 dedicated people from around the globe. At Citi, you’ll have the opportunity to grow your career, give back to your community and make a real impact.

Job Overview

Job Description

We are seeking a highly skilled and experienced MIS Reporting Developer / Senior Programmer Analyst to join our CitiKYC Reporting Technology team. The ideal candidate will serve as a lead reporting specialist with extensive, proven expertise in developing and managing global enterprise-level reports, semantic models, and distribution frameworks using IBM Cognos Analytics as the primary business intelligence toolset, complemented by strong visualization and dashboarding capabilities.

The candidate must have strong hands-on proficiency in querying, optimizing, and analyzing large datasets primarily hosted on Oracle databases, ensuring high performance, data integrity, and strict adherence to regulatory reporting reliability standards.

Job Background / Context

Know Your Customer (KYC) is an enterprise due diligence process executed when accepting, or periodically renewing, business relationships. This process ensures compliance with global Anti-Money Laundering (AML) regulations, Customer Identification Program Procedures (CIP-P), and other regulatory mandates designed to protect Citi from financial crime risks.

CitiKYC is a unified global platform across Citi's business lines. Its core objective is to reduce KYC complexity through process standardization, automated workflows, and robust regulatory MIS reporting. This team is directly responsible for delivering reporting solutions that monitor KYC record throughput, backlog, SLA management, and compliance risk indicators for senior management and regulatory bodies.

Key Responsibilities

  • Cognos Enterprise Reporting (Primary): Lead the end-to-end design, development, enhancement, and maintenance of operational, regulatory, and management reports using the full IBM Cognos Analytics suite (Report Studio, Query Studio, Dashboard, Event Studio, and Framework Manager / Data Modules).
  • Oracle Data Layer & Query Optimization (Primary DB): Write, fine-tune, and optimize complex Oracle SQL queries, PL/SQL blocks, views, and stored procedures to extract, aggregate, and transform high-volume datasets efficiently.
  • BI Administration & Security: Implement best practices for enterprise BI administration, metadata modeling, role-based access control, object-level security, and scheduled report distribution across Cognos environments.
  • Requirements & Strategy: Collaborate closely with Business Analysts, KYC Operations leads, Compliance Officers, and Data Architects to translate complex business and regulatory requirements into scalable reporting solutions.
  • Maintenance & Performance Tuning: Troubleshoot report failures, resolve data discrepancies, and optimize report execution times and database access paths for peak operational efficiency.
  • Mentorship & Support: Provide technical guidance, code/model reviews, and mentorship to junior developers; deliver training and tier-3 support to end-users on reporting tools.

Knowledge & Experience

Essential

  • 6+ years of professional experience in enterprise reporting and BI development, with IBM Cognos Analytics (including Cognos 10.x/11.x) as the primary tool.
  • Advanced Cognos Expertise: Deep proficiency in Framework Manager metadata modeling (relational and dimensional), complex multi-page and master-detail report authoring, drill-through definitions, event-driven scheduling, and Cognos security models.
  • Primary Database (Oracle): Strong hands-on experience with Oracle SQL / PL/SQL, query optimization, execution plans, indexing strategies, and relational database / data warehousing architectures.
  • SDLC: Solid experience working through full Software Development Life Cycle (SDLC) phases under both Agile (Scrum/Kanban) and Waterfall methodologies.
  • Strong communication, analytical, and problem-solving skills with the ability to articulate technical solutions clearly to both technical and non-technical stakeholders.

Desirable / Good to Have

  • Starburst / Presto: Experience with Starburst Presto for federated query execution, data integration, and access governance.
  • NoSQL / Alternate Data Sources: Exposure to MongoDB or big data repositories.
  • Domain Knowledge: Functional understanding of AML / KYC, Customer Due Diligence (CDD), Enhanced Due Diligence (EDD), and regulatory compliance metrics.
  • Report Migration: Prior experience converting legacy reports or migrating reports between platforms
  • Automation & Scripting: Familiarity with workload automation and scheduling tools (Autosys, Cron), Unix/Linux shell scripting, or Cognos Java SDK.

Qualifications & Certifications

Essential

  • Bachelor’s / Master’s Degree in Computer Science, Information Technology, Computer Engineering, or related quantitative discipline.

Desirable / Preferred

  • IBM Certified Designer / Developer – Cognos Analytics*(Strongly Preferred)*

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

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.

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at Citi