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.