Power BI Dev and Snowflake Analyst

Title: Power BI Dev and Snowflake Analyst Location: REMOTE Term: 7 months of Contract role Job Description: Project Overview • The purpose of the Dispute Modeling Engine (DME) will be to provide a granular view into historical usage data and will support analysts when reviewing disputes submitted by the customer. • The DME will identify changes (both internally and directly on the customer’s instance) that may have occurred that are impacting usage and subsequently, quantify a valid credit amount. • The DME will leverage AI to provide key insights into the data such as changes that have occurred, identifying anomalies, etc. 1. Technical Environment • Data Source: Snowflake (various tables extracted from customer’s instance as well as internally managed tables) • Visualization Tool: Power BI • AI Integration: Snowflake Cortex AI – include AI summarization of changes • Data Modeling & Integration • Connect Power BI to Snowflake efficiently • Optimize queries and warehouse performance. • Create semantic models and reusable datasets. • Integrate AI tools into dashboard • Dashboard Development • Develop dashboard that dynamically changes visuals and data sources based on products selected • Implement an interactive dashboard that breaks out details by product type along with drill-through and filter capabilities. • Establish consistent visual design, KPI cards, and navigation. • Integrate AI capabilities that can assess data from various tables to provide key insights on data in a dashboard • Cortex AI Integration • Incorporate AI Summarization of changes • Implement natural language Q&A or conversational insights using Cortex LLM features. • Automate anomaly or trend detection. • Performance Optimization • Ensure efficient load times, DAX optimization, and query performance. • Set up caching, incremental refresh, or performance monitoring. • Documentation & Knowledge Transfer • Provide clear technical documentation (data model, DAX logic, AI pipelines). • Conduct knowledge transfer or walkthrough sessions. • Power BI Expertise • Advanced DAX, Power Query, data modeling, and visualization design. • Snowflake Expertise • Proficiency in SQL, schema design, and performance tuning. • Familiarity with Snowflake and integration into PowerBI • AI/ML & Cortex AI Familiarity • Experience using Snowflake Cortex (or equivalent LLM integration like Vertex AI or Azure OpenAI). • Understanding of prompt engineering, model outputs, and security/privacy considerations. General Skills • Experience integrating BI with AI/ML workflows. • Strong communication and documentation habits. • Ability to work iteratively with non-technical stakeholders. Russell Tobin offers eligible employees comprehensive healthcare coverage (medical, dental, and vision plans), supplemental coverage (accident insurance, critical illness insurance, and hospital indemnity), 401(k)-retirement savings, life & disability insurance, an employee assistance program, legal support, auto, home insurance, pet insurance and employee discounts with preferred vendors.