Power BI Developer — Dearborn, MI

Only Full Time. Need locals to Michigan, F2F Interview preferred

Looking for Non H1B candidates

==================================

Power BI Developer

Dearborn, MI [4 days office]

Fulltime

SKILLS: Power BI, Power BI Report Builder, Power Query, DAX, SQL, GCP, Big Query,

Position Description:

Key Responsibilities:

• Design and develop interactive Power BI dashboards and reports for business and financial analytics.

• Build and maintain semantic models using appropriate relationships, star schemas, calculated columns, and DAX measures.

• Develop paginated reports using Power BI Report Builder, including parameterized, print-ready reports and scheduled distribution.

• Write and optimize complex SQL queries, views, and transformations to support reporting and data validation.

• Connect Power BI to BigQuery, and integrate data from multiple sources.

• Develop data preparation and transformation logic using Power Query and M.

• Optimize report and semantic model performance through efficient DAX, model design, storage-mode selection, and refresh strategies.

• Configure and manage Power BI Service workspaces, apps, access permissions, row-level security, and scheduled refreshes.

• Collaborate with stakeholders to understand requirements, define KPIs, and validate reporting calculations and business rules.

• Perform data reconciliation and troubleshoot discrepancies, refresh failures, and production reporting issues.

• Support report modernization and migration to Power BI, ensuring functional completeness and data accuracy.

• Maintain technical documentation and follow development, testing, deployment, and governance standards.

Required Skills:

• 6+ years of experience in BI development, with strong hands-on expertise in Power BI.

• Advanced proficiency in DAX, Power Query, and dimensional data modeling.

• Strong SQL skills, including complex joins, CTEs, window functions, aggregations, and query optimization.

• Hands-on experience developing paginated reports using Power BI Report Builder.

• Experience with Power BI Desktop and Power BI Service, including publishing, workspace management, security, and refresh configuration.

• Experience working with Google Cloud

• Understanding of Import, DirectQuery, and composite models, including their performance considerations.

• Experience handling large datasets and troubleshooting report and data model performance.

• Strong analytical, problem-solving, communication, and stakeholder collaboration skills.

Preferred Skills:

• Hands-on experience with GCP and BigQuery, including query optimization and partitioned and clustered tables.

• Experience with financial reporting, including sales, cost, profitability, contribution margin, and forecasting.

• Familiarity with Power BI deployment pipelines, version control, and CI/CD practices.

• Experience with Power BI governance, shared semantic models, and reusable reporting components.

• Microsoft Power BI certification, such as PL-300, is an added advantage.