Rq09075 - Solutions Designer - Senior
Rubicon Path
About the job RQ09075 - Solutions Designer - SeniorDescription
Note: This contract will require the consultant to work from the office location 3 days per week with the remaining 2 days being worked remotely.
An advanced (Level 3) Programmer/Developer is required to develop BI solutions using both Cognos and Microsoft Power BI for varying business needs, following all applicable GO-ITS standards and industry best practices while adhering to the existing technological solution framework. The successful candidate will work with various technology teams to translate business needs and work through the analysis and lead the development phases.
Responsibilities:
Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, works to improve structure and efficiency of an organizations I&IT systems.
Provides subject matter expertise in their field and highly expert technical assistance.
Acts as the technical advisor/expert on all aspects of a specific deliverable
Anticipates and resolves problems to ensure that the deliverables are completed within budget, to the highest quality, meeting or exceeding expectations
Develops processes and procedures for implementing deliverables
Prepares work plan, effort estimates, reports and presentations including options and recommendations, etc.
Works with clients to determine the technical scope of the project and to determine requirements
Defines software, hardware and network requirements
Analyzes I&IT requirements giving independent and objective advice on the use of I&IT
Designs, tests, installs and monitors new systems and develops solutions and implementation of new systems
Familiar with change-management principles and methodology
Knowledge and understanding of Information Management principles, concepts, policies and practices
General Skills:
Ensure seamless integration of new and existing systems, applications, and platforms.
Evaluate and recommend technology stacks, platforms, and tools to support business goals.
Design systems with a focus on security, compliance, and data privacy standards.
Work closely with stakeholders such as business units, development teams, IT infrastructure teams to ensure alignment with project goals.
Ensure solutions are scalable, reliable, and can be optimized for future growth.
Provide technical support and participate in the development, package creation, code merge, testing and release activities.
Primary interface between technical teams (Dev, QA) and business stakeholders, focusing on requirements clarification and UAT.
Develop and manage solutions using Power BI, Cognos, Oracle, MS-SQL, Visual Studio, SSIS, Attunity, ODAC, .NET framework, GIT and SQL-based reporting tools.
Knowledge and understanding of Information Management principles, concepts, policies and practices
Ability to translate business and data requirements into specifications sufficient for designing appropriate technology solutions
Experience with a wide range of methods, tools and techniques for business analysis such as: business functional modelling, business event modelling, business process mapping
Experience in structured, object oriented and agile methodologies for user requirements
Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards
Provides a comprehensive range of I&IT business analysis services for clients with diverse business and technological needs.
Experience in the use of Computer Aided Software Engineering (CASE) tools to document conceptual requirements and scope
Awareness of emerging I&IT trends and technologies
Prepares and advises on business analysis policies, processes, best practices and standards to promote a comprehensive and consistent business analysis practice within the organization.
Knowledge Transfer
Knowledge Transfer should be done to designated technical cluster FTE.
Knowledge transfer must be completed two weeks prior to the consultant leaving the ministry.
All deliverables, including design/supporting/release/training documents must be checked into designated version control repositories (for example, SharePoint, DevOps).
All final documents and working drafts related to project requirements or business analysis or solution design or solution development or QA testing plans or Architectural artefacts and other working related documents are must be stored on designated project SharePoint folder and Azure DevOps.
Project manager and designated FTE must be regularly informed in writing (by email) of where documentation has been stored and must be provided a minimum of one walk-through of all documentation as part of the final knowledge transfer activities.
Knowledge will be transferred through 1 on 1 sessions, emails, document updates and document review with the team.
SkillsExperience and Skill Set RequirementsTechnical Experience - 50%Experience:
The ideal candidate should possess 10+ years of experience as a Solution Designer & Developer, with a focus on the following project environments:
Required Skills (5-7 years): Power BI, MS SQL Server, SSIS, Informatica ETL, Cognos Development, Data Migration & Transformation
Preferred Skills (2-4 years): Oracle, Visual Studio, .NET Framework, Java, Cloud Services, Data Warehousing, Advanced Data Analytics, Version Control
Technical Skills:
Experience with data architecture designs and technologies for BI solutions, for both on-premise and cloud solutions
Experience leading projects that involve technology upgrade/migration to Microsoft BI Suite;
determine which part ofexisting solution needs to be migrated or rebuilt
10+ years of hands on experience ETL development experience using SSIS / ADF in a data warehousing environment or large data migration;
Working experience in debugging mappings, transformations and source qualifier files and Unit testing the newly developed ETL components
Demonstrated knowledge and deep MS stack experience (10 Years) with at least 4 years with Microsoft Azure Data Factory experience
Experience with: Microsoft Azure Data Factory Services, SSIS, SSAS, SSRS, Power BI, DataStage, Quality Stage, Visual Studio, Team Foundation Services, SQL Server Management Studio
An asset if the resource can demonstrate direct experience with Erwin Data Modeler, Power Designer (Hands-on Development Role)
Experience with role-based access control implementation, such as with AzureAD
Experience working with Oracle and MSSQL databases
Extensive experience with source control and environment management
Experience with creating documentations such as data dictionary and data source to target mapping;
provide feedback/direction to team on how existing documentations can be improved
Experience using PowerDesigner to review data models, as well as make changes and generate DDL's
Experience with data ingestion from multiple sources, staging and data cleansing, including dimensional modeling and data model architecture and design aligned with data standards and analytics needs of various stakeholders. Includes creation of data warehouses, views, cubes, and other data services products.
Experience in developing the Application Code package using tools such as Azure DevOps. Build automation experience is an asset
Core Skills - 25%
Long term vision: be able to work with stakeholders to define technical roadmap for current applications, and provide recommendation
Working knowledge of systems design and development, and related methods, techniques, practices and standards enable you to analyze and define clients' business and information technology requirements pertaining to data flow and data integration;
provide recommendation to business
Demonstrates Analytical and problem-solving skills to assess clients' business priorities and needs;
to evaluate business and technical design alternatives
Demonstrates ability to guide the architecture leveraging Azure cloud services, including effective standard use of Microsoft Stack tools and services critical for the integrity, quality and pace of delivery.
Working knowledge of technology, data, databases, applications, and networking techniques, tools and practices enable you to lead the design and development of infrastructure related projects.
Project Experience and Techniques 10%
Demonstrates lead design experience with technology upgrade/migration projects, and shows acumen in being able to evaluate and determine the best path going forward
Demonstrates experience leading discussions with stakeholders to elicit requirements, developing/consulting on options and solutions, and facilitating the resolution of I&IT and Business issues. Ability to drill down on business pain points and determine the right solution, rather than delivering only the item thats being requested by stakeholders
Demonstrates development and design experience with SDLC processes, Agile and Waterfall methodologies
Communication Skills -10%
Demonstrated experience in solving problems analytically, and making sound decisions based on
Experience in negotiating using both verbal and written communication skills and should have worked in a team-based environment with a proven record of meeting deadlines
Strong stakeholder engagement, facilitation, negotiation, and consensus building
Public Sector Experience: 5%
Previous public sector experience in an organization of equivalent size or complexity in Public Service
Demonstrates experience designing and developing applications that comply with GOITS standards and general processes would be an asset;
MUST
Strong experience in developing reports and dashboards in Power BI.
Solid experience in designing, developing, and deploying SSIS packages for ETL processes.
Solid knowledge of MS SQL Server, including T-SQL, stored procedures, and query optimization.
Familiar with data extraction, transformation, and loading (ETL) from various sources to target systems.
Strong product experience such as Power BI, Cognos, Oracle, MS-SQL, Visual Studio, SSIS, Attunity, ODAC, .NET framework, GIT and SQL-based reporting tools.
The ideal candidate should possess
10+ years
of experience as a
Solution Designer & Developer, with a focus on the following project environments:
Required Skills (5-7 years): Power BI, MS SQL Server, SSIS, Informatica ETL, Cognos Development, Data Migration & Transformation
Preferred Skills (2-4 years): Oracle, Visual Studio, .NET Framework, Java, Cloud Services, Data Warehousing, Advanced Data Analytics, Version Control
No activities to show.Get started by sending an email, scheduling a task, and more.Information
To change what's shown, try changing your filters.
#J-18808-Ljbffr
Note: This contract will require the consultant to work from the office location 3 days per week with the remaining 2 days being worked remotely.
An advanced (Level 3) Programmer/Developer is required to develop BI solutions using both Cognos and Microsoft Power BI for varying business needs, following all applicable GO-ITS standards and industry best practices while adhering to the existing technological solution framework. The successful candidate will work with various technology teams to translate business needs and work through the analysis and lead the development phases.
Responsibilities:
Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, works to improve structure and efficiency of an organizations I&IT systems.
Provides subject matter expertise in their field and highly expert technical assistance.
Acts as the technical advisor/expert on all aspects of a specific deliverable
Anticipates and resolves problems to ensure that the deliverables are completed within budget, to the highest quality, meeting or exceeding expectations
Develops processes and procedures for implementing deliverables
Prepares work plan, effort estimates, reports and presentations including options and recommendations, etc.
Works with clients to determine the technical scope of the project and to determine requirements
Defines software, hardware and network requirements
Analyzes I&IT requirements giving independent and objective advice on the use of I&IT
Designs, tests, installs and monitors new systems and develops solutions and implementation of new systems
Familiar with change-management principles and methodology
Knowledge and understanding of Information Management principles, concepts, policies and practices
General Skills:
Ensure seamless integration of new and existing systems, applications, and platforms.
Evaluate and recommend technology stacks, platforms, and tools to support business goals.
Design systems with a focus on security, compliance, and data privacy standards.
Work closely with stakeholders such as business units, development teams, IT infrastructure teams to ensure alignment with project goals.
Ensure solutions are scalable, reliable, and can be optimized for future growth.
Provide technical support and participate in the development, package creation, code merge, testing and release activities.
Primary interface between technical teams (Dev, QA) and business stakeholders, focusing on requirements clarification and UAT.
Develop and manage solutions using Power BI, Cognos, Oracle, MS-SQL, Visual Studio, SSIS, Attunity, ODAC, .NET framework, GIT and SQL-based reporting tools.
Knowledge and understanding of Information Management principles, concepts, policies and practices
Ability to translate business and data requirements into specifications sufficient for designing appropriate technology solutions
Experience with a wide range of methods, tools and techniques for business analysis such as: business functional modelling, business event modelling, business process mapping
Experience in structured, object oriented and agile methodologies for user requirements
Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards
Provides a comprehensive range of I&IT business analysis services for clients with diverse business and technological needs.
Experience in the use of Computer Aided Software Engineering (CASE) tools to document conceptual requirements and scope
Awareness of emerging I&IT trends and technologies
Prepares and advises on business analysis policies, processes, best practices and standards to promote a comprehensive and consistent business analysis practice within the organization.
Knowledge Transfer
Knowledge Transfer should be done to designated technical cluster FTE.
Knowledge transfer must be completed two weeks prior to the consultant leaving the ministry.
All deliverables, including design/supporting/release/training documents must be checked into designated version control repositories (for example, SharePoint, DevOps).
All final documents and working drafts related to project requirements or business analysis or solution design or solution development or QA testing plans or Architectural artefacts and other working related documents are must be stored on designated project SharePoint folder and Azure DevOps.
Project manager and designated FTE must be regularly informed in writing (by email) of where documentation has been stored and must be provided a minimum of one walk-through of all documentation as part of the final knowledge transfer activities.
Knowledge will be transferred through 1 on 1 sessions, emails, document updates and document review with the team.
SkillsExperience and Skill Set RequirementsTechnical Experience - 50%Experience:
The ideal candidate should possess 10+ years of experience as a Solution Designer & Developer, with a focus on the following project environments:
Required Skills (5-7 years): Power BI, MS SQL Server, SSIS, Informatica ETL, Cognos Development, Data Migration & Transformation
Preferred Skills (2-4 years): Oracle, Visual Studio, .NET Framework, Java, Cloud Services, Data Warehousing, Advanced Data Analytics, Version Control
Technical Skills:
Experience with data architecture designs and technologies for BI solutions, for both on-premise and cloud solutions
Experience leading projects that involve technology upgrade/migration to Microsoft BI Suite;
determine which part ofexisting solution needs to be migrated or rebuilt
10+ years of hands on experience ETL development experience using SSIS / ADF in a data warehousing environment or large data migration;
Working experience in debugging mappings, transformations and source qualifier files and Unit testing the newly developed ETL components
Demonstrated knowledge and deep MS stack experience (10 Years) with at least 4 years with Microsoft Azure Data Factory experience
Experience with: Microsoft Azure Data Factory Services, SSIS, SSAS, SSRS, Power BI, DataStage, Quality Stage, Visual Studio, Team Foundation Services, SQL Server Management Studio
An asset if the resource can demonstrate direct experience with Erwin Data Modeler, Power Designer (Hands-on Development Role)
Experience with role-based access control implementation, such as with AzureAD
Experience working with Oracle and MSSQL databases
Extensive experience with source control and environment management
Experience with creating documentations such as data dictionary and data source to target mapping;
provide feedback/direction to team on how existing documentations can be improved
Experience using PowerDesigner to review data models, as well as make changes and generate DDL's
Experience with data ingestion from multiple sources, staging and data cleansing, including dimensional modeling and data model architecture and design aligned with data standards and analytics needs of various stakeholders. Includes creation of data warehouses, views, cubes, and other data services products.
Experience in developing the Application Code package using tools such as Azure DevOps. Build automation experience is an asset
Core Skills - 25%
Long term vision: be able to work with stakeholders to define technical roadmap for current applications, and provide recommendation
Working knowledge of systems design and development, and related methods, techniques, practices and standards enable you to analyze and define clients' business and information technology requirements pertaining to data flow and data integration;
provide recommendation to business
Demonstrates Analytical and problem-solving skills to assess clients' business priorities and needs;
to evaluate business and technical design alternatives
Demonstrates ability to guide the architecture leveraging Azure cloud services, including effective standard use of Microsoft Stack tools and services critical for the integrity, quality and pace of delivery.
Working knowledge of technology, data, databases, applications, and networking techniques, tools and practices enable you to lead the design and development of infrastructure related projects.
Project Experience and Techniques 10%
Demonstrates lead design experience with technology upgrade/migration projects, and shows acumen in being able to evaluate and determine the best path going forward
Demonstrates experience leading discussions with stakeholders to elicit requirements, developing/consulting on options and solutions, and facilitating the resolution of I&IT and Business issues. Ability to drill down on business pain points and determine the right solution, rather than delivering only the item thats being requested by stakeholders
Demonstrates development and design experience with SDLC processes, Agile and Waterfall methodologies
Communication Skills -10%
Demonstrated experience in solving problems analytically, and making sound decisions based on
Experience in negotiating using both verbal and written communication skills and should have worked in a team-based environment with a proven record of meeting deadlines
Strong stakeholder engagement, facilitation, negotiation, and consensus building
Public Sector Experience: 5%
Previous public sector experience in an organization of equivalent size or complexity in Public Service
Demonstrates experience designing and developing applications that comply with GOITS standards and general processes would be an asset;
MUST
Strong experience in developing reports and dashboards in Power BI.
Solid experience in designing, developing, and deploying SSIS packages for ETL processes.
Solid knowledge of MS SQL Server, including T-SQL, stored procedures, and query optimization.
Familiar with data extraction, transformation, and loading (ETL) from various sources to target systems.
Strong product experience such as Power BI, Cognos, Oracle, MS-SQL, Visual Studio, SSIS, Attunity, ODAC, .NET framework, GIT and SQL-based reporting tools.
The ideal candidate should possess
10+ years
of experience as a
Solution Designer & Developer, with a focus on the following project environments:
Required Skills (5-7 years): Power BI, MS SQL Server, SSIS, Informatica ETL, Cognos Development, Data Migration & Transformation
Preferred Skills (2-4 years): Oracle, Visual Studio, .NET Framework, Java, Cloud Services, Data Warehousing, Advanced Data Analytics, Version Control
No activities to show.Get started by sending an email, scheduling a task, and more.Information
To change what's shown, try changing your filters.
#J-18808-Ljbffr
Vacancy posted 42 minutes ago
Similar jobs that could be interesting for youBased on the Rq09075 - Solutions Designer - Senior in Winnipeg, MB vacancy
- ...About the job RQ08000 - Sr Solutions Designer Responsibilities: Undertakes the design of hosting technology solutions based on the client?s service specifications, standards, policies, best practices and cost models, in order to meet client application business requirement...SeniorRemplacementLong term contractTemporary work
$100 - $110 per hour
Job Role: Solutions Designer – Senior (EHS -Emergency Health Solutions)Location: Toronto, ON/OnsitePosition Type: Contract RoleStart Date2026-04-01 End Date2027-10-05 Ideal Rate: CAD 100-110/Hr (Depend on the experience)Must Have: Consulting with developers and COTS...SeniorContract work- About the job RQ09107 - Solutions Designer - SeniorDescription: Responsibilities: Undertakes the design of hosting technology solutions based on the client?s service specifications, standards, policies, best practices and cost models, in order to meet client application business...Senior
- Must Have:At least 10 years of experience in design, development, implementation and maintenance of large complex Oracle Siebel, IBM Curam... ...and technical requirements for new and existing business solutions. Experience and Skill Set RequirementsTechnical Skills (30%)...Senior
- About the job RQ09181 - Solutions Designer - SeniorProvide senior level expertise in AWS cloud platform. Provide design, build and support for cloud environments to create solutions for Contact center domain. Develop and maintain system design models, technical documentation...SeniorLong term contractTemporary workWork at office
- ...Generation of 9-1-1 Ambulance Services? Do you thrive on designing innovative solutions and driving technical excellence? If so, we have the... ...opportunity for you! We are seeking a talented I&IT Senior Solutions Designer to join our dynamic team and play a pivotal role in...SeniorLong term contractTemporary work
- ...progress. And we do it as one team, with openness, creativity, and a shared drive to keep pushing what’s possible. The RoleThe Senior IT Solutions Designer is a senior individual contributor responsible for designing, owning, and evolving the internal platforms Axonify's...SeniorLong term contractWork at officeRemote workHome officeFlexible hours
- About the job RQ08254 - Solutions Designer - Senior Responsibilities Undertakes the design of hosting technology solutions based on the client's service specifications, standards, policies, best practices and cost models, in order to meet client application business requirement...SeniorRemplacementLong term contractTemporary work
- ...presentation for interview. Must Have Oracle EPM Cloud solutions and design knowledge and experience. Experience with FCCS (Financial... ...presentations/findings to various clients, stakeholders and senior managers at the appropriate detail. Mediation, consensus building...Senior
$101.38 - $121.66 per hour
RQ11322 - Solutions Designer - Senior (On-Site)Contract: 6 months (133 business days)+ Possible extensionLocation: Toronto OR Kingston(222 Jarvis St, Toronto / 5700 Yonge St, Toronto / 49 Place d'Armes, Kingston)Must Have: Demonstrated experience as a technical design specialist...SeniorContract work- About the job RQ08673 - Solutions Designer - SeniorThe purpose of this RFS is to acquire one (1) Senior Solutions Designer (Lead Developer) for the designing of hosted technology solutions based on the OPS service specifications, standards, policies, best practices, and cost...Senior
- About the job RQ08861 - Solutions Designer - Senior Responsibilities:Design, develop and enhance large scale software systems using RESTful & Micro Services based architecture and designDesign containerized based solutions/architecturePrepare & continuously improve solution...SeniorRemplacementFlexible hours
- About the job RQ09005 - Solutions Designer - SeniorDescriptionLead the design and execution of modernization strategies aimed at transitioning legacy applications from IBM technologies to Azure-based platforms. Work closely with cross-functional teams to assess current systems...SeniorManual laborRemote work
- RQ10678 - Solutions Designer - Senior (AWS Expert) Downtown Toronto, ON (onsite) Contract (1 year + high possibility of extension) The Senior AWS Solution Designer employ a unique set of skills that put the end user at the centre of EP solutions. This ensures the. This...SeniorContract work
$101.38 - $121.65 per hour
RQ11671 - Solutions Designer - SeniorDuration: 6+ Months (135 Business Days)Location: Any OPS office location-Toronto5 Days OnsiteNo security clearanceMust... ...under the new Species Conservation Act (SCA), 2025. The Senior Solution Designer will provide senior-level technical...SeniorWork at office- ...Tetranex Solutions in Calgary, Alberta is seeking a Senior Electrical Designer - Heat Trace to lead design efforts on energy sector projects. You will supervise drafting, perform heat trace calculations, and develop electrical drawings for single line diagrams, power schematics...Senior
- Lead enterprise solution design with Java, Spring Boot, React, and TypeScript as a Senior Full Stack Solution Designer. Work across front-end and back-end environments.Insight Global seeks a senior technical lead to design and deliver enterprise applications. You will work...Senior
- Design Oracle Siebel CRM and Adobe AEM solutions as a Senior Solutions Designer, translating client requirements into integrated hosting technology designs.This senior position designs solutions around service specifications, standards, policies, best practices, and cost models...Senior
- Design Oracle Siebel CRM and Adobe AEM solutions while translating business requirements into high-level application flows and technical designs.This senior Solutions Designer develops business design documents, functional and non-functional requirements, and application screen...Senior
- Design enterprise solutions with Oracle Siebel CRM and Adobe AEM expertise as a Senior Solutions Designer. Apply strong analytical skills across solution delivery.This senior role focuses on aligning enterprise solutions with business requirements and technical standards. You...Senior
- Design integrated hosting technology solutions across networking, servers, storage, security, and recovery requirements. Work details are not stated.This Senior Solutions Designer develops solutions based on client specifications, standards, policies, best practices, and cost...SeniorLong term contractTemporary work
- Design enterprise generative AI solutions at CIBC in Toronto, using Azure, Python, FastAPI, and full-stack development skills.As a Senior Generative AI Solution Designer, you will translate business needs into architectures and technical roadmaps. You will guide solutions from...Senior
- A technology consulting firm is seeking a Senior Solutions Designer specializing in Salesforce development. This role involves configuring and supporting the Salesforce.com platform while contributing to CRM projects. Ideal candidates will have 10+ years of software development...Senior
- RQ08616 - Solutions Designer - CRM - SeniorAbout the job RQ08616 - Solutions Designer - CRM - SeniorThe Employment Standards program in the Ministry... ...post implementation. LTC is looking for a resource with senior level knowledge and experience in Salesforce. This resource will...SeniorMinimum wageTemporary workInternship
- RQ08784 - Solutions Designer - CRM - SeniorOntario is driving a stronger economy through its recent investments into skilled trades and apprenticeship programs to support job seekers and attract students to lucrative careers in trades. Along with Ontarios investments into healthcare...SeniorLong term contractPermanent employmentApprenticeshipInternship
- Translate complex client needs into structured solutions as a Senior Solutions Designer specializing in requirements, testing, and business architecture.This senior position develops business and system use cases, documents business rules, and creates analytical business requirement...Senior
- Design complex Salesforce CRM solutions in a hybrid senior assignment, using hands-on configuration, integration, and technical design expertise. Work onsite three days weekly and from home two days.This Senior Solutions Designer assignment focuses on Salesforce solutioning,...Senior
- Shape financial systems through Oracle EPM Cloud design, reporting expertise, and structured analysis. Candidates must attend the interview onsite and present an assignment.As a Senior Solutions Designer, you will design and solution financial management, reporting, and consolidation...Senior
- Design Oracle Siebel CRM and Adobe AEM solutions onsite at 222 Jarvis Street in Toronto. Translate requirements into practical technology designs.This senior solutions designer assignment requires seven-plus years designing Siebel or Adobe AEM solutions. You will develop business...Senior
- Explore a pivotal role at Metro Hall as a Senior Solutions Designer with a CRM focus. This position offers 3 days onsite and 2 days remote, catering to professionals with extensive Salesforce expertise. As a part of a 6-month contract, you will leverage your 10+ years of experience...SeniorContract workRemote work
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Rq09075 - Solutions Designer - Senior. Be the first to apply!
Related searches
- power platform solution architect Winnipeg, MB
- senior solution architect Winnipeg, MB
- solution sales manager Winnipeg, MB
- solution architect contract Winnipeg, MB
- senior disability case manager Winnipeg, MB
- senior hardware engineer Winnipeg, MB
- senior cook Winnipeg, MB
- amica senior lifestyles Winnipeg, MB
- senior building operator Winnipeg, MB
- senior project manager Winnipeg, MB

