Senior Cognos Developer

BioSpace; Frederick (MD); On-site; USD 113,000 - 161,000; Full time

Benefits offered by this job

Health and Wellness programs

Paid Leave and Retirement

Job summary

Leidos Biomedical Research, Inc. in Frederick, MD seeks a senior Enterprise Reporting Analyst to design, build, and maintain IBM Cognos reports and dashboards for finance, HR, and projects.

You will develop semantic models, optimize SQL queries, and integrate with Power BI/Tableau as needed, while ensuring secure access and data integrity. Earned degree or 5+ years of enterprise reporting experience required.

Qualifications

• Bachelor’s degree or four years of relevant experience required.
• Minimum of five years developing enterprise reporting solutions with IBM Cognos Analytics.
• Expert knowledge of IBM Cognos Analytics, Framework Manager, Report Authoring, and Dashboard Authoring.
• Strong data modeling experience and semantic layer design.
• Experience with Oracle or SQL Server databases and writing complex SQL.
• Experience with Power BI, Tableau, or Qlik Sense preferred.
• Ability to obtain and maintain a security clearance.

Responsibilities

• Design, build, and maintain reports in IBM Cognos Analytics.
• Develop interactive dashboards and visual analytics; potentially cross-referencing with Power BI, Tableau, or Qlik Sense.
• Modify and troubleshoot existing reports based on user feedback or changing business requirements.
• Perform data modeling and maintain Framework Manager models and data modules.
• Update models as underlying source systems change (e.g., Deltek Costpoint).
• Ensure the semantic layer accurately reflects business logic for Finance, HR, or Project Accounting data.
• Write and optimize complex SQL queries against Oracle or SQL Server; develop stored procedures, views, and functions.
• Diagnose and resolve query performance issues; review execution plans and tuning.
• Explain and mentor junior developers; lead technical initiatives.
• Ability to obtain and maintain a security clearance.

Skills

IBM Cognos Analytics

Framework Manager

Report Authoring

Dashboard Authoring

SQL development

Data Modeling

Oracle/SQL Server

Education

Bachelor’s degree or 4 years relevant experience

Tools

Deltek Costpoint

Power BI

Tableau

Qlik Sense

Job description

Job ID: req4674
Employee Type: exempt full-time
Division: Enterprise Information Technology
Facility: Frederick: Ft Detrick
Location: PO Box B, Frederick, MD 21702 USA
The Frederick National Laboratory is operated by Leidos Biomedical Research, Inc. The lab addresses some of the most urgent and intractable problems in the biomedical sciences in cancer and AIDS, drug development and first-in-human clinical trials, applications of nanotechnology in medicine, and rapid response to emerging threats of infectious diseases.

Accountability, Compassion, Collaboration, Dedication, Integrity and Versatility; it's the FNL way.

Program Description

The Enterprise IT (EIT) Directorate oversees the strategic vision and implementation plan for IT systems and solutions for the enterprise at Leidos Biomedical Research, providing operational information and data systems support to Frederick National Laboratory for Cancer Research.
The Enterprise Solutions group (BES) is part of the Enterprise IT directorate, overseeing the strategic vision and implementation plan of IT systems and solutions that the support Frederick National Laboratory for Cancer Research (FNL) operational and scientific organizations. The BES scope includes development, integration and optimization of the enterprise business systems used by the FNL operator, Leidos Biomedical Research, as well as logical and automation solutions for the scientific community.

Key Roles/ Responsibilities

• Design, build, and maintain reports in IBM Cognos Analytics (Report Authoring, Dashboard Authoring).
• Develop interactive dashboards and visual analytics, potentially cross-referencing with Power BI, Tableau, or Qlik Sense for specific business units.
• Modify and troubleshoot existing reports based on user feedback or changing business requirements Test and validate report outputs against source data for accuracy.
• Perform Data Modeling and build and maintain Framework Manager models and data modules that serve as the semantic layer for reporting.
• Update models as underlying source systems (e.g., Deltek Costpoint) change.
• Ensure the semantic layer accurately reflects business logic for Finance, HR, or Project Accounting data.
• Perform SQL & database tasks.
• Write and optimize complex SQL queries against Oracle or SQL Server.
• Develop and maintain stored procedures, views, and functions.
• Diagnose and resolve query performance issues.
• Review execution plans and tune indexing/queries.

Basic Qualifications

To be considered for this position, you must minimally meet the knowledge, skills, and abilities listed below:

• Possession of Bachelor’s degree from an accredited college/university according to the Council for Higher Education Accreditation (CHEA) or four (4) years relevant experience in lieu of degree. Foreign degrees must be evaluated for U.S. equivalency.
• In addition to the education requirement, a minimum of five (5) years of hands-on experience developing enterprise reporting solutions using IBM Cognos Analytics.
• Expert knowledge of:
• IBM Cognos Analytics (11.x/12.x)
• Framework Manager
• Report Authoring
• Dashboard Authoring
• Strong data modeling experience, including designing and maintaining Framework Manager models, data modules, and enterprise semantic layers.
• Experience analyzing business requirements and translating them into scalable reporting and data models.
• Strong SQL development skills with experience writing complex queries and optimizing performance.
• Working knowledge of database programming, including stored procedures, views, functions, and query optimization.
• Experience with Oracle, SQL Server, or other enterprise relational databases.
• Experience developing interactive dashboards and visual analytics using Power BI, Tableau, Qlik Sense, or a comparable enterprise BI visualization platform.
• Strong understanding of Cognos security architecture, LDAP/Active Directory integration, and deployment processes.
• Experience troubleshooting performance issues and optimizing enterprise reporting environments.
• Excellent analytical, problem-solving, and communication skills.
• Ability to work independently, lead technical initiatives, and mentor junior developers.
• Ability to obtain and maintain a security clearance.

Preferred Qualifications

Candidates with these desired skills will be given preferential consideration:

• Experience with Deltek Costpoint ERP and reporting.
• Experience developing reports for Finance, HR, or Project Accounting.
• Experience with ETL tools such as SSIS or Informatica.
• Experience integrating REST APIs or web services into reporting solutions.
• Experience with Azure DevOps (ADO), Git, or other version control systems.
• Experience supporting cloud migration or modernization initiatives.

Commitment to Non-Discrimination

All qualified applicants will receive consideration for employment without regard to sex, race, ethnicity, color, age, national origin, citizenship, religion, physical or mental disability, medical condition, genetic information, pregnancy, family structure, marital status, ancestry, domestic partner status, sexual orientation, gender identity or expression, veteran or military status, or any other basis prohibited by law. Leidos will also consider for employment qualified applicants with criminal histories consistent with relevant laws.

Pay And Benefits

Pay and benefits are fundamental to any career decision. That's why we craft compensation packages that reflect the importance of the work we do for our customers. Employment benefits include competitive compensation, Health and Wellness programs, Income Protection, Paid Leave and Retirement. More details are available here
112,600.00 - 161,142.00 USD
The posted pay range for this job is a general guideline and not a guarantee of compensation or salary. Additional factors considered in extending an offer include, but are not limited to, responsibilities of the job, education, experience, knowledge, skills, and abilities as well as internal equity, and alignment with market data.
The salary range posted is a full-time equivalent salary and will vary depending on scheduled hours for part time positions