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.