Power BI 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

Roles and Responsibilities:

• Design, build and maintain Power BI reports and dashboards and 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.