Business Analyst/Data Consultant | Toronto, ON, Canada

{"domain": "arcadis.com", "user": "Import arcadis.com", "isWillingToRelocate": false, "isUserAuthenticated": false, "isUserETXCandidate": false, "isDomainETX": false, "isCareerPlannerEnabled": false, "isMyApplicationsEnabled": false, "showVeteranEmployerSignUp": false, "candidate": {"enc_id": 0, "fullname": "", "firstname": "", "lastname": "", "skills": [], "email": "", "phone": "", "location": "", "filename": null, "starred_positions": [], "resumeUrl": "", "onboardingCompleted": false, "isUserInPcsIjp": false, "linkedinUrl": ""}, "branding": {"job_insights_display": {"hide_popular_skills": true}, "enableTalentNetwork": 1, "talentNetworkText": "", "homePageHeroBanner": {"opacity": 1, "image": "https://static.vscdn.net/images/careers/demo/arcadis-sandbox/1699963324::PCS+Banner", "hideInMobileView": false}, "navBar": {"color": "#ffffff", "image": "https://static.vscdn.net/images/careers/demo/arcadis-sandbox/1693829356::Primary+Logo+1+Full+Color+RGB+LowRes.png", "link": "https://careers.arcadis.com/", "opacity": 0.75, "background": "#ffffff"}, "privacyLink": "https://www.arcadis.com/en/privacy-for-job-applicants", "uploadResumeModal": {"title": "Welcome to {company_name}'s Career Center", "subtitle": "Streamline your search by uploading your resume to be matched with positions that best suit your qualifications.", "disclaimer": "**Uploading a resume is not a formal application for employment**"}, "perks": [{"icon": "al fa-user-shield fa-9x", "description": "Your well-being matters to us, and we are committed to providing the support you need, whenever you need it. The EAP provides confidential counselling and support services for various personal and work-related situations or concerns.", "title": "Global Employee Assistance Program (EAP)"}, {"icon": "fal fa-business-time fa-9x", "description": "Our culture fosters individual growth within a supportive community, where flexibility isn't just a perk \u2013 it's our promise. With a longstanding commitment to work-life balance, we empower you to tailor your schedule to fit your priorities. Whether it's balancing family commitments, pursuing personal passions, or optimizing productivity, our flexible working is here to support your journey.", "title": "Flexible Working"}, {"icon": "fal fa-user-friends fa-9x", "description": "In our inclusive culture, diversity thrives, fostering an environment where everyone's unique perspectives are valued, supported and respected, empowering individuals to be their best and full selves, every day and collectively solve the world's most complex challenges.", "title": "Inclusive Culture"}, {"icon": "fal fa-chalkboard-teacher fa-9x", "description": "At Arcadis, our commitment to continuous learning and development is exemplified through our Skills Powered approach, which integrates the innovative programs and resources offered in our Basecamp (Expedition DNA). This holistic strategy cultivates talent, propelling career growth and ensuring our team remains at the forefront of an ever-evolving industry landscape.", "title": " Learning & Development"}], "custom_style": {"css": " .nav-item a { color: #fff !important;} .refer .user-name { color: #fff !important; }.perk { text-align: left; width: 240px; padding: 11px; } .fixed-top { background-color: #000 !important; } .position-job-description .block__field--wide-rich-text { width: inherit !important; }\n\n.search-results-main-container .position-cards-container .card-selected {\n    background: #fff !important;\n    border: 1px solid #e5e6e7;\n    border-left: 8px solid #e4610f;\n    box-shadow: 3px 7px 3px -6px #aaa;\n}\n\n#EFSmartApplyContainer > div > div.header-wrapper > div > nav > div > div > p > span > span {\n     color: #000 !important;\n}\n\n.join-tn-link, .custom-navbar-item {\n    color: #000 !important;\n}\n#career-workflow .browse-button{background-color: #e4610f !important;}\n\n.position-card .position-title {\n    color: #e4610f;\n    font-size: 16px !important;\n    font-weight: 600;\n    letter-spacing: .07px;\n    line-height: normal;\n    margin-bottom: 0;\n    text-align: left;\n}\n\n.btn-secondary, .btn-secondary:hover, .btn-secondary:focus, .btn-secondary:active, .btn-secondary.active, .open .dropdown-toggle.btn-secondary, .btn-secondary:active:focus, .btn-secondary:active:hover, .btn-secondary.active:hover, .btn-secondary.active:focus {\n    color: #e4610f !important;\n    background: var(--button-secondary-background-color) !important;\n    border-width: var(--button-secondary-border-width) !important;\n    border-style: var(--button-secondary-border-style) !important;\n    border-color: #e4610f !important;\n}\n\n.go-button {\n    border-radius: 5px;\n    margin-right: 10px;\n    padding-bottom: 7px;\n    padding-left: 10px;\n    padding-right: 10px;\n    padding-top: 7px;\n    color: #e4610f;\n    background: var(--button-secondary-background-color);\n    border-width: var(--button-secondary-border-width);\n    border-style: var(--button-secondary-border-style);\n    border-color: #e4610f;\n}\n\n.apply-form .btn-primary {\n    color: var(--button-primary-text-color) !important;\n    background: #e4610f !important;\n    border-width: var(--button-primary-border-width) !important;\n    border-style: var(--button-primary-border-style) !important;\n    border-color: #e4610f !important;\n}\n\n.advanced-options-button {\n    color: #e4610f;\n    cursor: pointer;\n    display: inline-block;\n    font-size: 14px;\n    padding-left: 10px;\n    margin-left: 10px;\n    margin-right: 10px;\n}\n\n.position-facets .pillTitle {\n    color: #e4610f !important;\n    text-transform: capitalize !important;\n}\n\n.apply-form .btn-primary {\n    color: #e4610f !important;\n    background: #e4610f !important;\n    border-width: var(--button-primary-border-width) !important;\n    border-style: var(--button-primary-border-style) !important;\n    border-color: #e4610f !important;\n}\n\n.upload-resume-modal .dropzone-container .browse-button {\n    color: #ffffff !important;\n    background: #e4610f !important;\n    border-width: var(--button-primary-border-width) !important;\n    border-style: var(--button-primary-border-style) !important;\n    border-color: #e4610f !important;\n}"}, "page_image": "", "max_applications_refer": 0, "mapConfig": {"clusters": {"minimumClusterSize": 1}, "enabled": true, "setMapAsDefaultView": false, "facetLatlongLimit": 5000, "maxZoomLevel": 20, "initByIpGeolocation": false, "zoomInOnMarkerClick": true, "useLatLngLocation": true, "disableMapOnMobile": true}, "favicons": {"favicon": "https://static.vscdn.net/images/careers/demo/arcadis-sandbox/1693829373::ARCAD.AS.png"}, "hideJobCart": true, "links": {"videos": ["https://www.youtube.com/watch?v=GdSgaCPuX3k", "https://www.youtube.com/watch?v=lk1xtXbPG5g", "https://www.youtube.com/watch?v=Df5qnZY6DPc", "https://www.youtube.com/watch?v=awsCi7mBKNM", "https://www.youtube.com/watch?v=DNXGwT0EL7c"]}, "talentNetworkHeroBanner": {"image": "https://static.vscdn.net/images/careers/demo/arcadis-sandbox/1699963349::PCS+Banner+2", "opacity": 1, "background": "#e4610f", "title": " "}, "applyButton": {"background": "#e4610f"}, "talentNetworkBranding": {"custom_style": {"css": ".candidate-login-link {color: #000 !important;}.join-tn-link, .custom-navbar-item {color: #000 !important;} .apply-form .btn-primary {color: #ffffff !important;background: #e4610f !important;border-width: var(--button-primary-border-width) !important;border-style: var(--button-primary-border-style) !important;border-color: #e4610f !important;}"}}, "defaultState": {"pymww": false}, "customContent": {"positionSections": [{"title": "Reminder: No Unsolicited Submissions. Direct Applications Only", "body": "Please note Arcadis does not accept unsolicited CVs from recruitment agencies and no fees will be paid in relation to such submissions. All candidates must apply directly through our official channels. We appreciate your cooperation and understanding."}]}, "recaptcha_enabled": 1, "companyName": "Arcadis", "showLoggedOutNotificationsPrivacyPolicy": true, "hideEightfoldBranding": false}, "pid": "563671521141138", "positions": [{"id": 563671521141138, "name": "Business Analyst/Data Consultant", "location": "Toronto, ON, Canada", "locations": ["Toronto, ON, Canada"], "hot": 0, "department": "Data Scientist", "business_unit": "ANA Canada", "t_update": 1752236564, "t_create": 1748957820, "ats_job_id": "300012888889607", "display_job_id": "31902", "type": "ATS", "id_locale": "31902-en", "job_description": "Arcadis is the world's leading company delivering sustainable design, engineering, and consultancy solutions for natural and built assets. We are more than 36,000 people, in over 70 countries, dedicated to improving quality of life. Everyone has an important role to play. With the power of many curious minds, together we can solve the world's most complex challenges and deliver more impact together. Role description: Arcadis is seeking a Business Analyst/ Data Consultant with expertise in data management, business intelligence, and data pipelines, particularly Microsoft technologies to deliver impactful solutions in a dynamic and collaborative environment. Based in Toronto, this role requires strong technical proficiency, SQL and database management, data analytics and statistics, and data visualization tools, combined with excellent communication and interpersonal skills. The ideal candidate will design and implement data pipeline and transformation processes and develop reporting solutions that align with business needs while ensuring system scalability, security, and performance. Acting as a key technical member in the growing Digital Asset Management practice group in Canada, the individual will bridge the gap between data-driven solutions and client requirements. This position offers a hybrid work model with opportunities to collaborate remotely and on-site at client offices, as needed, while working closely with internal teams and external stakeholders. It's an exciting opportunity for professionals with a passion for data analytics, reporting platforms, and client-focused delivery to make a meaningful impact in a cutting-edge technical environment. Role accountabilities: Data Warehousing (On-premise, cloud and hybrid): Design and manage SQL Server Database Engine environments, including data warehouses, data quality services, and PolyBase Query Service for external data integration. ETL Development (On-premise, cloud and hybrid): Develop and optimize ETL processes using SQL Server Integration Services (SSIS) and Informatica ETL to streamline data transformation and migration. Dashboard & Reporting (On-premise, cloud and hybrid): Create interactive dashboards and reports using Power BI Report Server, Power BI Desktop, Power BI Report Builder tailored to diverse audiences. Advanced Analytics: Utilize tools with R, Python, and F# to support data modeling and advanced analytics initiatives. Data Modeling: Implement multidimensional and tabular models using SQL Server Analysis Services (SSAS) for robust data architecture. Database Optimization: Optimize SQL queries, stored procedures, and database performance. Business Analysis: Collaborate with stakeholders to gather, document, and validate business and I&IT requirements, ensuring alignment with technical solutions. Demonstrated knowledge of code control, code and system change management, team development tools, Waterfall and Agile development methods and tools, database scripting, MS Power Apps, automated code builds, and automated deployment. Training and Support: Provide technical training, guidance, and ongoing support for external clients on data-driven solutions and maintenance activities. Documentation: Produce high-quality documentation, including process models, use cases, design documents, testing plans, and technical reports. Qualifications & Experience: Bachelor's degree in Engineering, Computer Science, Information Technology, or related field. Experience: 7+ years of experience in business analysis, BI solution development, and IT consulting within I&IT environments. ETL Expertise: Strong experience with Microsoft SQL Server Integration Services, Informatica ETL, and Azure Data Factory for data migration and transformation. Database Management: Advanced knowledge of Microsoft SQL Server (data modelling, T-SQL, stored procedures and triggers) and SQL Server Analysis Services. BI Tools: Particularly, proficiency in Power BI (Desktop, Report Builder, Report Server, DAX, Power Query, Gateway, APIs, Security) and Cognos (Report Studio, Framework Manager, Query Studio). Analytics: Experience with R, Python, and F# tools for data analytics and modeling. Methodologies: Working experience with Agile and Waterfall methodologies and the software development lifecycle (SDLC), Azure DevOps (including Boards, Repos, Pipelines, and Test Plans). Experience in spatial data management and familiar with GIS tools will be considered an asset. Experience working with Canadian public sector agencies will be considered an asset. Experience working in proposal development will be considered an asset. Why Arcadis? We can only achieve our goals when everyone is empowered to be their best. We believe everyone's contribution matters. It's why we are pioneering a skills-based approach, where you can harness your unique experience and expertise to carve your career path and maximize the impact we can make together. You'll do meaningful work, and no matter what role, you'll be helping to deliver sustainable solutions for a more prosperous planet. Make your mark, on your career, your colleagues, your clients, your life and the world around you. Together, we can create a lasting legacy. Join Arcadis. Create a Legacy. Our Commitment to Equality, Diversity, Inclusion & Belonging We want you to be able to bring your best self to work every day which is why we take equality and inclusion seriously and hold ourselves to account for our actions. Our ambition is to be an employer of choice and provide a great place to work for all our people. We are an equal opportunity and affirmative action employer. Women, minorities, people with disabilities and veterans are strongly encouraged to apply. We are dedicated to a policy of non-discrimination in employment on any basis including race, creed, color, religion, national origin, sex, age, disability, marital status, sexual orientation, gender identity, citizenship status, disability, veteran status, or any other basis prohibited by law. The salary range for this position is $78,000-$117,000. The base salary represents Arcadis' hiring range for this position. Actual salaries will vary and will be based on various factors, such as location, skills, experience, and qualification for the role. LI-HYBRID LI-REMOTE Mobility-NA Mobility-ANA-Jobs LI-HA1", "stars": 0.0, "medallionProgram": null, "location_flexibility": null, "work_location_option": "onsite", "canonicalPositionUrl": "https://jobs.arcadis.com/careers/job/563671521141138", "isPrivate": false, "latlongs": "43.653226,-79.3831843"}], "isFallback": true, "debug": {}, "count": 1, "personal_message": "We thought you would be interested in this position.", "scheduling": {"minTime": 9, "limit": 10, "maxTime": 17, "increments": 60, "minTimeslots": 3}, "userTitles": [], "enableTargetedResume": 0, "query": {"query": "", "location": "", "department": [], "skill": [], "seniority": [], "pid": "563671521141138"}, "singleview": true, "see_all_jobs": true, "recommended_star_threshold": 4.0, "chatbot": true, "iframeImplementation": null, "pcsApplyFormV2Enabled": true, "isPcsBrandingApril2023Enabled": false, "allowedFileTypes": {}, "pcsTextConfiguration": {}, "hideDepartment": null, "pcsOctupleMigration0Enabled": true, "pcsOctupleMigration1Enabled": false, "replaceUrlOnGoBack": true, "pcsRedesignedNuxEnabled": true, "readmoreInstructionEnabled": false, "userActivityTimeout": 86400000, "userActivityTimeoutEnabled": 1, "isLoggedInPcsEnabled": false, "sortByConfig": [{"id": "new", "label": "Most Recent", "value": "if(field(position.ats_data.externally_published_ts, max), field(position.ats_data.externally_published_ts, max), field(position.timestamp, max)) DESC"}, {"id": "relevance", "label": "Relevance"}], "searchBoxConfig": {}, "excludePrivatePositions": true, "eeocFilterKeywords": ["veteran", "disability", "gender", "race", "citizen", "visa", "ethnicity"], "disableScrollLoadPositionSidebar": false, "locationFlexibilityFrontendEnabled": false, "workLocationOptionFrontendEnabled": true, "remoteFlexibleJobsFilterEnabled": false, "loggedOutNotificationsEnabled": true, "candidateLogin": {"postApplyReviewLink": {"enabled": true, "url": "/api/apply/v2/profile/review/initialize_user?domain=arcadis.com", "title": "What's next? Increase your chances of getting hired!", "message": "Knowing more about you helps us review your application faster. Enrich your profile by adding more skills, awards, and other recognition.", "buttonText": "Review my profile", "verifyEmailTitle": "Let's verify your email", "verifyEmailText": "Click the link in the email to continue reviewing your profile. If you do not immediately see the email, check your spam folder."}}, "prepopulateApplyFormEnabled": true, "prepopulateSettings": {"prepopulateCheckboxText": "Save my answers for future applications", "showPrepopulateCheckbox": false}, "candidateBuildProfile": {}, "enhancementsEnabled": false, "themeBuilderUser": null, "mandatoryFields": ["firstname", "lastname", "email", "phone"], "blindfoldWidgetPcsGate": false, "pcsApplyFormLocationGate": false, "t3sEnabled": false, "uploadApplicationAnswers": false, "candidateAuthV2Enabled": true, "preApplicationSubmitAuthEnabled": false, "applyFormV2Enabled": false, "loggedOutSavedSearchEnabled": false, "locationRadiusTypeToggleEnabled": true, "incompleteApplicationsEnabled": false, "incompleteApplicationConfig": {}, "fallbackPcsJdGate": true, "enableResumeCoach": false, "isPcsEnabled": true, "applicationInfoReviewEnabled": false, "phoneWithCountryCodeEnabled": true, "phoneWithCountryCodeJTNEnabled": false, "notificationSuggestVerificationToken": null, "cookiesAutoDisabled": false, "strictEmailValidationEnabled": true, "chatbotxConfig": {"enabled": false, "featureAccessFlags": {"resumeCoachCardFlags": {"showApplyWithResume": true, "showEditResume": true}, "positionCardFlags": {"showAddToJobCart": false}}}, "pcsOptionalResumeWithJobcartGate": false, "loggedInCandidate": {}, "hamburgerMenuEnabled": false, "sharedTalentPoolGate": false, "pcsAccessibilityHomeEnabled": true, "pcsAccessibilityApplyFormEnabled": true, "showLanguageDropdown": true, "languages": [{"value": "en", "title": "English"}, {"value": "fr", "title": "Fran\u00e7ais"}, {"value": "zh-CN", "title": "\u4e2d\u6587 (\u7b80\u4f53)"}, {"value": "es", "title": "Espa\u00f1ol"}, {"value": "pt", "title": "Portugu\u00eas"}, {"value": "de", "title": "Deutsch"}, {"value": "nl", "title": "Nederlands"}], "displayLanguage": "en", "installed_app_data": [], "singlePageCareersNavbarGate": false, "customJobDescTranslationSkipList": [], "all_applicable_locations": [{"location": "Toronto, ON, Canada", "city": "Toronto", "state": "ON,CA", "country": "CA"}]}