Data Developer (SQL/VBA) in Mumbai, India is listed on Jobeax. Browse 30,000+ vacancies available.
Job: Advanced Excel Specialist
XLRater Consulting Private Limited specializes in Excel automation with our groundbreaking tool, XL++ ( 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. 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.
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. 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
Provide technical expertise and best practices guidance on Excel automation projects
Document solutions and create user guides for complex Excel applications
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
Ability to work independently and manage multiple projects
Bachelor's degree in Computer Science, Information Technology, Data Analytics, or related field
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
Excellent compensation package
Salary commensurate with experience and expertise
Opportunity to work with cutting-edge Excel automation technology
Professional growth and learning opportunities
Chance to shape the future of Excel automation solutions
Employment Type: Full-time, Experienced Professional
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.