BI Solutions Designer
Assignment : RQ06197 SolutionsDesigner Senior & RQ06198 Solutions Designer Senior
Start Date : End Date :
End Date :
Office Location : 777Bay Street Toronto
Organization : Community ServicesCluster
Ministry : Ministry of Education
Business Days : 251.00
Title : SolutionsDesigner
Hybrid 3 days onsite and 2 remote
MUST
- Microsoft BI stack including Power BI for analyticreporting solution experience including ETL experience andexperience migrating solutions from Oracle / Cognos / InformaticaBI
- Leading technical team including BIdashboard developers and assisting architects withdocumentation
- Experience with Rscripts andconverting requirements from R Scripts into ETL Scripts.
- 10 years of handson experience ETL development experienceusing SSIS / ADF in a data warehousing environment or large datamigration;
Working experience in debugging mappings transformationsand source qualifier files and Unit testing the newly developed ETLcomponents.
Experience working with Oracle andMSSQL databases.
Description
Responsibilities :
Undertakes the design ofhosting technology solutions based on the clients servicespecifications standards policies best practices and cost models inorder to meet client application business requirement andproject / initiative deliverables.
GeneralSkills :
Knowledge of integrated networkingtechnologies mainframe midrange server enterprise storage and SANand personal computer system technologies
Knowledge ofrelated best practices OPS directory / messaging standards standardfacilities infrastructure / architecture management facility servicedelivery processes infrastructures policies procedures anddirection cost models and procurement processes
Abilityto gather client business requirements; corporate I&ITinformation mandates client information technology strategic plansenvironment and standards
Ability to participate in thedevelopment of solutions and provide advice on short / long termsolution service development activities.
Knowledge ofleading edge technologies design criteria security and recoveryprocedures preparation of technical specifications for installationtesting and performance of integrated multiservices systems;
assessperformance and capacity of existing system making recommendationsfor improving performance and develop technicaldocumentation.
Experience planning migratingimplementing and sustaining large complex system developmentprojects
Knowledge of technology developments trends andnew products to evaluated application to client short and long termtechnology requirements.
Basic knowledge of projectmanagement methodology (e.g. PMBOK) analytical tools andprocesses.
Conceptual and analytical skills to assessand evaluate client needs and conduct cost / benefit analyses for newtechnology requirements in planning and designingsolutions.
Experience designing and developing largecomplex highly available mission critical serverapplications
Experience with systems evaluation toassess conditions technical performance and capacity of existingsystems and determine need and feasibility of expansion renovationor replacement
Excellent analytical problemsolving anddecisionmaking skills verbal and written communication skillsinterpersonal skills and negotiation skills team workskills
A team player with a track record for meetingdeadlines
Specific Skills :
Provenexperience of working with data as well as the related functionalapplications
Conversant with Power BI Design / Accessibility Standards works with business to drive out KPIs andassists with visualization and impactful insights leveragingknowledge of business domain data to drive out business needs usingPower BI Proof of Concepts / mockups.
Demonstratedexperience with capturing source to target requirements supportingbusiness rules and dataflow requirements comfortable navigatingdatabases using SQL to conduct analysis in support of feasibilityand documentation.
Demonstrated experience with : Microsoft Azure Data Factory Services SSIS SSAS SSRS Power BIDataStage Quality Stage Visual Studio Team Foundation Services SQLServer Management Studio
An asset if the resource alsohas Erwin Data Modeler Power Designer (Handson DevelopmentRole)
Proven ability to guide the architectureleveraging Azure cloud services including effective standard use ofMicrosoft Stack tools and services critical for the integrityquality and pace of delivery.
Demonstrated knowledge anddeep MS stack experience (10 Years) with at least 4 years withMicrosoft Azure Data Factory experience
Demonstratedexperience with data ingestion from multiple sources staging anddata cleansing including dimensional modeling and data modelarchitecture and design aligned with data standards and analyticsneeds of various stakeholders.
Includes creation of data warehousesviews cubes and other data services products.
Experience and SkillSet Requirements
Technical Experience 35%
Experience with data architecture designs and technologies for BIsolutions for both onpremise and cloud solutions
Experience leading projects that involve technologyupgrade / migration to Microsoft BI Suite; determine which part ofexisting solution needs to be migrated or rebuilt
10years 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 sourcequalifier files and Unit testing the newly developed ETLcomponents
Demonstrated knowledge and deep MS stackexperience (10 Years) with at least 4 years with Microsoft AzureData Factory experience
Experience with : Microsoft AzureData Factory Services SSIS SSAS SSRS Power BI DataStage QualityStage Visual Studio Team Foundation Services SQL Server ManagementStudio
An asset if the resource can demonstrate directexperience with Erwin Data Modeler Power Designer (HandsonDevelopment Role)
Experience with rolebased accesscontrol implementation such as with AzureAD
Experienceworking with Oracle and MSSQL databases
Extensiveexperience with source control and environmentmanagement
Experience with creating documentations suchas data dictionary and data source to target mapping; providefeedback / direction to team on how existing documentations can beimproved
Experience using PowerDesigner to review datamodels as well as make changes and generate DDLs
Experience with data ingestion from multiple sources staging anddata cleansing including dimensional modeling and data modelarchitecture and design aligned with data standards and analyticsneeds of various stakeholders.
Includes creation of data warehousesviews cubes and other data services products.
Experiencein developing the Application Code package using tools such asAzure DevOps. Build automation experience is an asset
Core Skills35%
Long term vision : be able to work withstakeholders to define technical roadmap for current applicationsand provide recommendation
Working knowledge of systemsdesign and development and related methods techniques practices andstandards enable you to analyze and define clients business andinformation technology requirements pertaining to data flow anddata integration;
provide recommendation to business
Demonstrates Analytical and problemsolving skills to assess clientsbusiness priorities and needs; to evaluate business and technicaldesign alternatives
Demonstrates ability to guide thearchitecture leveraging Azure cloud services including effectivestandard use of Microsoft Stack tools and services critical for theintegrity quality and pace of delivery.
Workingknowledge of technology data databases applications and networkingtechniques tools and practices enable you to lead the design anddevelopment of infrastructure related projects.
Project Experience andTechniques 20%
Demonstrates lead designexperience with technology upgrade / migration projects and showacumen in being able to evaluate and determine best path goingforward
Demonstrates experience leading discussions withstakeholders to elicit requirements developing / consulting onoptions and solutions facilitating the resolution of I&IT andBusiness issues.
Ability to drill down on business pain points anddetermine the right solution rather than delivering only the itemthats being requested by stakeholders
Demonstratesdevelopment and design experience with SDLC processes Agile andWaterfall methodologies
Public Sector Experience : 10%
Previous public sector experience in anorganization of equivalent size or complexity in PublicService
- Demonstrates experience designing and developingapplications that comply with GOITS standards and general processeswould be an asset;