9+ VLOOKUP Jobs in India

Tariff Analyst

Experience: 2-6 Years 

Location: Pune

Type: Full-time

About Digit88

Digit88 empowers digital transformation for innovative and high growth B2B and B2C SaaS companies as their trusted offshore software product engineering partner!

We are a lean mid-stage software company, with a team of 75+ fantastic technologists, backed by executives with deep understanding of and extensive experience in consumer and enterprise product development across large corporations and startups. We build highly efficient and effective engineering teams that solve real and complex problems for our partners.

With more than 50+ years of collective experience in areas ranging from B2B and B2C SaaS, web and mobile apps, e-commerce platforms and solutions, custom enterprise SaaS platforms and domains spread across Conversational AI, Chatbots, IoT, Health-tech, ESG/Energy Analytics, Data Engineering, the founding team thrives in a fast paced and challenging environment that allows us to showcase our best.

The Vision: To be the most trusted technology partner to innovative software product companies world-wide

The Opportunity

Digit88 is expanding the extended software product engineering team for its partner, a US-based Energy Analytics SaaS platform company. Our partner is building a suite of cloud-based business operation support platforms in the Utilities Rate Lifecycle space in the Energy sector/domain. This is a bleeding edge AI and Big Data platform that helps large energy utility companies in the US plan, manage, review and optimize their new product and rate design, billing, rate analysis, forecasting, and CRM. The candidate would be joining an existing team of product engineers in the US, China and Pune/India and help us establish an extended product engineering team at Digit88.

Job Profile

Digit88 is looking for a hands-on Data Analyst with expertise in advanced Excel and experience in SQL. They must be detail-focused, and have excellent problem solving skills, and quickly learn new tools & knowledge.

The role requires a knowledge of database concepts and provides an opportunity to drive positive energy consumption habits and catalyze a clean energy future. You must enjoy learning and building rapidly evolving products/platforms.

To be successful in this role, you should possess

• Overall Industry experience 2-4 years
• Bachelor’s Degree in analytical subject area. E.g., Engineering, Statistics.... etc.
• Proficient in advanced Excel functions and macros, involving complex calculations and pivots
• Exceptional Analytical, problem solving & Logical skills.
• Understanding of relational database concepts and familiar with SQL
• Demonstrable aptitude for Innovation & Problem solving.
• Good communication skills & ability to work across Cross-functional teams.
• Understands complex utility tariffs, rates and programs and converts these into a model.
• Participates in sprint planning & other ceremonies, passionately works towards fulfilling the committed sprint goals.
• Knowledge of and ability to automate routine tasks using Python is a PLUS

Preferred Qualifications:

• Experience in Energy Industry & familiar with basic concepts of Utility (electrical/gas...) tariffs
• Experience & Knowledge with tools like; Microsoft Excel macros, 
• Familiarity with writing programs using Python or Shell scripts.
• Passionate about working with data and data analyses.
• 1+ year experience in Agile methodology.

Roles and responsibilities

• Understands complex utility tariffs, rates and programs and converts these into a model.
• Responsible for analysis of the energy utilization data for cost and usage patterns and derive meaningful patterns
• Responsible for Maintaining the tariff models with timely updates for price, logic or other enhancements as per client requirement.
• Assist delivery team in validating the input data received from client for modelling work.
• Responsible for Communicating & Co-ordinating with Delivery team
• Work with Cross functional teams to resolve issues in the Modelling tool.
• Build and deliver compelling demonstrations/visualizations of products
• Be a lifelong learner and develop your skills continuously
• Contribute to the success of a rapidly growing and evolving organization

Additional Project/Soft Skills:

• Should be able to work independently with India & US based team members.
• Strong verbal and written communication with ability to articulate problems and solutions over phone and emails.
• Strong sense of urgency, with a passion for accuracy and timeliness.
• Ability to work calmly in high pressure situations and manage multiple projects/tasks.
• Ability to work independently and possess superior skills in issue resolution.

Benefits/Culture @ Digit88:

• Comprehensive Insurance (Life, Health, Accident)
• Flexible Work Model
• Accelerated learning & non-linear growth
• Flat organization structure driven by ownership and accountability.
• Global Peers - Working with some of the best engineers/professionals globally from the likes of Apple, Amazon, IBM Research, Adobe and other innovative product companies
• Ability to make a global impact with your work, leading innovations in Conversational AI, Tele-Medicine, Healthcare and more.

You will work with a founding team of serial entrepreneurs with multiple successful exits to their credit. The learning will be immense just as will the challenges.

This is the right time to join us and partner in our growth!

As a Back Office Executive, your primary responsibility is to gather, analyze, and interpret data to provide actionable insights that support decision-making processes within the organization. You will work closely with various teams to understand their research needs, contribute to strategic planning, and help enhance overall business performance.

Qualifications

1. Bachelor's or Master's degree.
2. Strong knowledge of Microsoft Office tools i.e. Microsoft Excel and Microsoft Word.
3. Excellent communication skills, both written and verbal.
4. Good knowledge of Google Spreadsheets, shortcut keys, and formulas.
5. Ability to work collaboratively in a team environment.
6. Prompt in web search.

We strongly prefer local candidates for this position as it is based in Ujjain.

Who We Are:

Founded in 2018, HighLevel Inc. (www.gohighlevel.com) is a two tier B2B SaaS Platform focused on Marketing Agencies. We aspire to be a one stop shop for marketing agencies. We enable agencies to serve their clients with ease using the best cutting edge tools of the industry. Our clientele includes digital marketing agencies, Ads agencies, SEO agencies, Call center / Sales agencies and freelancers. We operate across niches like real-estate, dental & medical, local businesses, e-commerce, professional services and field services. 

Our platform comprises various product areas including CRM, funnel builder, website builder, forms & surveys, WordPress hosting, email marketing, telephony, reviews management, omni-box communications, social media, invoicing & payments to name a few. We currently service over 20,000 agencies and 220,000 small & medium businesses with a 600+ strong team that works entirely remote across 15 nations. 

Who You Are: 

We are seeking a talented and experienced Business Analyst with a deep expertise in utilizing Google Sheets to extract insights, optimize processes, and facilitate data-driven decision-making.

As a Senior Business Analyst specializing in Google Sheets, you will play a pivotal role in driving the success of our products by leveraging your advanced analytical skills and in-depth knowledge of Google Sheets functionalities. You will collaborate closely with cross-functional teams to gather, analyze, and interpret data, translating it into actionable insights that inform strategic decisions and enhance our product offerings.

What You Will Do: 

• Google Sheets Expertise: Serve as the go-to expert in Google Sheets, showcasing proficiency in advanced functions, data manipulation, visualization, and automation to enhance reporting and analysis capabilities.
• Reporting and Dashboards: Develop and maintain dynamic reports, interactive dashboards, and KPI tracking mechanisms using Google Sheets. Ensure that key stakeholders have access to real-time insights that drive actionable outcomes.
• Data Analysis: Collect, interpret, and analyze complex data sets to identify trends, patterns, and opportunities. Present findings to stakeholders in a clear and concise manner that supports data-driven decision-making.
• Process Optimization: Collaborate with teams across the organization to identify inefficiencies and areas for improvement in existing processes. Utilize Google Sheets to design and implement streamlined workflows, automations, and data validation mechanisms.
• Strategic Insights: Provide strategic recommendations based on data analysis to support business growth, enhance customer experiences, and optimize product offerings.
• Cross-functional Collaboration: Partner with Customer Success, Product Managers, Marketing, and Sales, teams to understand their data needs, align on objectives, and deliver valuable insights to support their initiatives.
• Data Integrity and Governance: Maintain data accuracy, consistency, and security within Google Sheets documents. Establish best practices for data organization, naming conventions, and version control.

What You Bring: 

• Bachelor's degree in Business Administration, Economics, Statistics, Computer Science, or a related field. Master's degree is a plus.
• Proven experience (5+ years) as a Business Analyst, Data Analyst, or similar role within a SaaS environment.
• Exceptional proficiency in Google Sheets, including advanced functions (e.g., VLOOKUP, PivotTables, array formulas), data visualization, and scripting (Google Apps Script).
• Strong analytical thinking and problem-solving skills, with the ability to translate data into actionable insights.
• Experience in process optimization and automation using Google Sheets.
• Excellent communication and presentation skills, with the ability to convey complex findings to both technical and non-technical stakeholders.
• Solid project management skills with the ability to handle multiple tasks and priorities simultaneously.
• Familiarity with other data analysis and visualization tools (e.g., Excel, Tableau) is a plus.
• Experience in the SaaS industry is preferred but not required.
• Relevant certifications in data analysis, Google Workspace, or related fields are advantageous.

EEO Statement:

At HighLevel, we value diversity. In fact, we understand it makes our organization stronger. We are committed to inclusive hiring/promotion practices that evaluate skill sets, abilities and qualifications without regard to any characteristic unrelated to performing the job at the highest level. Our objective is to foster an environment where really talented employees from all walks of life can be their true and whole selves, cherished and welcomed for their differences, while providing awesome service to our clients and learning from one another along the way!

Prepare daily attendance for all site and mail to corporate office.

Prepare Daily Call Report for all site and mail to corporate office.

Engineer shift roster has to make based on call

MS Office Knowledge

Pivot Tabel

Vlook up

Female Only

Roles and Responsibilities-

1. Skilled on MS Excel

2. Knows Vlookup, Pivot Table, can run different formulas on MS Excel

3. To leverage technology solutions to meet the company's organizational needs.

4. Develop recommendations that optimize the use of technology within an

organization.

5. Designing and implementing functional and cost-efficient technology systems.

6. Skilled on different Inhouse applications/tools & on Google doc, sheet.

Qualification

1. Bachelors degree or the equivalent combination of education and experience.

2. Command of English.

3. Computer Science - IT Graduate / Postgraduate (BTech / BE / BCA / BSC /

MTech / ME / MCA / MSC). - Preferred

4. Immediate joinee candidate preferred.

• Location: Vatva GIDC
• Experience : 1yr to 2yr (Only Male)
• Education: B.com or M.com

Desired Candidate Profile