- North Bridge Road Downtown Core Central Region (Singapore) Singapore
MYRICA SOLUTIONS PTE. LTD. Hiring! Full Time Power BI Developer in Central Region (Singapore), Earn up to SGD 6,000 - Ricebowl
Share
Save
Working Location
Job Description
Responsibilities
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
- 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)
- 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.
Important Information
Never provide your bank or credit card details when applying for jobs. Do not transfer any money or complete unrelated online surveys. If you see something suspicious, Report this Job ad.
Learn More