Power BI Developer

Roles and Responsibilities:

· Design, build and maintain Power BI reports and dashboardsand deliver according to customer requirements.

· Build and optimise semantic models (star schema,relationships, calculation groups) that are reusable across reports.

· Prepare and transform data with Power Query (M) and SQL.

· Write and optimize T-SQL queries to pull data from backenddatabases (such as RedShift and Athena) into the Power BI Cube.

· Create complex but highly performant DAX measures.

· Maintain reports and ensure data being returned is accurateand relevant.

· Tune report and model performance using tools such asPerformance Analyzer, DAX Studio and Tabular Editor.

· Work with stakeholders to ensure data is represented inreports in an easy to read format.

· Continually enhance reports to add value to business units.

· Carry out PowerBI administrative tasks e.g. creating appworkspaces and access.

· Provide access rights/security administration through RowLevel Security.

· Work with different business entities to understandreporting requirements.

· Gather information required to gain a good understanding ofcustomer requirements.

· Staying current with changing technologies and designtechniques and receive training as required.

· Understands the BI components fundamental to operation of aneffective BI system.

· Promotes a team atmosphere that is conducive to the overallaccomplishment of goals, schedules, and deadlines.

· Willing to travel for business 2 to 3 times a year ifrequired

Skills and Experience:

· Been working in the Power BI space for at least 3 years.

· Has extensive experience using PowerQuery to architect,develop and deploy scalable Power BI Semantic models of enterprize sizing.

· Strong SQL: joins, window functions, CTEs and queryperformance basics.

· Experience creating complex but highly performant DAXmeasures.

· Experience administering Power BI Service: workspaces,refresh, gateways, row-level security and sharing.

· Solid data modelling experience: star schema, fact anddimension design, relationships and cardinality.

· Has BI reporting and dashboard experience with Power BI andMS Excel.

· Experience with large datasets and techniques such asincremental refresh, aggregations or DirectQuery/composite models.

· End to end knowledge of data warehouse architectures,approaches and methodologies.

· Solid understanding of the Data Warehouse SDLC.

· Has a good understanding of and implemented Row LevelSecurity.

· Attention to detail to ensure the delivery of accuratereports.

· Aptitude for staying aware and up to date of changes to theMicrosoft BI technology stack.

· Microsoft Certified: Power BI Data Analyst Associate(PL-300) (Good to have)

Behavioral Outputs:

· Shows initiative and takes prompt action to accomplishobjectives and solve problems.

· Demonstrates continuous learning and puts gained knowledgeinto practice.

· Builds cooperative relationships across the business.

· Shares information with relevant parties to buildunderstanding of issues and capabilities.

· Shows innovative thinking and the ability to creativelysolve problems.

· Actively participates as a member of a team and showscommitment to team objectives.

· Communicates effectively and appropriately with all levelsof the organization.

· Ensures work output is of a suitably high quality andaddresses quality issues.