Sr Operations Consultant

Job description

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