Tax Data Analyst

Mott MacDonald; Bengaluru; On-site; INR 1,500,000 - 2,100,000; Full time

Benefits offered by this job

Agile working

Group medical insurance

Paternity Leave

Career mobility options

Short and Long-term global employment

Job summary

Mott MacDonald is seeking a Tax Technologist for the Tax Centre of Excellence in Powai, Mumbai. You will build automation solutions, data pipelines, and dashboards using Alteryx, Power BI, and advanced Excel.

Collaborate with IT and business stakeholders to ensure data accuracy and process efficiency while advancing your career in tax technology within a fast-growing global consultancy.

Qualifications

• 4-6 years of professional experience with Alteryx, VBA and advanced Excel.
• Proficiency in creating Alteryx apps and gallery workflows.
• Experience in Power BI dashboards development and data visualization.

Responsibilities

• Design, develop, and maintain data pipelines using Alteryx.
• Excel mastery: nested formulas, pivot tables, lookups and modeling for reports and dashboards.
• Create, update, and optimize Power BI dashboards from multiple data sources.

Skills

Advanced Excel

Data analysis

Dashboarding

Education

BE/BTech IT/CS

BCA

BSc CS

Tools

Alteryx

Power BI

SQL

VBA

MySQL

MongoDB

Job description

Mott MacDonald is a global engineering, management, and development consultancy committed to delivering impactful work that shapes the future.

Job Description

The individual will be a part of the Tax Centre of Excellence (CoE) based in Powai, Mumbai and report to the Head of Tax Compliance and Reporting. They would need to build automation solutions for the tax team.
We are looking for professionals with experience on Alteryx and Power BI to join the Tax C&R team and build a strong career in this fast-growing field.

• Primary skills – Alteryx, Advanced Excel & Power BI
• Secondary skills – SQL / VBA
• The candidate will build tax automation solutions and applications for the group tax team to automate complex processes in direct and indirect taxes.

Duties and Responsibilities of Tax Technologist

• Design, develop, and maintain data pipelines using Alteryx to extract, transform and load data from ERP and various sources.
• Must be advanced in Microsoft Excel, including but not limited to nested formulas, pivot tables, lookup functions, excel modeling, preparing report and dashboards
• Create, update, and optimize interactive dashboards and reports using PowerBI with different data sources to visualize and communicate key metrics and trends.
• Able to write complex queries with multiple joins to automate/manipulate data with Alteryx.
• Will have to work in partnership with the other IT teams and stakeholders concerning the accuracy of data and efficiency of processes.

Candidate Specification

• 4-6 years of professional experience in Alteryx, VBA & advanced excel
• Proficiency in creating Alteryx apps and gallery-oriented workflows.
• Must have working experience with PowerBI dashboards development
• Preferred to have an understanding of one or more databases (SQL, MySQL, Mongo DB, etc.)
• Experience of developing VBA & Advance excel based automation solutions.
• Must have working experience of write complex excel VBA code.
• Ability to work independently and collaboratively in a fast-paced environment.
• Ability to research and troubleshoot technical problems
• Certification in Alteryx and Power BI will be a plus.
• A degree in commerce background is preferred.
• In-house experience an advantage
• Strong project management, organizational and communication skills

To qualify for the role, you must have (certification & Experience)

BE/BTech degree in IT/Computer Science or BCA or BSc degree in Computer Science or any graduation degree with Analytics Course Certifications
Qualifications
Graduation / Post Graduation

Flexible working

At Mott MacDonald, we support our staff to create work-life balance which works for them and welcome candidates looking for career flexibility. We are open to discussing flexible working at interview stage.

Our benefits package is designed to enhance your experience

• Agile working
• Critical illness and compassionate leave
• Paternity Leave
• Group term life insurance, and Group medical insurance coverage
• Career mobility options
• Short and Long-term global employment opportunities
• Global collaboration and knowledge sharing

Employment Compliance Requirement

As part of our global compliance requirements, all candidates must hold a valid Right to Work (RTW) document in India, which will be verified during the recruitment process.
Acceptable documents include a Passport, Voter ID, or Birth Certificate.
By applying, you confirm that you can provide valid documentation if and when required.