VBA Analyst Jobs in Bangalore - EPITAS SOFTWARE LLP
Job Description
- Usage of Logical, Aggregate, Text, Date & Time, Lookup, Reference, Database and Array functions.
- Summarization and creating tabular form report using PivotTable
- Usage of Custom Conditional Formatting, Name Manager, Custom Data Validation, etc.
- Visualization of data in graphical format by creating various type charts and Sparkline.
- Power Pivot
- Ability to bring data (from different sources) and create the relationship.
- Creating simple & complex measures using DAX
- Powerful features like slicers.
- Date & time intelligence thru Power Pivot
- Ability to bring data (from different sources) and combine using Merge and Append Queries with various Joins
- Usage of Parameters and Variables inside the Queries.
- Usage of features like “Invoke Custom Function”, Custom Column, Conditional Column, Group By, Pivot and Unpivot columns etc.
- Ability to modify the queries using Power Query Functions.
- Job Type: Contract
- Salary: ₹25,000.00 to ₹40,000.00 /month
Job Particulars
About Company
Passion is what defines us. Wondering passion for what? It’s for Robotics. We want to take this passion to the next level by taking it up as a business. Ours is a startup company which is at the blooming stage. As a first step, a robotics club has been set up. Robot enthusiasts are invited to join the club who can make the difference by bringing innovative ideas to build robots. At Epitas, we look at ourselves as a cutting-edge solution provider. Our team is highly skilled and passionate about what we do. There is a perfect blend of innovation and expertise in our team, which reflects the quality of work.
Our expertise is but not limited to Software Product Development, Automation, eCommerce, BFSI, IT Auditing, Risk Management, Manpower Planning, Training and Development. We work on cutting-edge technologies such as Python, Selenium, NodeJS, Cloud Computing, Internet-of-Things, Robotics, and Amazon Web Services. We also provide consultancy, tech-talk, and training in our area of expertise.
We believe in keeping ourselves updated with the current trends. Hence learning is an integral part of our job. So a lot of research is done in each and every field we work on.