Business Operations Analyst - Power Bi, Advanced Excel, Macros

Trigent Software; Bengaluru; On-site; INR 600,000 - 900,000; Full time

Job summary

Trigent Software in Bengaluru is seeking a data analyst to maintain data integrity and deliver accurate reports for the operations team. You will review data for accuracy, present findings to the Operations Director/Manager, and manage data-related queries with a professional approach.

The role requires strong Excel skills, SQL knowledge, and the ability to leverage AI tools like ChatGPT to streamline reporting and automate processes.

Qualifications

• Strong computer literacy and data-handling ability.
• Excellent English verbal and written communication.
• Experience using tools and applications relevant to data work.
• Proficient in building analyses and dashboards in Excel or BI tools.
• Advanced Excel and VBA programming skills are a plus.
• Ability to leverage AI-powered tools like ChatGPT to improve workflows.
• Knowledge of SQL and running queries in SQL Developer is advantageous.
• High accuracy and attention to detail in reporting.

Responsibilities

• Maintain data integrity with the delivery operations team.
• Review data for accuracy and present findings to management.
• Manage or escalate data collection and processing queries promptly.
• Develop and maintain documentation for report creation and analysis.
• Identify opportunities to automate reports and processes using AI tools.

Skills

Computer literacy

English communication

Data analysis

Excel/VBA

ChatGPT & AI tools

SQL queries

Attention to detail

Planning & organisation

Teamwork

Professional attitude

Tools

SQL Developer

Excel

VBA

BI tools

AI tools

Job description

Job Description:

• Maintain the integrity of data, working with delivery operations team.
• Review collected data for accuracy, and present findings to the Operations Director/Manager
• Excellent understanding of all tools and applications
• Manage or escalate issues and queries connected to the data collection and processing process, quickly, accurately, and professionally.
• Develop and maintain good working relationships with internal support groups.
• Maintain documentation of the processes related to Report creation and analysis.
• Identify opportunities to automate and enhance reports and business processes using ChatGPT and other authorized applications.

Profile:

• Highly computer literate - Essential
• Excellent English verbal and written communication skills Essential
• Experience in using Tools and Application – Essential
• Experience in building analysis and dashboards in Excel or other BI tool – Essential
• Advanced proficiency in Microsoft Excel and VBA programming skills – Good to have
• Ability to leverage ChatGPT and other AI-powered tools to improve workflow efficiency and reporting quality – Good to have
• Knowledge of SQL and experience of running SQL queries in SQL developer – Good to have.
• Accuracy and attention to detail
• Excellent planning, Organising and Presentation skills, ability to prioritize workload.
• Team player, Personal drive, Professional attitude