Data & Analytics Consultant

Accenture; Toronto; Hybrid; CAD 90,000 - 130,000; Full time

Job summary

Accenture Infrastructure & Capital Projects is seeking a seasoned BI/Analytics lead to connect client business teams with data specialists. You will design executive dashboards in Power BI, build scalable Snowflake data models, and deliver reliable reporting for capital projects.

The role requires 5+ years in BI, strong stakeholder management, and expertise in SQL, data modeling, and Agile practices. Hybrid work with travel to client sites is expected.

Qualifications

• Bachelor's degree or higher in a related field.
• 5+ years of BI, project controls, data analytics, or analytics engineering.
• Experience managing hard client relationships and driving consensus.
• Advanced proficiency in Power BI with data modeling and UI/UX for executive reporting.

Responsibilities

• Act as the primary bridge between the client’s business teams (Engineering, Construction, Procurement) and the technical data team.
• Lead requirements workshops and translate business needs into clear technical specs, data models, and KPIs.
• Design and develop interactive Power BI dashboards for executives; ensure insights are actionable.
• Work within Snowflake & Power BI to design robust data models and write complex SQL transforms.
• Own data quality by tracing dashboard numbers back to source data and business rules.
• Collaborate to monitor CI/CD pipelines and troubleshoot data ingestion issues.
• Hybrid work arrangement with onsite client sites and travel to project milestones.

Skills

Power BI Mastery

Snowflake & SQL

Data Translation

Agile Collaboration

Stakeholder Management

5+ years experience

Domain Knowledge

JIRA & Git

Education

Bachelor's degree in Computer Science, Engineering, or related field

Tools

JIRA

Git

Job description

You’ve Never Been Satisfied with “Good Enough.”

You want to make an impact, not just manage projects, but change how the world gets built. At Accenture Infrastructure & Capital Projects, you’ll do exactly that. You’ll help develop and deliver the factories, grids, transit systems, and public infrastructure that keep communities moving - and do it smarter, safer, and more sustainably than ever before.

You’ll work alongside people who think big and act bold - project managers, engineers, technologists, and strategists who blend real-world experience with digital innovation and AI.

Together, we’re transforming how capital projects are planned, managed, and executed, creating a better way to build for the future.

Because “good enough” builds the past. You’re here to build what’s next, on a team that outperforms every norm.

Visit us here to learn more about Accenture Infrastructure & Capital Projects

• (Internal Title: Business System Configuration / Development II)
• Client Relationship & Stakeholder Management: Act as the primary bridge between the client’s business teams (Engineering, Construction, Procurement) and the technical data team. You will navigate complex stakeholder dynamics and manage expectations in a high-pressure environment.
• Requirements Translation: Lead requirements workshops and working sessions to uncover business needs, clarify ambiguous requirements, and define KPIs aligned to how capital programs are actually managed. Translate business questions into clear technical specifications, data models, and reporting logic.
• Business Intelligence & Visualization: Design and develop interactive, high impact executive dashboards in Power BI. You will be responsible for the "last mile" of data delivery—ensuring insights are accurate, intuitive, and actionable. Apply domain knowledge and program management/project controls expertise to ensure reporting products align to best practices.
• Data Logic & Engineering: Work within the client’s Snowflake & Power BI environment to design robust data models. While you will collaborate with architects, you must be capable of writing complex SQL transformations to clean, normalize, and prepare EPC data (Oracle Primavera P6, and other PMIS tools etc.) for reporting.
• Quality Assurance: Own the validity of the data. You will trace numbers from the dashboard back to the source to ensure trust and alignment with business rules.
• Process Oversight: Collaborate with the technical team to monitor CI/CD pipelines (GitHub/DevOps) and troubleshoot data ingestion issues that impact reporting availability.
• Working Conditions:
• Hybrid: This role's work location is primarily onsite with our client and partners to enable delivery and cultivate our client relationships, but will see some travel to various client sites at key project milestones.

HERE’S WHAT YOU’LL NEED:

• Bachelor’s degree in Computer Science, Business, Engineering, or a related field.
• 5+ years of experience in Business Intelligence, Project Controls, Data Analytics, or Analytics Engineering.
• Stakeholder Management: Proven track record of managing "hard" client relationships, navigating pushback, and driving consensus across technical and non-technical teams.
• Power BI Mastery: Advanced proficiency in Power BI, including DAX, data modeling, and UI/UX design principles for executive reporting.
• Domain Knowledge: Understanding of capital project controls, scheduling, or construction management
• Snowflake & SQL: Strong SQL skills with the ability to query, transform, and model data within Snowflake. You must understand how to prepare data for optimal BI performance.
• Data Translation: Experience taking raw data from disparate systems (CSV, Excel, JSON) and turning it into a cohesive business story (Star schema, dimensional modeling).
• Agile Collaboration: Comfort working with JIRA, Git, and agile methodologies.

BONUS POINTS IF YOU HAVE:

• Technical Depth: Familiarity with Python, dbt, or Azure Data Factory for advanced ETL scenarios
• Certifications: SnowPro Core, Microsoft Power BI Data Analyst Associate (PL-300), and PMP/CSM
• Ability to arrange priorities and elevate competing risks to meet deadlines
• Keen eye for detail and adept problem-solving abilities
• Must have demonstrated experience relaying and receiving information (written and verbal)
• Effective skills in Microsoft Office
• Equipped to work independently and as part of a team

Compensation at Accenture varies depending on a wide array of factors, which may include but are not limited to the specific office location, role, skill set, and level of experience. As required by local law, Accenture provides a reasonable range of compensation, based on full-time employment, for roles that may be hired as set forth below.

The recruiting efforts for this position are intended to fill an existing position.

The base pay range shown below is intended as a guideline to reflect the majority of offers for this role. It does not represent a maximum limit — in some cases, actual compensation may exceed the range where appropriate.