Sr Operations Consultant

Responsibilities

· Develop and deliver advanced data reporting and analytics solutions to support operational decision-making.

· Design and optimize Power BI solutions, including DAX measures, Power Query transformations, and data modeling for performance and scalability.

· Write and maintain complex SQL Server queries, stored procedures, and functions, ensuring performance tuning and best practices.

· Build Python-based data pipelines, scripts, and API integrations for automation and advanced analytics.

· Work with Generative AI tools and architectures, including Large Language Models (LLMs), Prompt Engineering, Retrieval-Augmented Generation (RAG) applications, and platforms such as Google Gemini and OpenAI.

· Leverage ServiceNow for reporting and analysis of ticketing data, providing operational insights and improvement opportunities.

· Utilize Microsoft Copilot and other AI assistants to improve team efficiency and decision-making.

· Document processes, share knowledge, and mentor team members to raise the overall capability of the team.

· Ensure deliverables meet quality standards and align with business objectives.

· Take ownership of assigned tasks, proactively communicating progress and risks to stakeholders.

· Actively contribute ideas for automation, innovation, and process improvement.

Qualifications

· Minimum 5 years of professional experience in analytics, operations consulting, or related roles.

· Proven expertise in Power BI (DAX, Power Query, data modeling).

· Strong SQL Server skills with experience in writing and optimizing complex stored procedures and functions.

· Proficiency in Python for data manipulation, automation, and API integration.

· Knowledge of ServiceNow reporting and ticketing data analytics will be an advantage.

· Practical exposure to Generative AI, LLMs, Prompt Engineering, RAG architectures, and tools like Google Gemini and OpenAI.

· Familiarity with Microsoft Copilot or equivalent AI-powered productivity tools.

· Bachelor’s degree in Computer Science, Information Technology, or related field (Master’s preferred).

· Excellent communication skills, both written and verbal.

· Strong collaboration and stakeholder management skills