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