Senior Data / Analytics Engineer Microsoft Fabric, Power BI, SQL, Python, PySpark

Diverse Consulting Group; United States; Remote; USD 120,000 - 150,000; Full time

Benefits offered by this job

Private medical care

Co-financing for the sports card

Training & learning opportunities

Constant support of dedicated consults

Job summary

Diverse Consulting Group is seeking an experienced BI/Data Engineer to join our remote team serving a US-based client. You will build data pipelines in Microsoft Fabric, develop semantic models, and deliver Power BI reports that translate complex data into actionable insights.

You will work with business stakeholders to define KPIs and AI-driven value, explore GenAI solutions, and ensure reliable, well-governed data access.

Qualifications

• Minimum 5 years of professional data/BI experience.
• Strong knowledge of Power BI data modeling and DAX.
• Hands-on Fabric Lakehouse, pipelines, and dataflows Gen2.
• Experience with SQL and Python/PySpark.
• Experience integrating data from APIs, files, databases, and SaaS.
• Interest or experience with GenAI, including prompt engineering and LLM evaluation.
• Excellent communication with business stakeholders.

Responsibilities

• Design data pipelines and semantic models in Fabric.
• Develop Power BI reports and dashboards.
• Define AI adoption and business KPIs with stakeholders.
• Enable conversational data access via Data Agent or Copilot.
• Ensure answer accuracy and define data boundaries.

Skills

5+ years experience

GenAI for data

Stakeholder communication

KPIs & business value

Independent problem solving

Tools

Microsoft Fabric

Power BI

SQL

Python/PySpark

APIs

LLM / prompt engineering

Job description

Job location: Remote

As a recruitment company, DCG understands that every business is powered by experienced professionals. Our management style and partnership approach enable us to meet your needs and provide continuous support. Due to our ongoing growth and the large number of recruitment projects we undertake for our partners, we are currently looking for:

Responsibilities:

• Data flows in Microsoft Fabric (ingestion, transformations, data modeling) from multiple sources
• Semantic model and Power BI reports
• Defining AI adoption and business value KPIs together with business stakeholders
• Conversational access to data based on the semantic model (e.g. Fabric Data Agent, Copilot in Power BI, or a custom LLM-based solution)
• Ensuring reliable responses through test question sets, accuracy validation, and clearly defined boundaries regarding the types of questions the solution can handle

Requirements:

• 5+years of professional experience
• Hands-on experience with Microsoft Fabric (Lakehouse/Warehouse, pipelines, Dataflows Gen2, notebooks)
• Very good knowledge of Power BI: data modeling, DAX, semantic models
• Good SQL skills and experience with Python/PySpark
• Experience integrating data from various sources (APIs, files, databases, SaaS platforms)
• Experience with or a genuine interest in GenAI solutions for data, including text-to-SQL/DAX, Fabric Data Agents or Copilot, as well as basic knowledge of prompt engineering and LLM response quality evaluation
• Confidence in communicating directly with business stakeholders and independently clarifying unclear requirements
• Ability to think in terms of KPIs and business value
• Proactive and independent approach
• Fluent English for working with a US-based client

Nice to have:

• Experience with reporting on tool adoption, ROI, or digital transformation
• Knowledge of Azure OpenAI / Azure AI Foundry

Offer:

• Private medical care
• Co-financing for the sports card
• Training & learning opportunities
• Constant support of dedicated consultant

Personal Consulting Agency (License No. 4642)