Job Summary:
ShiftCode Analytics, Inc. is seeking a local IBM Cognos Report Developer for an onsite opportunity in Davis, CA. The role focuses on developing and supporting reporting and dashboard solutions using IBM Cognos, SQL, and PeopleSoft HCM data, while collaborating with various teams to enhance reporting quality and performance.
Responsibilities:
• supporting reporting and dashboard development
• owning reporting solutions end-to-end
• collaborating with business and technical teams
• improving long-term reporting quality, performance, and maintainability
• developing, maintaining, enhancing, and supporting IBM Cognos reports and dashboards
• building and documenting Cognos reports based on Functional Design Documents, JIRA requirements, business user input, and existing reporting standards
• translating business requirements into report design, including layout, look and feel, data access, prompts, filters, drill-throughs, and user interface behavior
• developing and optimizing advanced analytical queries in Oracle and Amazon Redshift databases
• investigating, troubleshooting, and resolving report defects, data discrepancies, query issues, performance issues, and production support items
• creating and executing test plans, test scripts, validation procedures, and unit testing for new and existing reports
• performing data analysis across complex data sets, identifying root causes, evaluating options, and proposing practical solutions
• reviewing new and existing code and collaborating with technical and functional team members to resolve issues and deliver reporting solutions
• working independently while collaborating with business users, developers, QA, data teams, and other stakeholders
• providing recommendations for report improvements, process enhancements, and long-term maintainability
Qualifications:
Required:
• 5+ years of hands-on experience developing, maintaining, enhancing, and supporting IBM Cognos reports and dashboards
• Experience building and documenting Cognos reports based on Functional Design Documents, JIRA requirements, business user input, and existing reporting standards
• Strong ability to translate business requirements into report design, including layout, look and feel, data access, prompts, filters, drill-throughs, and user interface behavior
• Experience with PeopleSoft HCM data
• Strong SQL skills using tools such as Oracle SQL Developer or DBeaver
• Ability to develop and optimize advanced analytical queries in Oracle and Amazon Redshift databases
• Experience investigating, troubleshooting, and resolving report defects, data discrepancies, query issues, performance issues, and production support items
• Experience creating and executing test plans, test scripts, validation procedures, and unit testing for new and existing reports
• Ability to perform data analysis across complex data sets, identify root causes, evaluate options, and propose practical solutions
Preferred:
• Experience reviewing new and existing code and collaborating with technical and functional team members to resolve issues and deliver reporting solutions
• Ability to work independently while collaborating with business users, developers, QA, data teams, and other stakeholders
• Strong documentation skills, including report specifications, data mappings, testing results, and issue resolution notes
• Ability to provide recommendations for report improvements, process enhancements, and long-term maintainability
Company:
ShiftCode Analytics Inc is a Tampa, FL based firm formed with one sole purpose of delivering best and quick services to its clients nationwide. Founded in 2019, the company is headquartered in Tampa, USA, with a team of 51-200 employees. The company is currently Growth Stage.