We are looking for a senior IBM Cognos Architect with strong Data Engineering expertise to design develop and modernize enterprise data and BI platforms. The ideal candidate will have deep experience in Cognos Analytics Framework Manager DataStage and PL/SQL along with exposure to modern data platforms such as Databricks and Apache Spark.

This role requires a blend of architecture hands-on development and leadership especially within large-scale BFSI data environments.

Key Responsibilities

1. Architecture & Design

• Lead enterprise BI and data warehousing architecture using IBM Cognos & DataStage
• Design and implement scalable data models using Cognos Framework Manager (FM)
• Define data architecture standards governance and best practices
• Translate business reporting requirements into robust technical solutions
• Drive data strategy and modernization roadmap

2. Cognos Development & Reporting

• Architect and develop complex reports dashboards and packages in Cognos Analytics
• Optimize query performance and report execution for large datasets
• Ensure data accuracy consistency and reporting layer integrity
• Implement reusable frameworks and semantic layers

3. Data Engineering (ETL & Database)

• Design and develop ETL pipelines using IBM DataStage
• Develop and optimize PL/SQL procedures functions and queries
• Enable seamless data integration across multiple systems
• Ensure data quality validation and transformation accuracy

4. Modern Data Platform Integration

• Contribute to data modernization initiatives using:
  • Databricks
  • Apache Spark (Scala / PySpark)
• Integrate legacy BI platforms with cloud/big data ecosystems
• Enable hybrid architectures (on-prem cloud)
• Support migration strategies from traditional BI to modern stacks

5. Performance & Optimization

• Identify and resolve ETL and reporting performance bottlenecks
• Implement performance tuning strategies across:
  • Cognos
  • DataStage
  • Databases
• Drive automation efficiency and scalability improvements

6. Leadership & Stakeholder Management

• Collaborate with business data and engineering teams
• Lead technical design discussions and architecture reviews
• Mentor junior developers and guide delivery teams
• Participate in governance compliance and solution approval processes

Required Skills (ATS-Optimized)

Primary Skills

• IBM Cognos Analytics (Advanced)
• Cognos Framework Manager (FM)
• IBM InfoSphere DataStage (ETL Design & Optimization)
• Advanced PL/SQL programming
• Data Warehousing & BI Architecture
• Dimensional Modeling (Star/Snowflake Schemas)

Secondary / Good-to-Have

• Databricks platform
• Apache Spark (Scala / PySpark)
• Cloud platforms (Azure / AWS / GCP)
• Data integration with hybrid ecosystems