We are seeking a Software Developer with expertise in IBM Cognos Analytics v12.x, Oracle 19+, and Redshift to support business intelligence (BI) reporting, data modeling, and performance optimization. This hybrid role requires three days onsite and two days remote and involves developing data models, creating reports, and optimizing SQL queries to enhance decision-support systems.
...
Advantages
•Hybrid Work Model: Work three days onsite and two days remote, ensuring flexibility and collaboration.
•Cutting-Edge BI Tools: Gain experience working with IBM Cognos Analytics v12.x, Power BI, Tableau, and Redshift.
•Impactful Role: Support decision-making systems that drive critical business intelligence initiatives.
•High-Level Technical Expertise: Engage in data warehouse design, performance tuning, and complex SQL development.
•Long-Term Growth: Opportunity for contract extensions and involvement in future BI enhancements.
Responsibilities
•Develop and maintain Cognos BI reports and dashboards using Cognos Analytics v12.x.
•Convert user requirements into business models for BI implementation.
•Design, build, and test dimensional data models for Data Warehouse and Data Mart.
•Implement metadata, user groups, security models, and folder structures for BI objects.
•Develop and maintain Cognos Framework Manager Models.
•Write and optimize complex SQL, PL/SQL, and Redshift queries.
•Create and manage materialized views and stored procedures for performance optimization.
•Support SQL tuning and database performance enhancement.
•Assist with data integration, transformation, and ETL processes.
•Test, debug, and resolve BI reporting issues.
•Document test cases and ensure full functionality testing.
•Deploy reports and metadata models using Cognos Framework Manager.
•Support system implementation and user testing.
•Conduct training sessions and demos for end-users and business analysts.
•Provide technical documentation for data preparation and performance monitoring.
•Support business enhancements and change management processes.
•Collaborate with business intelligence teams, database administrators, and IT staff to align BI solutions with business needs.
Qualifications
Required Experience
•5+ years of experience in Cognos Analytics v12.x (development, testing, and administration).
•Strong SQL expertise in Oracle 19+ and Redshift, including complex queries and optimization.
•Hands-on experience in data warehouse and data mart development.
•Expertise in Framework Manager modeling and dimensional data modeling.
•Experience with BI tools like Power BI and Tableau.
•Knowledge of Agile/Scrum methodologies and tools like JIRA and Confluence.
•Experience with Linux, cloud environments (Azure, AWS), and BI security models.
Preferred Skills
•Experience with performance tuning in Cognos and database administration.
•Proficiency in JavaScript for advanced Cognos report customization.
•Familiarity with public sector data governance and compliance standards.
Summary
This Software Developer role is ideal for professionals with strong Cognos BI expertise and SQL development skills looking to work in a hybrid cloud-based business intelligence environment. The role provides opportunities to enhance BI reporting, optimize SQL performance, and support critical data-driven decision-making processes.
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
show more
We are seeking a Software Developer with expertise in IBM Cognos Analytics v12.x, Oracle 19+, and Redshift to support business intelligence (BI) reporting, data modeling, and performance optimization. This hybrid role requires three days onsite and two days remote and involves developing data models, creating reports, and optimizing SQL queries to enhance decision-support systems.
Advantages
•Hybrid Work Model: Work three days onsite and two days remote, ensuring flexibility and collaboration.
•Cutting-Edge BI Tools: Gain experience working with IBM Cognos Analytics v12.x, Power BI, Tableau, and Redshift.
•Impactful Role: Support decision-making systems that drive critical business intelligence initiatives.
•High-Level Technical Expertise: Engage in data warehouse design, performance tuning, and complex SQL development.
•Long-Term Growth: Opportunity for contract extensions and involvement in future BI enhancements.
Responsibilities
•Develop and maintain Cognos BI reports and dashboards using Cognos Analytics v12.x.
•Convert user requirements into business models for BI implementation.
•Design, build, and test dimensional data models for Data Warehouse and Data Mart.
...
•Implement metadata, user groups, security models, and folder structures for BI objects.
•Develop and maintain Cognos Framework Manager Models.
•Write and optimize complex SQL, PL/SQL, and Redshift queries.
•Create and manage materialized views and stored procedures for performance optimization.
•Support SQL tuning and database performance enhancement.
•Assist with data integration, transformation, and ETL processes.
•Test, debug, and resolve BI reporting issues.
•Document test cases and ensure full functionality testing.
•Deploy reports and metadata models using Cognos Framework Manager.
•Support system implementation and user testing.
•Conduct training sessions and demos for end-users and business analysts.
•Provide technical documentation for data preparation and performance monitoring.
•Support business enhancements and change management processes.
•Collaborate with business intelligence teams, database administrators, and IT staff to align BI solutions with business needs.
Qualifications
Required Experience
•5+ years of experience in Cognos Analytics v12.x (development, testing, and administration).
•Strong SQL expertise in Oracle 19+ and Redshift, including complex queries and optimization.
•Hands-on experience in data warehouse and data mart development.
•Expertise in Framework Manager modeling and dimensional data modeling.
•Experience with BI tools like Power BI and Tableau.
•Knowledge of Agile/Scrum methodologies and tools like JIRA and Confluence.
•Experience with Linux, cloud environments (Azure, AWS), and BI security models.
Preferred Skills
•Experience with performance tuning in Cognos and database administration.
•Proficiency in JavaScript for advanced Cognos report customization.
•Familiarity with public sector data governance and compliance standards.
Summary
This Software Developer role is ideal for professionals with strong Cognos BI expertise and SQL development skills looking to work in a hybrid cloud-based business intelligence environment. The role provides opportunities to enhance BI reporting, optimize SQL performance, and support critical data-driven decision-making processes.
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
show more
