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