Business Analyst/Data Consultant

Arcadis; Toronto; Hybrid; CAD 78,000 - 117,000; Full time

Job summary

Arcadis is seeking a passionate Business Analyst/Data Consultant in Toronto, with a focus on data management and business intelligence. The ideal candidate will leverage their expertise in SQL and data analytics within a hybrid working model to deliver impactful solutions. This role involves designing data pipelines, developing reporting solutions, and collaborating with stakeholders to align technical solutions with business needs.

Qualifications

• 7+ years of experience in business analysis, BI solution development, and IT consulting.
• Strong ETL expertise with Microsoft tools.
• Experience with Agile and Waterfall methodologies.

Responsibilities

• Design and manage SQL Server Database environments.
• Develop and optimize ETL processes for data migration.
• Create interactive dashboards and reports using Power BI.

Skills

Data management

Business intelligence

Data analytics

SQL

Data visualization

Communication

Education

Bachelor’s degree in Engineering, Computer Science, Information Technology, or related field

Tools

Power BI

Microsoft SQL Server

Informatica ETL

Azure Data Factory

R

Python

Job description

Join to apply for the Business Analyst/Data Consultant role at Arcadis

Join to apply for the Business Analyst/Data Consultant role at Arcadis

Get AI-powered advice on this job and more exclusive features.

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.

#Mobility-NA

#Mobility-ANA-Jobs

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Other

• Industries

  Professional Services

Referrals increase your chances of interviewing at Arcadis by 2x

Get notified about new Business Analyst jobs in Toronto, Ontario, Canada.

Toronto, Ontario, Canada CA$60.00-CA$60.00 3 weeks ago

Senior Business Analyst - Insurance (Fully Remote)

Freelance Accounting - Quality Assurance/AI Trainer

Intermediate Workday HCM Consultant (Part time)

Sr. Business Analyst (Salesforce): 6-Months Contract

Director Analyst, Enterprise CRM Application Strategy for Leadership (Remote Canada)

Senior Bioinformatics Analyst (12-month Contract)

Toronto, Ontario, Canada CA$90,000.00-CA$100,000.00 4 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.