Power BI Data Architect & Developer

MYRICA SOLUTIONS PTE. LTD.; Singapore; On-site; SGD 60,000 - 110,000; Full time

Job summary

MYRICA SOLUTIONS PTE. LTD. in Singapore seeks a Power BI specialist with 3+ years of experience to design and deliver scalable BI reports. You will build semantic models, optimize queries, and collaborate with stakeholders to provide accurate, actionable insights across business units.

This role requires hands-on expertise with Power BI, Power Query, SQL, and DAX, plus admin tasks and secure data access management. Join a dynamic BI team to drive business value.

Qualifications

• 3+ years in the Power BI space.
• Extensive PowerQuery experience to architect scalable semantic models.
• Strong SQL including joins, window functions and CTEs.
• Experience creating complex, performant DAX measures.
• Administering Power BI Service: workspaces, refresh, gateways, RLS.
• Solid data modelling: star schema, relationships and cardinality.
• BI reporting & dashboards with Power BI and MS Excel.
• Experience with large datasets: incremental refresh, aggregations, DirectQuery.
• End-to-end data warehouse knowledge and SDLC understanding.
• Awareness of RLS implementation and security practices.
• MBA/PL-300 certification is a plus.

Responsibilities

• Design, build and maintain Power BI reports and dashboards per requirements.
• Build and optimise semantic models reusable across reports.
• Prepare data with Power Query and SQL.
• Write and optimise T-SQL to pull data from RedShift and Athena.
• Create complex but performant DAX measures.
• Maintain reports ensuring data accuracy and relevance.
• Tune performance with Performance Analyzer, DAX Studio and Tabular Editor.
• Collaborate with stakeholders for readable data representations.
• Enhance reports to add business value across units.
• Carry out Power BI admin tasks like app workspaces and access.
• Provide access rights and Row Level Security management.
• Work with entities to understand reporting needs.
• Gather information to understand customer requirements.
• Stay current with BI tech and undergo training as required.
• Promote a team atmosphere to meet goals and deadlines.
• Willing to travel 2-3 times a year if required.

Skills

Power BI

Power Query

SQL

DAX

Row Level Security

Data Modelling

MS Excel

Power BI Service

Tabular Editor

DAX Studio

Tools

Power BI Service

DAX Studio

Tabular Editor

Job description

MYRICA SOLUTIONS PTE. LTD. in Singapore seeks a Power BI specialist with 3+ years of experience to design and deliver scalable BI reports. You will build semantic models, optimize queries, and collaborate with stakeholders to provide accurate, actionable insights across business units.

This role requires hands-on expertise with Power BI, Power Query, SQL, and DAX, plus admin tasks and secure data access management. Join a dynamic BI team to drive business value.