2 Excel Macro Jobs

At PwC, our people in managed services focus on a variety of outsourced solutions and support clients across numerous functions. These individuals help organisations streamline their operations, reduce costs, and improve efficiency by managing key processes and functions on their behalf. They are skilled in project management, technology, and process optimization to deliver high-quality services to clients. Those in managed service management and strategy at PwC will focus on transitioning and running services, along with managing delivery teams, programmes, commercials, performance and delivery risk. Your work will involve the process of continuous improvement and optimizing the managed services process, tools, and services. You are a reliable, contributing member of a team. In our fast-paced environment, you are expected to adapt, take ownership, and consistently deliver quality work that drives value for our clients and success as a team. As a Specialist, you'll work as part of a team of problem solvers, helping to solve complex business issues from strategy to execution by using Data, Analytics & Insights Skills. PwC Professional skills and responsibilities for this management level include but are not limited to: - Use feedback and reflection to develop self-awareness, personal strengths, and address development areas. - Flexible to work in stretch opportunities/assignments. - Demonstrate critical thinking and the ability to bring order to unstructured problems. - Ticket Quality and deliverables review, Status Reporting for the project. - Adherence to SLAs, experience in incident management, change management, and problem management. - Review your work and that of others for quality, accuracy, and relevance. - Know how and when to use tools available for a given situation and can explain the reasons for this choice. - Seek and embrace opportunities which give exposure to different situations, environments, and perspectives. - Use straightforward communication, in a structured way, when influencing and connecting with others. - Able to read situations and modify behavior to build quality relationships. - Uphold the firm's code of ethics and business conduct. - Demonstrate leadership capabilities by working with clients directly and leading the engagement. - Work in a team environment that includes client interactions, workstream management, and cross-team collaboration. - Good Team player. Take up cross competency work and contribute to COE activities. - Escalation/Risk management. Position Requirements: Required Skills: - Primary Skill: Tableau, Visualization, Excel - Secondary Skill: Power BI, Cognos, Qlik, SQL, Python, Advance Excel, Excel Macro BI Engineer: - Should have a minimum of 1 year hand-on experience building advanced Data Analytics. - Should have a minimum of 1 year hands-on Experience of delivering Managed Data and Analytics programs (Managed services and Managed assets). - Should have extensive experience in developing scalable, repeatable, and secure data structures and pipelines to ingest, store, collect, standardize, and integrate data for downstream consumption like Business Intelligence systems, Analytics modeling, Data scientists, etc. - Should have experience in building efficient Data analytics by using leading industry tools like Python, SQL, Spark, etc. - Should have experience in Building and maintaining Data Governance solutions (Data Quality, Metadata management, Lineage, Master Data Management, and Data security) using industry-leading tools. - Should have good knowledge of Data consumption patterns and BI tools like Tableau, Qlik sense, Power BI, etc. - Should have Strong communication, problem-solving, quantitative, and analytical abilities. Nice to have: - Certifications in Tableau and other BI tools are an added advantage. - Certification in any cloud platform. Educational Qualification: Bachelor's degree in computer science/IT or a relevant field. Work Location: Bangalore, India.,

Reporting to : - Manager - Automation Main Objectives of this position : - To design, develop, and implement intelligent automation solutions using VBA and Blue Prism, enhancing operational efficiency and accuracy across business processes. This role aims to leverage strong programming skills to deliver scalable, maintainable, and high-quality automation systems that support continuous improvement within the organization. Function and duties : - Main Tasks : - Analyze business processes to identify automation opportunities. Design and develop Automation solutions using Blue Prism and VBA Participate in the full software development life cycle, including requirements gathering, design, development, testing, and implementationReview artifacts that are subject to quality checks e.g.PDDs, SDDs, Robot code etc. Advise on and, if needed, review other documentation: complexity scoring and value assessment, UAT test strategy, Go-Live Document, Operations Handbook, Process Handover Document Advise internal team on the overall Macro / RPA best practices, Participating in solution design against business requirements. Analyse business requirements for developing functional and non-functional system requirements. Performing Proof of Concepts for feasibility analysis for the proposed automated solution. Working with the Business Process Teams during the UAT and roll-out Ability to provide quick resolution for issues after go-live Develop upgrades for existing applications Taking accountability of automation projects Drive efficiencies through completed projects Qualification and technical job requirements : - BE/B-tech, Bachelor's degree in CS, IT etc. Knowledge of Software Development Life Cycle (SDLC) Excellent working knowledge in Microsoft office tools specifically Outlook, Excel Macro, MS Access, and other general office applications. Excellent communication skills. Stakeholder Management skills. Create reports and dashboards for analysis. Technical Skills : - VBA Development: Proficiency in Visual Basic for Applications (VBA) programming language to create macros, automate tasks, and develop custom solutions within Microsoft Office applications (Excel, Word, Access, etc.). Blue Prism Automation: In-depth knowledge of the Blue Prism platform, its components, and methodologies to design, develop, and deploy robotic process automation (RPA) solutions. Process Automation: Strong understanding of business processes and the ability to analyze, optimize, and automate them using VBA and Blue Prism, identifying areas for improvement and efficiency gains. Programming Languages: good to have programming skills, not limited to VBA, but also including knowledge of other languages like C#, Python, or Java, depending on the requirements of the automation projects. Testing and Debugging: Proficiency in testing and debugging VBA macros and Blue Prism processes to ensure quality and reliability of the automation solutions. Process Documentation: Skill in documenting VBA scripts and Blue Prism processes comprehensively, including process flowcharts, logic, and configurations. Behavioral Skills : - Problem-Solving: Excellent problem-solving skills to identify automation opportunities, troubleshoot issues, and implement effective solutions in both VBA and Blue Prism environments. Communication: Strong communication skills to collaborate with business stakeholders, gather requirements, and effectively convey technical concepts to non-technical team members. Continuous Learning: Being proactive in keeping up-to-date with the latest developments in VBA, Blue Prism, and the broader RPA industry to incorporate best practices and emerging technologies into automation projects. Job Requirements: Strong technical skills in VBA with the ability to understand business requirements and automate processes effectively Excellent communication skills for stakeholder management Proven stability and consistency in past work experience