Data Engineer

XL++; Mumbai; On-site; INR 1,200,000 - 1,800,000; Full time

Benefits offered by this job

Salary commensurate with experience

Opportunity to work with cutting-edge Excel automation technology

Professional growth and learning opportunities

Job summary

A leading Excel automation firm in Mumbai is seeking an experienced Advanced Excel Specialist to design and develop complex automation solutions. The successful candidate will leverage their deep expertise in Excel automation and work closely with the development team to enhance the firm's capabilities. Candidates with over 5 years of experience in advanced Excel development, including proficiency in VBA and Power Query, are encouraged to apply.

Qualifications

• Minimum 5 years of professional experience in advanced Excel development.
• Expert-level proficiency in Excel functions, formulas, and advanced features.
• Demonstrated expertise in Power Query (M language) for data transformation.
• Demonstrated Power Query (M language) expertise for data transformation.
• Advanced knowledge of Power Pivot and DAX for data modeling and analysis.

Responsibilities

• Design and develop complex Excel-based automation solutions using VBA and Macros.
• Build advanced data transformation workflows using Power Query.
• Provide technical expertise on Excel automation projects.
• Develop customized Excel templates and tools for business process automation.
• Troubleshoot and optimize existing Excel‑based systems for performance and reliability.
• Collaborate with the product team to enhance XL++ features and functionality.
• Provide technical expertise and best practices guidance on Excel automation projects.
• Document solutions and create user guides for complex Excel applications.

Skills

Advanced Excel automation

VBA programming

Power Query

Power Pivot

Problem-solving

Large datasets

Analytical

Independent work

Bachelors in CS/IT/Data Analytics

Education

Bachelor's degree in Computer Science

Tools

.NET Framework

SQL

Excel add-ins

Job description

Co-Founder at ZeTheta Algorithms Private Limited

Job: Advanced Excel Specialist

Company Description:

XLRater Consulting Private Limited specializes in Excel automation with our groundbreaking tool, XL++ (www.xlplusplus.com), launched recently. XL++ is a GUI‑driven tool that extends Excel capabilities to optimize outcome time, minimize user errors, and enhance reliability and accuracy with diverse source data types. Built on a robust .NET core architecture, XL++ works on all Excel versions and processes large datasets efficiently. It features customized add‑ons for data import, transformation, and visualization, as well as automation of business processes through pre‑configured templates and real‑time updates.

Role Description:

This is a full‑time position for an experienced Advanced Excel Specialist. The successful candidate will leverage their deep expertise in Excel automation to develop complex data processing solutions, create sophisticated macros and VBA scripts, and design advanced analytics using Power Query and Power Pivot. You will work closely with our development team to enhance XL++ capabilities and deliver high‑impact automation solutions for our clients.

Key Responsibilities

• Design and develop complex Excel‑based automation solutions using VBA and Macros
• Build advanced data transformation workflows using Power Query
• Create sophisticated data models and analytics using Power Pivot
• Develop customized Excel templates and tools for business process automation
• Troubleshoot and optimize existing Excel‑based systems for performance and reliability
• Collaborate with the product team to enhance XL++ features and functionality
• Provide technical expertise and best practices guidance on Excel automation projects
• Document solutions and create user guides for complex Excel applications

Required Qualifications

• Minimum 5 years of professional experience in advanced Excel development
• Expert‑level proficiency in Excel functions, formulas, and advanced features
• Strong hands‑on experience with VBA programming and macro development
• Demonstrated expertise in Power Query (M language) for data transformation
• Advanced knowledge of Power Pivot and DAX for data modeling and analysis
• Experience with large dataset processing and optimization techniques
• Strong analytical and problem‑solving skills
• Ability to work independently and manage multiple projects
• Bachelor's degree in Computer Science, Information Technology, Data Analytics, or related field

Preferred Qualifications

• Experience with .NET framework and integration with Excel
• Knowledge of SQL and database connectivity
• Familiarity with data visualization best practices
• Experience in developing commercial Excel add‑ins or tools
• Understanding of software development lifecycle and version control

What We Offer

• Salary commensurate with experience and expertise
• Opportunity to work with cutting‑edge Excel automation technology
• Collaborative and innovative work environment
• Professional growth and learning opportunities
• Chance to shape the future of Excel automation solutions

Employment Type: Full‑time, Experienced Professional

How to Apply: Interested candidates meeting the above qualifications should submit their resume along with examples of complex Excel projects with large data sets. Please include details of your most challenging Excel automation project and the impact it delivered.

Salary will be determined based on candidate's experience, skill set, and demonstrated expertise. XLRater Consulting is an equal opportunity employer.