Senior Cognos Developer & Administrator, Malvern, PA, US

Intellibee; Malvern; On-site; GBP 65,000 - 95,000; Full time

Benefits offered by this job

Long-Term Stability

Health Coverage

401(k) Planning

Green Card assistance

Job summary

IntelliBee seeks a Senior Cognos Developer/Admin to lead enterprise reporting initiatives. You will develop Cognos reports, dashboards, and Framework Manager models while ensuring platform stability, security, and performance in large-scale environments.

The role emphasizes advanced SQL skills, Cognos administration across Dev, QA and Prod, and AWS-enabled data pipelines. You will partner with IT and business teams to translate requirements into scalable, efficient reporting solutions.

Qualifications

• Bachelor's degree in Computer Science or related field.

Responsibilities

• Develop and maintain Cognos reports, dashboards, and Framework Manager models.
• Build pixel-perfect, burst reports, drill-throughs, and dashboards.
• Optimize report and query performance.
• Develop and maintain metadata models, packages, and data layers.
• Gather requirements and translate business needs into reporting solutions.
• Administer Cognos Dev, QA, and Prod environments.
• Manage security, LDAP/AD integration, roles, permissions, and data sources.
• Monitor platform health, performance, scheduling, and report execution.
• Support deployments, migrations, upgrades, and content store management.
• Troubleshoot platform, security, and report-related issues.

Skills

Cognos Development

Cognos Administration

SQL

Framework Manager

AWS

Performance Tuning

Education

Bachelor's degree in Computer Science

Job description

Role Overview:

Seeking a Senior Cognos Developer/Admin with strong SQL expertise and hands-on Cognos Administration experience. Responsible for developing enterprise reporting solutions while maintaining Cognos platform stability, security, and performance. Ideal candidate has experience in Cognos Development and Administration within large enterprise environments.

Key Responsibilities

Reporting & Development

• Develop and maintain Cognos reports, dashboards, and Framework Manager models.
• Build pixel-perfect, burst reports, drill-throughs, and dashboards.
• Optimize report and query performance.
• Develop and maintain metadata models, packages, and data layers.
• Gather requirements and translate business needs into reporting solutions.

SQL & Data

• Develop complex SQL queries, views, and stored procedures.
• Perform query tuning and execution plan analysis.
• Work with large enterprise datasets.
• Design efficient reporting data models and determine optimal placement of business logic.
• Administer Cognos Dev, QA, and Prod environments.
• Manage security, LDAP/AD integration, roles, permissions, and data sources.
• Monitor platform health, performance, scheduling, and report execution.
• Support deployments, migrations, upgrades, and content store management.
• Troubleshoot platform, security, and report-related issues.

Required Qualifications:

• Bachelor's degree in Computer Science or related field.
• Strong expertise in ALL BELOW WITH Cognos Version 12 and Higher:
• Framework Manager
• Advanced SQL (Oracle, SQL Server, PostgreSQL, Redshift).
• Experience with AWS environments.
• Strong performance tuning and troubleshooting skills.

Preferred Qualifications:

• Cognos migrations, upgrades, and deployments.
• Power BI or Tableau exposure or AWS Quick Sight.- Nice to have
• ETL/Data Integration knowledge.
• Snowflake, Redshift, or cloud analytics experience.

Benefits at IntelliBee

• Long-Term Stability: Join us on a multi-year opportunities with room to grow.
• Comprehensive Health Coverage: Access quality healthcare benefits to keep you and your family well.
• Future Planning: Enroll in our 401(k) program and invest in your financial security.
• GC Assistance: We support immediate Green Card processing, if required.