jobs in MYRICA SOLUTIONS PTE. LTD.

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

Power BI Developer

MYRICA SOLUTIONS PTE. LTD.

全职

Downtown Core, Central Region (Singapore)

分享
保存

工作地点

  • North Bridge Road Downtown Core Central Region (Singapore) Singapore

职位描述

岗位职责

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.
Marketing

重要安全守则

申请工作时，切勿提供您的银行或信用卡详细资料。不要转账或完成无关的在线调查问卷。如果您发现可疑内容，请举报此招聘广告。

了解更多