Sr Operations Consultant

Role Overview

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. 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.

What You Will Do

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. Leverage ServiceNow for reporting and analysis of ticketing data, providing operational insights and improvement opportunities.

Why It Might Be a Fit

Take ownership of assigned tasks, proactively communicating progress and risks to stakeholders. Actively contribute ideas for automation, innovation, and process improvement. Ensure deliverables meet quality standards and align with business objectives.

Requirements

• 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