Tax Data Analyst

Mott MacDonald Group; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Benefits offered by this job

Agile working

Critical illness leave

Paternity leave

Group term life insurance

Group medical insurance

Career mobility

Global employment opportunities

Knowledge sharing

Job summary

Mott MacDonald is seeking a Tax Technologist to join the Tax Centre of Excellence in Bengaluru to build automation solutions for the tax team. The role focuses on Alteryx, Power BI, and Advanced Excel, with strong emphasis on data pipelines and dashboards.

Ideal candidates have 4-6 years of experience in Alteryx, VBA, and advanced Excel, with Power BI dashboard development and SQL understanding. Flexible working options and global exposure are offered.

Qualifications

• 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.
• Understanding of one or more databases (SQL, MySQL, MongoDB, etc.).
• Experience developing VBA & Advanced Excel based automation solutions.

Responsibilities

• 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 nested formulas, pivot tables, lookup functions, Excel modeling, preparing reports and dashboards.
• Create, update, and optimize interactive dashboards and reports using Power BI with different data sources to visualize metrics and trends.
• Write complex queries with multiple joins to automate/manipulate data with Alteryx.
• Collaborate with other IT teams and stakeholders to ensure data accuracy and process efficiency.

Skills

Alteryx

Advanced Excel

Power BI

SQL

VBA

Education

BE/BTech in IT/CS or BCA or BSc with Analytics

Graduation/Post Graduation

Tools

Power BI

Alteryx

Excel

SQL

VBA

Job description

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

We are a team of over 20,000 experts working across the world in more than 50 countries.

We are proud to be part of an ever-changing global industry, delivering transformative work that’s defining our future. It’s our people who power that performance. As an employee‑owned business, we invest in creating a space for everyone to feel safe and valued and empowered with the right tools and support.

Whether you want to pursue excellence in your specialism or broaden your experience with flexible roles across our business, you’ll be connected to a community of global experts championing you to be your best. Join us and shape your story with Mott MacDonald, where everyone has the opportunity to be brilliant.

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.

Location(s): Bengaluru, KA, IN

Contract Type: Permanent

Work Pattern: Full Time

Market: Various

Discipline: Finance and accounting