Senior Consultant, Client Data

As an employee-owned company, DMA prioritizes employees. Low turnover rates and tenured teams are living proof:

• 2025 Great Places to Work Certified
• Employee stock ownership program eligibility begins day one of employment. ESOP contribution is targeted at 6% of your annual compensation.
• Generous time off plans.
• Leadership team invested in the development, success, and happiness of our employees.
• "Live and work like a DMA Employee-Owner": We focus on work/life balance, mental health, and the overall wellness of our employees.

Position Summary
The Senior Client Data Consultant is a specialized professional responsible for leveraging data to support the tax consultants with reviews and reporting activities within the organization. This role requires intermediate level Data Processing skills, understanding of accounting and tax regulations, and the ability to interpret complex financial data to optimize tax analysis and reviews.

Essential Duties And Responsibilities

• Analyze large volumes of financial and operational data to identify tax risks, opportunities, anomalies, and gaps.
• Using MS SQL Server Management Studio to validate and process and export data.
• Using Microsoft Azure Data Studio to develop ETL pipelines and queries to transform and manipulate data.
• Perform Data Validation checks using MS Excel.
• Perform Data Mapping.
• Develop and produce standard and ad hoc reports using Microsoft Excel and other visualization tools.
• Able to use text editors and other tools to manipulate and convert large volumes of data. Eg converting PDFs to table format, using OCR, etc.
• Collaborate with tax and data teams to streamline data flows and improve the accuracy of data.
• Be familiar with the Canadian Jurisdiction Tax laws.
• Perform Data Reconciliation.
• Support initiatives by modeling scenarios and forecasting tax impacts using advanced data analytics tools and AI.
• Be able to automate repetitive activities and processes as needed by the tax team.
• Provide technical guidance and mentorship to junior analysts and other team members.
• Perform other duties as assigned.

Education And Qualifications

• Bachelor's degree in IT.
• Minimum 5 years of experience in database management, data warehousing; and data processing using structured querying language.
• Strong ETL development skills using Microsoft products.
• Advanced Excel skills, including the ability to work with complex formulas, pivot tables, and data models.
• Intermediate level accounting principles or 3-5 years' experience in an accounting environment.
• Experience with Canadian Indirect Tax
• Proficiency with data analytics tools (e.g., SQL, Python, Power BI, Tableau) and tax software platforms.
• Critical analytical, problem-solving, and organizational skills.
• Strong communication and interpersonal skills, with the ability to explain complex data and tax concepts to non-technical stakeholders.
• Strong attention to detail and ability to manage multiple priorities in a fast-paced environment.

Work Environment & Physical Requirements

• Work Schedule: Regular, 40 hours/week
• Travel: Less than 10%

• Physical Activity:

• Prolonged periods of sitting and computer use

• Ability to hear, understand, and distinguish speech and sounds
• Frequent repetitive motions with hands

The Company is an equal employment opportunity employer and is committed to providing equal employment opportunities to its applicants and employees. The Company does not discriminate in employment opportunities or practices on the basis of race, color, religion, gender, national origin, citizenship, age, disability, veteran status, genetic information, or any other category covered by federal, provincial, or local law. This equal employment opportunity policy applies to all employment policies, procedures, and practices, including but not limited to hiring, promotion, compensation, training, benefits, work assignments, discipline, termination, and all other terms and conditions of employment.

In accordance with the Accessibility for Ontarians with Disabilities Act (AODA) and other applicable provisional regulations, DMA will provide accommodation, accessible formats, and communication support for the interview upon request. If you have a disability and either need assistance applying online or need to request an accommodation during any part of the application process, please contact our Human Resources team at or and choosing selection 6.