Power BI Developer

Power BI Skills:
Advanced with DAX
Understand big data concepts - partitions / incremental refresh, agg awareness, etc.
Comfort with dimensional modeling - facts and dimensions, bridge tables.
SQL for view-creation / native queries

Scope

• Focus will be on creation of the following deliverables
• 'Hey Dude Wholesale' -
• SPS Semantic Layer (Power BI Dataset)
• SPS Reporting - Report to be built from Semantic Layer
• Ship+Open Semantic Layer (Power BI Dataset)
• Ship+Open - Report to be built from Semantic Layer
• 'Circana'
• 'Circana' - Semantic Layer (Power BI Dataset)
• Circana Report
• Expectation of 40% time dedicated to creation of semantic layer, 60% time dedicated to report builds.
• Expectation is that minimum transformation needed in PBI Semantic Layer.
• The following will be needed for successful scope completion:
• Source Data Identification - contributes to requirements but does not develop .
• ETL of Data into Snowflake - no development needed . Handled by engineering team.
• Snowflake Modeling for extraction to PBI Semantic Layer - no development needed . Handled by engineering team.

Required Skills : Need a SR Power BI Developer with 10+ years of experience. Power BI******DAX****SQL*****Dimensional Modeling.

Basic Qualification :

Additional Skills :


Background Check : Yes


Drug Screen : No


Notes :
Selling points for candidate :
Project Verification Info :"The information provided below is for Apex Systems AV use only and is not to be distributed publicly, or to any third party. Any distribution of the below information will result in corrective action from Apex Systems Vendor Management. Client Letter: Will Provide"
Candidate must be your W2 Employee :No
Exclusive to Apex :Yes
Face to face interview required :No
Candidate must be local :No
Candidate must be authorized to work without sponsorship ::No
Interview times set :Yes
Type of project :
Master Job Title :
Branch Code :