Cognos Developer

METRIX IT SOLUTIONS INC; Massachusetts; On-site; USD 100,000 - 130,000; Full time

Job summary

METRIX IT SOLUTIONS INC is seeking an experienced IBM Cognos Architect in Massachusetts to design and optimize data and reporting solutions. The ideal candidate will have deep expertise in Cognos Framework Manager, IBM DataStage, and PL/SQL, along with knowledge of modern platforms like Databricks and Apache Spark.

This role involves leading the design of enterprise BI solutions, collaborating with stakeholders for reporting requirements, and ensuring high-quality data integration.

Qualifications

• Strong expertise in IBM Cognos and DataStage for BI and data warehousing.
• Experience with PL/SQL for data processing and frameworks.
• Familiarity with modern data platforms such as Databricks and Apache Spark.

Responsibilities

• Design and implement enterprise BI and data solutions using IBM Cognos.
• Develop data models and frameworks in Cognos Framework Manager.
• Optimize query performance for large-scale datasets.

Skills

IBM Cognos

Data Engineering

IBM DataStage

PL/SQL

Databricks

Apache Spark

Job description

We are seeking an experienced IBM Cognos Architect with strong Data Engineering expertise to design, develop, and optimize enterprise data and reporting solutions. The role requires deep expertise in Cognos Framework Manager, IBM DataStage, and PL/SQL, along with exposure to modern data platforms such as Databricks and Apache Spark.

Key Responsibilities

• Lead the design and implementation of enterprise BI and data warehousing solutions using IBM Cognos and DataStage
• Develop scalable data models and frameworks using Cognos Framework Manager (FM)
• Define data architecture standards, governance, and best practices
• Collaborate with business stakeholders to translate reporting requirements into technical solutions
• Architect and build complex reports, dashboards, and packages in IBM Cognos Analytics
• Optimize query performance and reporting frameworks for large-scale datasets
• Ensure data accuracy, consistency, and performance of reporting layers
• Design and develop ETL pipelines using IBM DataStage
• Write and optimize PL/SQL procedures, functions, and queries for data processing
• Ensure high-quality data integration across multiple upstream/downstream systems

Modern Data Platform Integration

• Contribute to data modernization initiatives leveraging Databricks
• Apache Spark (Scala/PySpark)
• Integrate traditional BI systems with cloud-based or big data platforms
• Enable hybrid data solutions (on-prem + cloud)

Performance & Optimization

• Identify and resolve bottlenecks in ETL and reporting processes
• Implement performance tuning strategies across Cognos, DataStage, and databases
• Drive automation and efficiency improvements in data pipelines

Stakeholder Management & Leadership

• Engage with business, data, and technology teams for requirement gathering and solution alignment
• Provide technical leadership and mentoring to development teams