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.