Develop and maintain shared semantic models in Power BI using star schema design.
Develop SQL queries to extract and manipulate data from our BigQuery database for use in Power BI.
Define and implement best practice report/data management through Microsoft Fabric integrations.
Review and maintain reports for performance optimizations, style consistency, and best practice improvements.
Consult on and support building a data model and structure that enables efficient and accurate reporting and analysis.
Consult on wireframe design during the early stages of building new reports to provide guidance on effective visualization and user experience.
Consult on the development of strategically insightful reporting dashboards with actionable insights to support key stakeholder decision-making processes.
Requirements
Experience (4+ years) in Data Modelling, Data Analysis, or similar.
Demonstrated experience with Power BI, semantic models, and other Microsoft Fabric tools.
Demonstrated proficiency creating SQL queries to manipulate large datasets.
Strong analytical and problem-solving skills, with a focus on best practice and data governance.
Strong attention-to-detail, with the ability to organize and maintain datasets using meticulous, self-determined methods.
Strong communication skills, with the ability to define requirements and explain technical concepts to both technical and non-technical stakeholders.
Experience with BigQuery or other data warehousing platforms.