Description

Power BI proficiency: Ability to use Power BI Desktop and Service to clean, transform, and model data.
· DAX (Data Analysis Expressions): Master this formula language to build custom calculated columns, measures, totals, and complex filters.
· Power Query & ETL: Use Power Query to extract, transform, and clean raw data from multiple sources before loading it into your model.  
· Data Modeling: Design relational schemas, connect data sources, and configure star schemas with proper fact and dimension tables.  
· SQL & Excel: Write database queries in SQL and leverage Excel for preliminary data manipulation and fast ad hoc analysis.
Knowledge: Power Pages Development
Design, configure, and customize Power Pages websites, including forms, lists, security, permissions, and user authentication.
Develop responsive, accessible, and user-friendly web interfaces using Power Pages design studio, HTML, CSS, and JavaScript.
Implement Web Roles, Table Permissions, and authentication methods (Azure AD).
Visualization & Reporting
Dashboard Design: Build clear, interactive, and user-friendly reports using core visuals like bar charts, matrices, and maps.
Business Acumen: Understand key performance indicators (KPIs) and operational goals specific to our industry.
Stakeholder Communication: Gather requirements effectively from business users and explain technical findings in simple terms.  This may be a partnership role with the workstream-appointed Business Analyst on our team.
Education and Experience
·    A bachelor's degree in a quantitative field; 2 or more years of data analysis experience, and strong technical proficiency in SQL, DAX, and data modeling.
·       Generally, 2+ years of prior experience in business intelligence, data analys8is or report writing.
·       Supplementary tools: Familiarity with Excel, Python, or R for advanced data manipulation.
·       Data preparation: Experience with Power Query M transformation and building star.

Key Skills

Education

Any Graduate