Power BI Automation - analyst - GO/JC/4910/2026

Golden Opportunities
Pune Division, Maharashtra, India

Job Title: Process Transformation & Automation Analyst

Job Location: Pune

Work Model: Work from Home

Business Domain: Process Transformation / Automation / Finance / Insurance

Candidate Expectations

Total Experience And Relevant Experience

Hands-on experience in Power BI, Advanced Excel, VBA/Macros, and process automation development.

Experience in process transformation, automation initiatives, and continuous improvement projects.

Skills – Mandatory

Power BI and dashboard/report development, Advanced Excel, VBA, and Macros, Automation development, coding, and process optimization, Exposure to RPA/Bot implementations and automation tools, Process Transformation and Continuous Improvement.

Candidate Industry

Preferred: Insurance, Finance, BPO, KPO, GBS, GCC, GSS, or Captive Shared Services.

Candidates with experience supporting Finance or Insurance operations/projects will be preferred.

Education and Certification

Qualification

Mandatory: Graduation in a relevant discipline, subject to client requirements.

Good to Have: Degree in Computer Science, Information Technology, Engineering, Finance, Business Administration, or a related field.

Certification

Good to Have: Certifications in Power BI, RPA/Automation, Lean, Six Sigma, Kaizen, or Process Excellence.

Detailed Job Description

Role Overview:

The role focuses on process transformation, automation development, reporting, and continuous improvement, with an emphasis on leveraging technology to improve operational efficiency, reduce manual effort, and enhance process effectiveness. The candidate should have strong hands-on expertise in Power BI, Advanced Excel, VBA/Macros, and automation tools, along with exposure to RPA/Bot implementations and AI-enabled solutions.

Key Responsibilities

Process Automation and Development

Identify, assess, and implement opportunities to automate repetitive and manual business processes.

Develop and maintain automation solutions using VBA, Excel Macros, scripting, coding, and relevant automation tools.

Support RPA/Bot implementation initiatives and contribute to automation design, testing, deployment, and maintenance.

Analyze existing workflows to identify bottlenecks and opportunities for process simplification.

Reporting and Data Analytics

Develop, maintain, and enhance Power BI dashboards, reports, and performance trackers.

Use Advanced Excel, formulas, pivot tables, data modeling, and VBA/Macros to automate reporting activities.

Analyze operational data to identify trends, process inefficiencies, and improvement opportunities.

Ensure data accuracy, reporting consistency, and timely delivery of business insights.

Process Transformation and Continuous Improvement

Participate in process transformation initiatives aimed at improving productivity, quality, and operational efficiency.

Evaluate opportunities to implement AI-enabled solutions and other technology-driven improvements.

Support SAP-related implementations and integration of relevant business systems.

Apply Lean, Six Sigma, Kaizen, and other continuous improvement principles to optimize workflows.

Track the effectiveness of implemented solutions through measurable outcomes, such as reduced processing time, improved accuracy, and cost savings.

Finance and Insurance Operations Support

Support transformation and automation projects within Finance and/or Insurance operations.

Understand business workflows, operational requirements, and process-specific challenges.

Collaborate with business stakeholders and technology teams to translate operational requirements into practical automation solutions.

Ensure solutions align with business objectives, process controls, and operational requirements.

Stakeholder Management and Documentation

Work with business users, operations teams, technology teams, and project stakeholders to understand requirements.

Document existing and proposed processes, automation requirements, test scenarios, and implementation outcomes.

Support user acceptance testing, issue resolution, and post-implementation monitoring.

Track project progress and communicate risks, dependencies, and improvement outcomes to relevant stakeholders.

Key Skills

Technical Skills

Power BI, Advanced Microsoft Excel, VBA Programming, Excel Macros, Automation Development, Coding and Scripting, Dashboard and Report Development, Data Analysis and Visualization, Data Manipulation and Validation, Reporting Automation, RPA Tools and Bot Implementations

Score my resume against this job, free →

Questions about this job

How do I apply for the Power BI Automation - analyst - GO/JC/4910/2026 job at Golden Opportunities?

Use the apply link on this page: you apply directly with Golden Opportunities on LinkedIn. Before you do, score your resume against this job description on Fitboard. It shows which skills and keywords the job asks for that your resume doesn't show, so you can fix them first.

How can I get a job at Golden Opportunities?

Apply to the Golden Opportunities roles that match your experience, and tailor your resume to each job description. A resume that matches the job's own keywords is more likely to get past screening. Fitboard scores your resume against this exact job for free.

Is this Power BI Automation - analyst - GO/JC/4910/2026 job remote or onsite?

This is based in Pune Division, Maharashtra.

Is it free to apply? Does Fitboard charge anything?

Applying is free: you apply directly with Golden Opportunities, and this job page and its apply link cost nothing. Checking your resume against this job is free too, with 3 free scans when you sign in and no credit card needed.

Will you get shortlisted for this role? Check your match free →