13 Vba Scripting Jobs

Team Lead - Invoice & Data Analysis (US Telecom) Employment Type: Full-Time Location: Hyderabad (WFO) Role Description: The Team Lead will oversee and conduct data research and analysis, manage data, employ data science techniques, and ensure that data is handled effectively. The role involves leading a team, managing project timelines, and providing high-quality deliverables that align with client goals. Day-to-day tasks include analyzing datasets, reporting findings, and developing innovative solutions to complex problems. Job Responsibilities: Strong analytical skills with the ability to identify and resolve data discrepancies Excellent problem-solving and critical thinking skills Proficient in Microsoft Excel and other data analysis tools (e.g., Power BI, Tableau) Strong communication, interpersonal, and leadership skills Collaborate with clients, internal stakeholders, vendors, and other departments to resolve data issues Ability to manage and prioritize multiple tasks in a fast-paced environment Excellent attention to detail and accuracy Oversee team performance and ensure adherence to deadlines and quality standards Required Skills: Experience in the US Telecom Invoice processing and a good understanding of secondary research Excellent Communication skills. (Written & Verbal) Lead and manage a team of 5 to 10 data analysts focused on invoice reconciliation/any other data research process Develop and implement strategies for streamlining the invoice reconciliation process. Leverage data analysis tools and techniques to identify and investigate data discrepancies, and identify trends and opportunities for improvement Develop and implement quality control procedures for invoice reconciliation/any other data research process Prepare reports and presentations on key activities and findings Train and mentor team members on data analysis techniques and invoice reconciliation procedures MS Office - Word/ Excel, Power BI Medium to Advanced Level Qualifications: Graduate or Postgraduate in Commerce / Business Management/Equivalent 8 plus years in Data Research & Analysis, of which 2 to 3 years in team/people management

Senior Research Analyst (MIS) Experience: 3 - 5 Years Employment Type: Full-Time Location: Hyderabad (WFO) Role & responsibilities 1. Data Collection & Entry Gather, clean, and structure raw data from various sources Ensure data accuracy, completeness, and consistency Import/export data between Excel and other platforms (e.g., databases, ERP systems, CSV files) 2. Data Analysis & Interpretation Analyze datasets using Excel functions, formulas, and pivot tables Identify trends, patterns, and anomalies in the data Provide actionable insights to support business decisions 3. Advanced Excel Functionality Use advanced formulas (e.g., VLOOKUP, INDEX-MATCH, IF, SUMIFS) Create dynamic reports using PivotTables and Pivot Charts Automate tasks with macros and VBA scripting Design dashboards and interactive visual reports 4. Reporting & Visualization Generate regular and ad-hoc reports for management and stakeholders Develop visually appealing and easy-to-understand dashboards Present findings using charts, graphs, and conditional formatting 5. Data Integrity & Quality Control Perform data validation to prevent input errors Audit spreadsheets to ensure correct calculations and logic Maintain version control and secure sensitive data Technical Skills: Advanced MS Excel (PivotTables, formulas, Power Query, dashboards) Proficiency in Macros/VBA and working knowledge of SQL Familiarity with Power BI or similar BI tools Strong analytical and problem-solving skills; detail orientation a must Other Skills: Excellent communication and presentation skills Ability to handle multiple priorities in a fast-paced environment Strong team player with a process-improvement mindset

The Portfolio Management (PM) Team, a part of PB BLIS WM BL, is a newly established team that collaborates closely with Lenders/FO team for Subscription Finance product within the Mumbai, India location. As an Analyst in this team, you will be offered a variety of benefits such as a best-in-class leave policy, gender-neutral parental leaves, childcare assistance benefit, sponsorship for industry certifications, and comprehensive insurance coverage for you and your dependents. Additionally, you will have access to an Employee Assistance Program and other health benefits. Your key responsibilities will involve 1LoD risk management of the WM Lending portfolio, including financial statement analysis, credit structuring, covenant monitoring, collateral valuations, reporting, and facilitation of new lending transactions. You will work closely with bankers and FO staff to ensure client onboarding requirements are met and assist in the implementation of key team deliverables. To excel in this role, you should possess a postgraduate degree with analytical skills and a minimum of 3 years" experience in Private Bank/Wealth Management. Strong organizational skills, attention to detail, and proficiency in Microsoft Excel are essential. Excellent communication skills, the ability to work independently, and experience in global matrix organizations are preferred. You will receive training, coaching, and support to aid your career progression within a culture of continuous learning. Deutsche Bank Group values empowerment, responsibility, commercial thinking, and collaboration. They promote a positive, fair, and inclusive work environment, welcoming applications from all individuals. For more information about Deutsche Bank Group, please visit their company website at https://www.db.com/company/company.htm.,

As a Data Management Specialist, you will play a crucial role in supporting data processing operations by cleaning, restructuring, validating, and uploading data into our system. Your primary responsibility will be to ensure the accuracy and compliance of data with program rules. To excel in this role, you must possess advanced Excel skills to efficiently manipulate and organize data. Post-upload testing will also be a key aspect of your responsibilities to confirm data integrity and accuracy. Key Responsibilities: - Data Cleaning & Preparation: Identify and rectify inconsistencies, duplicates, and errors in datasets. Standardize and format raw data to meet system requirements. Maintain data consistency across various sources. - Data Reorganization & Formatting: Transform data structures to match the required platform format. Develop and modify Excel templates/macros for effective data processing. Utilize pivot tables, formulas, and automation techniques to streamline data organization. - Data Validation & Compliance: Validate datasets against predefined business rules and logic. Conduct checks to ensure data accuracy, completeness, and integrity. Collaborate with stakeholders to address discrepancies. - Data Upload & System Integration: Prepare and upload validated data into the platform. Resolve errors during upload and troubleshoot any issues. Document upload procedures and ensure adherence to system standards. - Post-Upload Testing & Quality Assurance: Verify data post-upload to ensure accuracy. Conduct sample tests to identify missing or incorrect entries. Generate reports highlighting anomalies or errors. - Process Improvement & Documentation: Identify opportunities to enhance data management workflows. Maintain records of data processing steps and update documentation. Train team members on data management best practices and Excel automation. Required Skills & Qualifications: - Proficiency in Microsoft Excel, including pivot tables, VLOOKUP, HLOOKUP, INDEX-MATCH, and nested formulas. - Familiarity with data cleaning techniques using functions like TEXT, CONCATENATE, TRIM, SUBSTITUTE, etc. - Experience in handling and processing large datasets. - Strong attention to detail and problem-solving abilities. - Ability to adhere to complex data validation rules. - Understanding of data structures and formatting principles. - Excellent organizational and documentation skills. - Capability to work independently and manage multiple tasks efficiently. Preferred Qualifications: - Bachelor's degree in data science, Information Systems, Business Analytics, or related field. - Experience with database tools or data management systems (optional). - Familiarity with Python or SQL for data manipulation (a plus but not required).,

Job Title: Data Management Specialist Job Summary: We are seeking a Data Management Specialist to support our data processing operations. The ideal candidate will be responsible for cleaning, restructuring, validating, and uploading data into our system while ensuring accuracy and compliance with program rules. This role requires advanced Excel skills to manipulate and organize data efficiently. The selected candidate will also be responsible for conducting post-upload testing to confirm data integrity and accuracy. Key Responsibilities: Data Cleaning & Preparation: Identify and correct inconsistencies, duplicates, and errors in datasets. Standardize and format raw data to match system requirements. Ensure data consistency across different sources. Data Reorganization & Formatting: Transform data structures to align with the platforms required format. Create and modify Excel templates/macros for efficient data processing. Use pivot tables, formulas, and automation techniques to organize data efficiently. Data Validation & Compliance: Validate datasets against predefined business rules and logic. Perform checks to ensure data accuracy, completeness, and integrity. Collaborate with stakeholders to resolve discrepancies. Data Upload & System Integration: Prepare and upload validated data into the platform. Address errors during upload and troubleshoot issues. Document upload procedures and ensure compliance with system standards. Post-Upload Testing & Quality Assurance: Conduct data verification after uploads to confirm accuracy. Perform sample tests to identify missing or incorrect entries. Generate reports to highlight any anomalies or errors. Process Improvement & Documentation: Identify opportunities for improving data management workflows. Maintain records of data processing steps and update documentation. Train team members on best practices in data management and Excel automation. Requirements Required Skills & Qualifications: Advanced proficiency in Microsoft Excel, including: Pivot tables, VLOOKUP, HLOOKUP, INDEX-MATCH, and nested formulas. Data cleaning techniques using functions like TEXT, CONCATENATE, TRIM, SUBSTITUTE, etc. Macros and VBA scripting (preferred but not mandatory). Experience in handling and processing large datasets. Strong attention to detail and problem-solving skills. Ability to follow complex data validation rules. Understanding of data structures and data formatting principles. Excellent organizational and documentation skills. Ability to work independently and manage multiple tasks efficiently. Preferred Qualifications: Bachelors degree in data science, Information Systems, Business Analytics, or related field. Experience working with database tools or data management systems (optional). Familiarity with Python or SQL for data manipulation (a plus but not required). Show more Show less

About ZEISS Group ZEISS is an internationally leading technology enterprise operating in the fields o f optics and optoelectronics. In the previous fiscal year, the ZEISS Group generated annual revenue totaling 10 billion euros in its four segments Semiconductor Manufacturing Technology, Industrial Quality & Research, Medical Technology and Consumer Markets. Job purpose : The Supply Chain Analyst will be at the forefront of transforming our supply chain operations, leveraging cutting-edge technologies and data-driven insights to drive efficiency, reduce costs, and enhance quality. In this pivotal role, you will harness advanced analytical tools, including artificial intelligence (AI) and machine learning (ML), to uncover trends, forecast demand, and support smarter decision-making. Were looking for a detail-oriented, forward-thinking professional with a deep understanding of supply chain processes and exceptional analytical skills. As a key collaborator, youll work across departments gather insights, solve complex problems, and recommend innovative strategies to optimize supply chain performance. Staying ahead of the latest advancements in supply chain analytics and technology will be essential to your success in this role. If youre passionate about using data to create meaningful impact and thrive in a dynamic, fast-paced environment, this is your opportunity to make a difference and shape the future of supply chain excellence. Main Accountabilities : Data Analysis & Reporting AI-Driven Insights Trend Monitoring Collaboration Process Optimization Skills & Knowledge requirement : Skills : Handling multiple projects & demanding timelines Result oriented mindset with project management skills Ability to identify and implement cutting-edge solutions to complex supply chain challenges. Well versed in implementing Automation, AI-driven solutions in a supply chain environment. Knowledge of emerging technologies like blockchain and IoT in supply chain processes. Technical Skills: Proficiency in data visualization tools (e.g., Tableau, Power BI). Strong knowledge of supply chain management software (e.g., SAP, Oracle). Advanced Excel skills and familiarity with SQL and ETL for data extraction, integration and analysis. Soft Skills: Strong analytical and problem-solving skills. Excellent communication and presentation abilities. A proactive mindset with a passion for innovation and continuous learning. Willingness to learn and adapt to rapidly evolving technologies and methodologies. Strong interpersonal skills to work effectively with internal and external stakeholders. Tools & Systems: Advanced MS Excel, Advance Excel Skills & macros. Good knowledge of SAP or any other ERP. Power BI development and administration. VBA Scripting (added advantage). Should be familiar and experienced in SQL. PMP Project Management skills. Hands on experience of analytics tools like QlikView, Tableau, R is a plus. Job Qualification: Education: Batchelor Degree with specialization in Data analytics / Supply chain Experience: 3+ Years in Supply Chain Planning/ Analytics/ Process improvement/ project delivery Certification in supply chain management (e.g., APICS, CSCP) six sigma or data analytics is an added advantage. Show more Show less

Job Description Summary HMI Engineer is responsible for the Development of the Next Generation HMI, work towards to complete the development successfully. Works with global stakeholders and 3rd party HMI vendors to come up with the best system solution for HMI. Job Description Roles and Responsibilities Developing, Deploying of SCADA system. Designing the hardware & software functional specification for the Project. Knowledge in Iconics and PCVue SCADA system & if knowledge is in iFIX, Cimplicity, Intouch SCADA will be added advantage. Work on HMI applications development to meet the customer needs and upcoming cyber requirements. Designing, implementing, and supporting industrial communication networks for control system applications. Supporting Engineering Services field personnel in the technical resolution of field problems. Providing assistance with quality assurance on projects Desired Characteristics Demonstrated experience working with industrial network communication protocols such as OPCUA/DA,IEC 61850, Modbus, TCP/IP, Profibus etc. Experience in configuring interface drivers such as Matrikon drivers will be added advantage. Network Architecture knowledge HMI Server Client Configuration, Redundant Server Configuration. Historian Knowledge, Configuring & knowledge of Alarm Management (Historical, SMS, Email, Voice). Report Generation Knowledge (Shift/Batch/Day) with Backend SQL & MS Access. Strong background in HMI application development for Iconics, PCVue products or any other HMI packages, experience in back-end scripting (VBA Scripting knowledge, C, C++ knowledge added advantage), interface with database such as SQL, MS Access etc. Demonstrated experience in the development and application of virtual machines in a Microsoft Windows operating environment is an added advantage. Strong computer skills: experience setting up Windows based applications such as Windows 10 and above proficiency in standard MS Office applications. Technical skills in HMI design engineering, commissioning experience is added advantage. Knowledge in web HMI. Proven team player with solid cooperation, flexibility and demonstrated capacity to learn complex information quickly. Field experience in related equipment. Good oral and written communication skills. Qualifications/Requirements Bachelors /Masters Degree in relevant engineering or equivalent knowledge / experience with 4+ Years of Experience Significant software development experience for HMI like Iconics, PCvue, Ifix, Cimplicity. Additional Information Relocation Assistance Provided: Yes Show more Show less

You should have at least 5-7 years of experience in data analysis, particularly in a supply chain or operations setting. Your proficiency in SQL and Python for data manipulation, automation, and analytics is a must. Experience with data transformation tools like Alteryx or similar ETL platforms is required, as well as hands-on experience with data visualization tools such as Power BI or Tableau. Proficiency in Excel, including advanced formulas and VBA scripting for automation, is also necessary. It would be beneficial if you are familiar with supply chain concepts like sourcing, inventory, transportation, and capacity planning. Previous experience working with large datasets from ERP systems like SAP and integrating data from various sources is highly valued. You should possess a strong analytical mindset with keen attention to detail and a passion for solving complex problems using data. Excellent communication skills are essential, with the ability to present insights clearly and effectively. Exposure to supply chain network modeling tools like Llamasoft or Optilogic would be an advantage. Experience with cloud-based data platforms such as Azure, AWS, or Fabric is also considered beneficial. Knowledge of data governance and master data management principles is a plus. Ideally, you should have a minimum of 7 years of overall experience in Supply Chain, Data Analysis, or a related field.,

JOB Title: Excel Specialist . Company: Bobton IT Solutions, Hyderabad. Location: Remote (UK Time Zone Alignment Required for International Logistics company) Type: Full-Time | Remote | Immediate Start Salary: Competitive (Based on Experience) + Full Training Provided. Role Purpose: We are looking for an Excel Specialist who is highly skilled in managing, analyzing, and interpreting data using Microsoft Excel. The ideal candidate should have extensive experience in creating complex spreadsheets, developing macros, and utilizing advanced Excel functions to streamline business processes and improve efficiency. Experience: 0-3 Years Key Responsibilities: Develop and maintain complex Excel spreadsheets and models for data analysis and reporting. Create and automate reports, dashboards, and visualizations to support business decisions. Ensure data accuracy and integrity through regular audits and validation processes. Collaborate with various departments to understand data requirements and deliver customized Excel solutions. Provide training and support to team members on Excel functionalities and best practices. Troubleshoot and resolve issues related to Excel spreadsheets, macros, and VBA scripts. Document Excel processes and procedures to facilitate knowledge sharing and continuity. Well versed in communicating with clients. Must-Have Skills & Attributes: Proven experience as an Excel Specialist or similar role. Advanced proficiency in Microsoft Excel, including macros, VBA scripting, pivot tables, Mis reports, VLOOKUPs, Large dataset Structuring and complex formulas. Strong experience with Microsoft Outlook and efficient Email communication. Strong experience with Microsoft Outlook and efficient email communication. Proven ability to manage, organize, and analyze operational data in high-pressure environments. A proactive, astute, and smart thinker who thrives on problem-solving and precision. Strong time management, able to work UK hours consistently and adapt to different time zones when needed. Ability to work independently, remotely, and stay in constant communication with a central operations team. Strong analytical and problem-solving skills with attention to detail. Excellent communication and interpersonal skills. Ability to manage multiple projects and meet deadlines effectively. Experience with data visualization tools such as Power BI or Tableau is a plus. Qualification: Bachelor degree in any discipline preferably B. Com / M. Com/MBA Advanced Excel Data Analysis VBA Programming Macros Development Pivot Tables Data Visualization What We Offer : Full onboarding and structured training. A flexible, fully remote role with long-term career prospects. A supportive and dynamic team culture built on trust, performance, and innovation. Apply now with your CV and a short cover letter explaining your experience with Excel.

MIS - Job Description Roles and responsibilities: Provide support and maintenance to existing management information systems (MIS). Generate and distribute management reports in an accurate and timely manner. Develops MIS documentation to allow for smooth operations and easy system maintenance. Provide recommendations to update current MIS to improve reporting efficiency and consistency. Perform data analysis for generating reports on a periodic basis. Create & publish monthly Billing Forecast reports, Variance reasons, Billing advice. Develop MIS system for client management and internal communication. Build Employee Performance score cards based on the Project's (KPIs - Key Performance Indicators) & publish the reports on a weekly & monthly basis. Generate both periodic and ad hoc reports as needed for Client & Internal communication Understand operational problems and provide appropriate technical solutions. Analyze business information to identify process improvements for increasing business efficiency and effectiveness. Liaison with support functions & participate in cross-functional meetings to manage & improve existing management information systems (MIS) Skill/Experience/Education Required: 3-5 years of MIS/Analysis/Dashboard building experience Solid skills and experience in MS Office (Excel, Word, Presentations, VBA scripting) Creating reports using PLX/SQL and Data Studio (preferred) Generate and provide reports in accurate and timely manner Create documentation of all the reports for smooth operation and easy report maintenance Perform data analysis for generating reports on periodic basis Create automation to reduce the manual effort on reporting Generate both periodic and ad-hoc reports as needed Understand management problems and provide appropriate technical solutions Innovative thinker with ability to drive change and effectiveness through automation and process excellence Ability to work well independently in a team environment, be self-motivated and multi task while achieving expectations

1. Data Scraping 2. Advanced Excel 3. Communicating with clients, understanding project requirements, and providing training to the team accordingly. 4. Strong communication skills (English) in both written and verbal 5. Provident fund Annual bonus

Team Lead - Invoice & Data Analysis (US Telecom) Employment Type: Full-Time Location: Hyderabad (WFO) Role Description: The Team Lead will oversee and conduct data research and analysis, manage data, employ data science techniques, and ensure that data is handled effectively. The role involves leading a team, managing project timelines, and providing high-quality deliverables that align with client goals. Day-to-day tasks include analyzing datasets, reporting findings, and developing innovative solutions to complex problems. Job Responsibilities: Strong analytical skills with the ability to identify and resolve data discrepancies Excellent problem-solving and critical thinking skills Proficient in Microsoft Excel and other data analysis tools (e.g., Power BI, Tableau) Strong communication, interpersonal, and leadership skills Collaborate with clients, internal stakeholders, vendors, and other departments to resolve data issues Ability to manage and prioritize multiple tasks in a fast-paced environment Excellent attention to detail and accuracy Oversee team performance and ensure adherence to deadlines and quality standards Required Skills: Experience in the US Telecom Invoice processing and a good understanding of secondary research Excellent Communication skills. (Written & Verbal) Lead and manage a team of 5 to 10 data analysts focused on invoice reconciliation/any other data research process Develop and implement strategies for streamlining the invoice reconciliation process. Leverage data analysis tools and techniques to identify and investigate data discrepancies, and identify trends and opportunities for improvement Develop and implement quality control procedures for invoice reconciliation/any other data research process Prepare reports and presentations on key activities and findings Train and mentor team members on data analysis techniques and invoice reconciliation procedures MS Office - Word/ Excel, Power BI Medium to Advanced Level Qualifications: Graduate or Postgraduate in Commerce / Business Management/Equivalent 8 plus years in Data Research & Analysis, of which 2 to 3 years in team/people management

We are seeking an experienced CAA Developer with strong expertise in CATIA customization, automation, and VBA scripting. Key Responsibilities & Skills Strong CAA workbench knowledge; skilled in VBA scripting. Hands-on CATIA V5 (mandatory), CATIA V6/3DExperience preferred. End-to-end ownership: requirement gathering, analysis, development, testing, delivery, support. Client engagement: capture requirements, conduct VOC surveys, present POCs. Project planning & adherence to timelines/quality standards. Automation expertise in electrical drawings: circuit tables, diagrams, harness layouts, 3D harness-to-circuit automation. Basic 3D modeling in Part & Surface Design. Problem-solving, attention to detail, and self-testing skills. Potential to grow into Team Lead role in 6 -12 months.