Business Analyst/Data Consultant

Arcadis is the worlds leading company delivering sustainable design engineering and consultancy solutions for natural and built assets.

We are more than 36000 people in over 70 countries dedicated toimproving quality of life. Everyone has an important role to play. With the power of many curious minds together we can solve the worlds 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. Its 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:

• Bachelors 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 everyones contribution matters. Its 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.

Youll do meaningful work and no matter what role youll 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.

#LI-HYBRID
#LI-REMOTE
#Mobility-NA
#Mobility-ANA-Jobs
#LI-HA1