Infrastructure & Capital Projects - Data & Analytics Consultant, COM

Accenture; Toronto; On-site; CAD 110,000 - 150,000; Full time

Job summary

Accenture in Toronto is seeking an Infrastructure & Capital Projects – Data & Analytics Consultant to bridge client teams with our data specialists. You will design and deliver executive Power BI dashboards, build robust data models in Snowflake, and translate business questions into technical specifications.

The role requires 5+ years in BI/analytics, strong SQL skills, and familiarity with Agile practices. Hybrid onsite work with travel to client sites is expected.

Qualifications

• Bachelor’s degree in Computer Science, Engineering, or related field.
• 5+ years in BI, project controls, or analytics engineering.
• Proven stakeholder management and client relationship skills.
• Advanced Power BI proficiency with DAX and data modeling.
• Experience with Snowflake and SQL for data preparation.
• Familiarity with Agile workflows (JIRA, Git).
• PM certification (CAPM, PMP, etc.) preferred.

Responsibilities

• Bridge client business teams and data teams to define KPIs.
• Lead requirements workshops to translate needs into data specs.
• Design and develop executive dashboards in Power BI.
• Model data in Snowflake and write complex SQL transformations.
• Ensure data quality by tracing dashboard numbers to source.
• Monitor CI/CD pipelines and troubleshoot data ingestion issues.

Skills

Power BI (DAX)

Stakeholder Management

SQL

Snowflake

Data Analytics

Project Controls

Agile Methodologies

Education

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

Tools

Power BI

Snowflake

SQL

GitHub

JIRA

Python (basic)

dbt

Azure Data Factory

Job description

Infrastructure & Capital Projects – Data & Analytics Consultant, COM

• (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.

• 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.
• Holding recognized Project Management certification (CAPM, PMP, etc.).

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.

Toronto

Equal Employment Opportunity Statement

All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law.

Job candidates will not be obligated to disclose sealed or expunged records of conviction or arrest as part of the hiring process.

Accenture is committed to providing veteran employment opportunities to our service men and women.