Laborup

Job Description: Power BI / Data Scientist (AI & Microsoft Fabric focus)

Location: ON-site 60608
Department: Internal Systems / Information Technology
Reports To: IT Manager/Director and VP of Technology

Hours are 7/7:30am to 4p daily with one Saturday a month 7:30a to 1p

We are seeking a forward-thinking Power BI / Data Scientist to lead the development of our next-generation data ecosystem. In this role, you will bridge the gap between traditional business intelligence and advanced AI by leveraging Microsoft Fabric to curate data, build complex Power BI reports, and develop sophisticated AI Agents. A key focus will be preparing our data for natural language interaction by building and refining Linguistic Schemas and AI-ready semantic models.

Key Responsibilities

• Power BI & Reporting: Design, develop, and maintain high-impact Power BI dashboards and interactive reports using advanced DAX and Power Query.
• Data Curation: Curate and transform raw data into high-quality, reporting-ready datasets within Microsoft Fabric OneLake to ensure data integrity and optimized retrieval.
• AI Agent Development: Build and configure Fabric Data Agents that enable users to interact with enterprise data through natural language (Q&A).
• Linguistic Schema & AI Prep: Prepare data for AI consumption by building and importing Linguistic Schema (.lsdl.yaml files) to enhance natural language understanding.
• Microsoft Fabric Ecosystem: Utilize the full suite of Fabric workloads—including Data Science (Notebooks), Data Engineering (Lakehouses), and Data Warehouse—to automate data processing and enrichment.
• Model Optimization: Refine semantic models with specific AI instructions, example queries, and synonyms to improve the accuracy of generative AI responses.

Required Skills & Experience

• Reporting & Visualization: Proven experience developing complex Power BI solutions, including data modeling and Direct Lake mode optimization.
• Microsoft Fabric Proficiency: Hands-on experience with Fabric OneLake, Lakehouses, and the integration of diverse data sources (SQL, Parquet, Delta tables).
• AI & LLM Integration: Experience developing AI Agents or conversational AI experiences using Large Language Models (LLMs) like GPT-4, specifically within the Microsoft ecosystem.
• Linguistic Modeling: Experience editing and managing Linguistic Schemas in Power BI Desktop to support Q&A and AI-driven insights.
• Data Science Fundamentals: Proficiency in Python or R for exploratory data analysis (EDA) and model development within Fabric Notebooks.
• SQL & DAX: Advanced ability to write and optimize T-SQL and DAX queries for structured data environments.

Preferred Qualifications

• Experience with Azure AI Foundry or Copilot Studio for extending AI agent capabilities.
• Microsoft certifications such as DP-600 (Fabric Analytics Engineer Associate) or PL-300 (Power BI Data Analyst Associate).

Pay: $115,000.00 - $150,000.00 per year

Benefits:

• 401(k)
• Dental insurance
• Health insurance
• Paid time off
• Vision insurance

Experience:

• Power BI: 3 years (Required)
• AI/ML: 3 years (Required)

Ability to Commute:

• Chicago, IL 60608 (Required)

Work Location: In person