全职 Power BI Developer 工作, 薪水 up to SGD 5,000, MYRICA SOLUTIONS PTE. LTD. Central Region (Singapore) 公司招聘中 - Ricebowl

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.