GDR Defense

Compensation

Full Description

Only on W2 Role: No C2C Title/Level: Data Analyst Location: Chicago, IL (Remote) Duration: 6 months (20 hours per week - 4x5) 1. 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. 2. 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. Education: Bachelor's degree in Data Science, Computer Science, Information Systems, Statistics, Engineering, or a related quantitative field; equivalent practical experience accepted. Coursework or formal training in: Data modeling, SQL, and cloud data warehousing Business Intelligence / data visualization Machine learning and LLM fundamentals (preferred) Relevant certifications such as: Microsoft PL-300 (Power BI Data Analyst) Snowflake SnowPro Core or Advanced AI/LLM certifications (Azure OpenAI, Vertex AI, or equivalent) are a plus. Demonstrated completion of applied data engineering, BI, or AI bootcamps is also acceptable. Remote About the Company: GDR Defense