The Data Modeler will be responsible for the developing/maintaining the physical model and will partner closely with the team who will deliver the logical model (and potentially provide feedback).
Knowledge of Power BI architecture will be helpful to understand performance implications
We don't have an in-house data modeling tool at this time but are exploring tools to procure. Candidate needs Dimensional Data Modeling experience.
The Data Modeler will need advanced SQL skills to conduct data analysis. Azure Data Factory knowledge may be helpful as well.