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

Job Title: Process Transformation & Automation AnalystJob Location: PuneWork Model: Work from HomeBusiness Domain: Process Transformation / Automation / Finance / InsuranceCandidate ExpectationsTotal Experience And Relevant ExperienceHands-on experience in Power BI, Advanced Excel, VBA/Macros, and process automation development.Experience in process transformation, automation initiatives, and continuous improvement projects.Skills – MandatoryPower 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 IndustryPreferred: 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 CertificationQualificationMandatory: 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.CertificationGood to Have: Certifications in Power BI, RPA/Automation, Lean, Six Sigma, Kaizen, or Process Excellence.Detailed Job DescriptionRole 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 ResponsibilitiesProcess Automation and DevelopmentIdentify, 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 AnalyticsDevelop, 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 ImprovementParticipate 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 SupportSupport 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 DocumentationWork 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 SkillsTechnical SkillsPower 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