What are the responsibilities and job description for the Power BI -- W2 ONLY position at nTech Solutions?
Job Details
C2C/OPT-EAD candidates are NOT ELIGIBLE to be submitted for this role.
Title: Power BI Developer
Location: Oakbrook Terrace, IL
Terms of Employment
W2 Contract, 24 months (Possible Conversion)
This position is hybrid with 3 days in office.
The office is located in Oakbrook Terrace, IL.
Overview
Our client is seeking a Power BI Data Engineer & Visualization Specialist to design, develop, and maintain Microsoft Fabric-powered dataflows, analytical tools, and visualizations that drive business insights. The ideal candidate will have expertise in data engineering, experience working with multiple programming languages, and a strong background in building scalable and efficient analytical solutions using modern cloud and BI technologies.
Responsibilities
1. Power BI Development & Visualization:
Design and develop Power BI datasets, dataflows (including Microsoft Fabric Dataflows Gen2), reports, and dashboards for data visualization and analytics.
Optimize DAX calculations and Power Query (M language) for performance and efficiency.
Build user-friendly, interactive, and insightful visual representations of data.
Leverage Microsoft Fabric's OneLake and Lakehouse capabilities to build unified reporting experiences.
2. Data Engineering & Integration:
Develop and maintain ETL/ELT pipelines using tools like Power BI Dataflows Gen2, Azure Data Factory, or Microsoft Fabric pipelines to transform, clean, and aggregate data for reporting.
Connect to and integrate data from multiple sources including SQL databases, APIs, cloud storage, and third-party applications.
Implement robust data governance, security, and best practices in data management using Microsoft Purview or Fabric-native tools.
3. Programming & Automation:
Use Python, SQL, or R for advanced data manipulation, automation, and analytics.
Develop automation scripts to streamline BI workflows.
Utilize Microsoft Fabric environments such as Lakehouse and Data Engineering experiences to handle large-scale data processing.
4. Analytical Tool Development:
Build predictive models, forecasting tools, and customized BI solutions.
Collaborate with business stakeholders to gather requirements and build bespoke analytical tools using Power BI and Microsoft Fabric notebooks.
Apply statistical methods and machine learning techniques as needed.
5. Collaboration & Communication:
Work closely with business stakeholders, analysts, and IT teams to understand business needs and deliver actionable insights.
Provide training and documentation for Power BI and Fabric-based solutions.
Ensure consistency, reliability, and accuracy across reporting layers.
Required Skills & Experience
5 years of experience in Power BI development, data engineering, and visualization.
Deep understanding of Power BI, DAX, Power Query (M language), and data modeling techniques.
Proficiency in SQL and Python/R for data processing.
Experience working with Microsoft Fabric, especially Dataflows Gen2, OneLake, and Lakehouse architecture.
Familiarity with Azure Synapse Analytics, Azure Data Factory, and cloud data integration.
Strong understanding of modern data architecture, data warehousing, and data governance.
Demonstrated experience building scalable and interactive dashboards.
Excellent analytical thinking and communication skills.
