Senior Data Consultant

Salary: $130,000 - 170,000 per year

Requirements:

• At least 6 years of experience in data-focused consulting, business analysis, or advisory roles, including at least 2 years in a senior or lead position
• Demonstrated client-facing delivery experience and ability to manage senior stakeholders
• Strong SQL skills, including querying, profiling, and validating data
• Solid knowledge of data modelling, data warehousing, and ETL/ELT patterns
• Experience creating BRDs, source-to-target mappings, data dictionaries, user stories, and process flows
• Strong understanding of the SDLC and Agile delivery, with tools such as Jira, Confluence, or Azure DevOps
• Excellent written, verbal, and presentation skills
• Bachelors degree required
• Preferred: consulting or professional services experience; familiarity with AWS, Azure, or GCP; exposure to BI and visualization tools; experience in data governance, data quality, or metadata management; Python or other scripting for data analysis; and experience supporting AI/ML or advanced analytics use cases

Responsibilities:

• Advise client executives, data owners, and product owners as a trusted partner
• Lead discovery workshops and stakeholder interviews to understand business drivers, decisions, and pain points
• Define problems, evaluate options, and present evidence-based recommendations to executive audiences
• Build agreement across competing priorities and align data definitions between business units
• Identify opportunities to expand our client impact and contribute to proposals and project scoping
• Translate business objectives into data requirements, including metrics, KPIs, business rules, and definitions
• Profile and analyse client source data to assess its structure, quality, gaps, and lineage
• Create data flow diagrams, source-to-target mappings, data dictionaries, and conceptual or logical data models
• Lead gap analyses and impact assessments for new data initiatives and system changes
• Work with data engineers, architects, analysts, and QA teams to design and validate data solutions
• Guide the design of data pipelines, integrations, reporting layers, and analytics products
• Manage requirements traceability, UAT, data validation, and reconciliation through go-live
• Contribute to engagement planning, estimation, and risk management
• Mentor junior consultants and analysts
• Help develop our data consulting methods, templates, and best practices

Technologies:

• AI
• AWS
• Azure
• Confluence
• DevOps
• ETL
• Flow
• GCP
• JIRA
• Python
• SQL
• Cloud

More:

We are Blackbook.ai, a growing Data, AI, Digital, and Automation consultancy, and our Toronto practice is seeking a Senior Data Consultant for client engagements across industries such as Energy and Agriculture. This client-facing advisory role involves working with client leadership to turn complex business challenges into practical, data-driven outcomes, while using AI assistants to accelerate insights, data designs, prototypes, and recommendations. We offer a fast-paced, collaborative environment with varied client work alongside experienced consultants, on-the-job training, development opportunities, access to multiple certifications, and a competitive remuneration package. The role is full-time, hybrid remote in Toronto, Ontario, with annual pay of $130,000–$170,000. Benefits include casual dress, company events, paid time off, tuition reimbursement, a wellness program, and work-from-home arrangements. Our application asks candidates about salary expectations and whether they will require employment visa sponsorship.

last updated 41 week of 2026