Senior Solutions Designer

2 weeks ago


Toronto, Ontario, Canada Capleo Global Full time
Position: Senior Solutions Designer
Location: Toronto, ON Hybrid
Duration: 12 Months Contract + possible extension

Description:
Undertakes the design of hosting technology solutions based on the client s service specifications, standards, policies, best practices, and cost models, to meet client application business requirements and project/initiative deliverables.

General Skills:
  • Knowledge of integrated networking technologies, mainframe, midrange server, enterprise storage, and SAN, and personal computer system technologies
  • Knowledge of related best practices, OPS directory/messaging standards, standard facilities infrastructure/architecture management, facility service delivery processes, infrastructures policies, procedures and direction, cost models and procurement processes,
  • Ability to gather client business requirements; corporate I&IT information mandates, client information technology strategic plans, environment and standards
  • Ability to participate in the development of solutions and provide advice on short/long-term solution service development activities.
  • Knowledge of leading-edge technologies design criteria, security and recovery procedures, preparation of technical specifications for installation, testing, and performance of integrated, multi-services systems; assess performance and capacity of existing systems make recommendations for improving performance, and develop technical documentation.
  • Experience planning, migrating, implementing, and sustaining large complex system development projects
  • Knowledge of technology developments, trends, and new products to evaluate client application short and long-term technology requirements.
  • Basic knowledge of project management methodology (e.g. PMBOK), analytical tools, and processes.
  • Conceptual and analytical skills to assess and evaluate client needs and conduct cost/benefit analyses for new technology requirements in planning and designing solutions.
  • Experience designing and developing large, complex, highly available, mission-critical server applications
  • Experience with systems evaluation to assess conditions, technical performance and capacity of existing systems and determine the need and feasibility of expansion, renovation or replacement
  • Excellent analytical, problem-solving, and decision-making skills, verbal and written communication skills, interpersonal skills and negotiation skills, and teamwork skills
  • A team player with a track record for meeting deadlines

Specific Skills:
  • Proven experience of working with data as well as related functional applications
  • Conversant with Power BI Design / Accessibility Standards, works with businesses to drive out KPIs and assists with visualization and impactful insights leveraging knowledge of business domain data to drive out business needs using Power BI Proof of Concepts/mock-ups.
  • Demonstrated experience with capturing source-to-target requirements, supporting business rules and dataflow requirements, and comfortable navigating databases using SQL to analyze support of feasibility and documentation.
  • Demonstrated 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 also has Erwin Data Modeler, Power Designer (Hands-on Development Role)
  • Proven 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.
  • Demonstrated knowledge and deep MS stack experience (10 Years) with at least 4 years with Microsoft Azure Data Factory experience
  • Demonstrated 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.

Skills:
Technical Experience - 35%
  • 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 of existing 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 documentation such as data dictionary and data source to target mapping; provide feedback/direction to team on how existing documentation 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 - 35%
  • 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 recommendations 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 - 20%
  • Demonstrates lead design experience with technology upgrade/migration projects, and show acumen in being able to evaluate and determine 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 that s being requested by stakeholders
  • Demonstrates development and design experience with SDLC processes, Agile and Waterfall methodologies

Public Sector Experience: 10%
  • 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-Have:
  • Microsoft BI stack including Power BI for analytic reporting solution experience including ETL experience and experience migrating solutions from Oracle/Cognos/Informatica BI
  • Leading technical team including BI dashboard developers, and assisting architects with documentation
  • Experience with R-scripts and converting requirements from R Scripts into ETL Scripts.
  • 10+ years of hands-on experience in 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.
  • Experience working with Oracle and MSSQL databases.

  • Solution Designer

    2 weeks ago


    Toronto, Ontario, Canada Capleo Global Full time

    Position: Solutions Designer Senior Location: Toronto, ON (Hybrid) Duration: 186 Business Days + Possible ExtensionJob description:At least 7+ years of experience designing solutions with Oracle Siebel CRM or Adobe AEM technologies Experience with developing business design document, functional & non- functional requirements Experience with developing high...


  • Old Toronto, Ontario, Canada 2i Solutions, Inc Full time

    There is a contract opportunity for a Senior Solution Architect in Toronto.Reliability security clearance is mandatory.Must have strong knowledge of IT Infrastructure, Networking, Virtualization, and Service Oriented Architecture (SOA).Familiarity with cloud computing technologies is a plus.If you are available, please send your resume or refer someone...

  • Solutions Designer

    2 weeks ago


    Toronto, Ontario, Canada Capleo Global Full time

    Title: Solutions Designer - SeniorLocation: Toronto, ON (Hybrid)Duration: 100 Business Days + Possible extension Job description:At least 7+ years of experience designing solutions with Oracle Siebel CRM or Adobe AEM technologies. Experience with developing business design document, functional & non- functional requirements. Experience with developing high...

  • Solution Designer

    2 weeks ago


    Toronto, Ontario, Canada Capleo Global Full time

    Title: Solutions Designer - CRM - SeniorLocation: Toronto, ON (Hybrid)Duration: 93 Business Days + Possible extension Job Description:At least 7+ years of experience designing solutions with Oracle Siebel CRM or Adobe AEM technologies. Experience with developing business design document, functional & non- functional requirements. Experience with developing...


  • Toronto, Ontario, Canada JMP Solutions - Canada Full time

    Senior Systems Designer - JMP Solutions, a Convergix Automation Company System Designers are high level thinkers and experts in multiple disciplines in automation making them able to define and refine basic approaches to automation, working through roadblocks, detailing out technical plans of action and communicating to all stakeholders. Our focus is process...


  • Toronto, Ontario, Canada Canadian Imperial Bank of Commerce Full time

    We're building a relationship-oriented bank for the modern world. The Senior Consultant, Solution Design is responsible for leading the functional design and development of application systems across all technologies and platforms. The role provides consultation for senior management on a wide spectrum of existing and emerging infrastructure technologies,...

  • Solutions Designer

    2 weeks ago


    Toronto, Ontario, Canada AMANST Inc Full time

    AMANST Inc. is looking for Solutions Designer – Senior for a contract opportunity with Government of Ontario. Requisition deadline: 19 June 2024 at 03:00 pm Must Have Skills:10+ years of experience in software development and delivery track record in a range of technical roles ideally 5 yrs of experience in AWS cloud using AWS Services and tools, including...

  • Solutions Designer

    6 days ago


    Toronto, Ontario, Canada Cleo Consulting Full time

    Assignment: RQ Solutions Designer - IntermediateJob Title: Solutions DesignerRequisition (SS): RQ07529Start Date: End Date: Client: Government Services Integration ClusterOffice Location: TorontoOrganization: Government Services Integration ClusterMinistry: Ministry of Public and Business Service Delivery (former MGCS)# Business Days: 228.00Note: Candidate...


  • Toronto, Ontario, Canada Float Financial Solutions Inc. Full time

    Float is one of Canada's fastest growing companies and Top Startups. We're the one-stop platform for our customers – Canadian businesses – to conduct and control their corporate spending. We serve thousands of customers nationwide, across the entire spectrum of industries in our economy. In an uncertain economic environment, our approach is truly...


  • Toronto, Ontario, Canada Randstad Canada Full time

    Role: Solution Architect - GuidewireDuration: 6+ Months ContractLocation: Toronto, ON HYBRID***Candidates MUST be located in Toronto, ON / GTA This is a HYBRID Role 2 days work from office***Seniority Level - 10+ Years (Senior)Required / Desired Skills:Create solutions and design for Guidewire Insurance platform Guidewire ClaimCenter.Knowledge of other...

  • Senior Designer

    2 weeks ago


    Toronto, Ontario, Canada Scotiabank Full time

    Contributes to the overall success of design management working as part of a dynamic team within Scotiabank's Real Estate department and ensuring specific individual goals, plans and initiatives are executed/delivered in support of the team's business strategies and objectives. Ensures all activities are conducted in compliance with governing regulations,...

  • IT Solution Architect

    2 weeks ago


    Toronto, Ontario, Canada Tundra Technical Solutions Inc. Full time

    Enterprise Core Banking Technology We are Enterprise Core Technology focused on Proudly supporting US Deposits We work closely with our Business Partners, Developers, Vendors and various partners within the Bank to ensure we deliver successful projects which align with the overall business strategies and roadmaps ensuring the highest quality experience for...


  • Toronto, Ontario, Canada EXACT SCIENCES CORPORATION Full time

    EXACT SCIENCES CORPORATION Senior Solutions Architect SAP MADISON , Wisconsin Apply NowJOB REQUIREMENTS:Help us change lives At Exact Sciences, we\'rehelpingchange how the world prevents, detects and guides treatment forcancer. Join our team to find apurpose-driven career, an inclusive culture, and robust benefits tosupport your life while you\'re working to...

  • Senior Designer

    2 weeks ago


    Toronto, Ontario, Canada Scotiabank Full time

    Requisition ID: 199664Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. Contributes to the overall success of design management working as part of a dynamic team within Scotiabank's Real Estate department and ensuring specific individual goals, plans and initiatives are executed/delivered in support of the...


  • Toronto, Ontario, Canada Randstad Canada Full time

    This is a contract position for a Solutions Designer - Senior for our public sector client.Work location: 222 Jarvis StreetDuration: Three Months7.25 hours/dayThis is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional circumstances.)AdvantagesGood...

  • Solutions Designer

    2 weeks ago


    Toronto, Ontario, Canada AMANST Inc Full time

    MUST Microsoft BI stack including Power BI for analytic reporting solution experience including ETL experience and experience migrating solutions from Oracle/Cognos/Informatica BI Leading technical team including BI dashboard developers, and assisting architects with documentation Experience with R-scripts and converting requirements from R Scripts into...


  • Toronto, Ontario, Canada AtkinsRéalis Full time

    Senior Substation Designer Are you looking for a company that works on major engineering projects all over the world? Do you want to make a difference by improving the daily lives of communities worldwide? AtkinsRéalis is in search of a Senior Substation Designer to work within a multi-discipline team to design efficient and reliable electrical...

  • Senior UX Designer

    2 weeks ago


    Toronto, Ontario, Canada CB Canada Full time

    Senior UX Designer On behalf of our client in the Government Services Sector, PROCOM is looking for a Senior UX Designer. Senior UX Designer – Job Description There are four (4) distinct delivery phases in which user experience designers (task based I&IT consultants) produce deliverables following Ontario Digital Service Design playbook, which outlines...

  • Solutions Designer

    2 weeks ago


    Toronto, Ontario, Canada TalentBridge Holdings Corporation Full time

    Title: Solutions Designer Duration: 6+ Months Contract Location: Toronto, ON Hybrid Work Environment: 2 Days remote, 3 Days Onsite Technical Experience Experience and Skill Set Requirements Experience with data architecture designs and technologies for BI solutions, for both on-premise and cloud solutions Experience leading projects that involve...

  • Solutions Designer

    2 weeks ago


    Toronto, Ontario, Canada TalentBridge Full time

    Title: Solutions DesignerDuration: 6+ Months ContractLocation: Toronto, ONHybrid Work Environment: 2 Days remote, 3 Days Onsite Experience and Skill Set RequirementsTechnical ExperienceExperience with data architecture designs and technologies for BI solutions, for both on-premise and cloud solutions Experience leading projects that involve technology...