Senior Developer, Business Intelligence

Key Responsibilities

• Design, develop, test, and deploy Cognos reports (canned and ad-hoc), dashboards and self-service solutions using various studios in Cognos Analytics.
• Build and maintain Framework Manager models and package design to provide robust semantic layers for reporting and analytics.
• Develop complex SQL and stored procedures; work with data cubes and OLAP models where applicable.
• Optimize report performance and troubleshoot issues (query tuning, caching, data source optimization).
• Maintain and implement security models in Cognos (roles, groups, or data-level security).
• Work with data architects (SQL Server, SSIS, TM1, etc.) and source system owners to ensure data correctness, requirement-based enhancements, and new integrations.
• Create and maintain documentation: design documents, technical specifications, runbooks, and end-user guides.
• Implement change control and issue tracking; participate in release management and deployments across environments.
• Aid power users for self-service reporting.
• Promote development best practices and standards.
• Support production environments, respond to incidents, and participate in on-call rotations as needed.
• Stay current with Cognos product updates, new BI trends and tooling, and recommend improvements or migrations.

Desired Skillset

• Extensive knowledge of data analytics and Business Intelligence using tools such as Cognos, Tableau, PowerBI, SSRS.
• Strong SQL skills (complex joins, subqueries, window functions) and experience tuning SQL for performance.
• Familiarity with data warehousing concepts (star/snowflake schemas).
• Proven ability to troubleshoot reporting performance and system issues; knowledge of Cognos logging, caching, and query lifecycle.
• Familiar with ETL processes and working collaboratively with ETL/data engineering teams.
• Experience implementing security and access controls in Cognos.
• Excellent analytical, problem-solving, and communication skills; ability to engage technical and non-technical stakeholders.
• Bachelor's degree in Computer Science, Information Systems, or related field (or equivalent experience).
• Familiarity with platforms such as IBM Planning Analytics/TM1, Microsoft Dynamics GP, Microsoft Dynamics 365, Adobe Workfront, Salesforce. Cloud platforms like Azure, Cognos in cloud.

Compensation

$85,000.00 - $90,000.00
Bonus Eligible: This position is also eligible for a discretionary company bonus, based upon business results.