Connecting...

BI Developer

Job Title: BI Developer
Contract Type: Permanent
Location: Singapore
Industry:
Contact Name: Shashi Natrajan
Contact Email: shashi.natrajan@ellwoodconsulting.com.sg
Job Published: April 24, 2019 15:47

Job Description

About our client

Our client is Management Consulting Company focused around helping organizations maximize growth & overall performance through transformation of their supply chain. Our client founded in 2015 by key management consulting and supply chain professionals having diverse industry, solution and product experience. Driven by a team of 100+ globally positioned supply chain consultants and has presence through their offices in Singapore, Australia, India, United Kingdom, United States.

 

About the role

  • The BI Developer will perform detail analysis of source system and source system data and model that data in Power BI. Design, develop, and test Power BI scripts to import data from source systems and test Power BI dashboards to meet customer/client requirements. 

 

Your responsibilities

  • Extensive experience with Power BI, M and DAX functions.

  • Perform detailed analysis of source systems and source system data and model that data in Power BI.

  • Design, develop, and test Power BI scripts to import data from source systems and test Power BI dashboards to meet customer/client requirements.

  • Extracting, transforming and loading data from multiple sources into Power BI applications.

  • Design, create and tune physical database objects (tables, views, indexes) to support logical and dimensional models; Maintain the referential integrity of the database.

  • Expertise and proven experience in development of reports, dashboards, KPI scorecards, aggregating data from multiple sources.

  • Background in data warehouse design (e.g. dimensional modeling) and SQL databases and SQL statements.

  • In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework.

  • Analyse Data Model and Report Build with Other BI tools and Migrate to Power BI.

  • Experience on writing SQL queries.

  • Good understanding in Datawarehouse Concepts like Star Schema, Snowflake Schema, Fact, Dimensions etc.

  • Good Knowledge on Writing Complex DAX function, Power Query.

  • Hands on experience in Building Power BI Data Model, Dashboard & Reports using various Chart, Slicer, Pivot and Custom Visuals.

  • Knowledge on Power BI Desktop and Power BI Service.

  • Experience creating real-time dashboards is a plus.

Functional Competencies:

  • Converting data to stories using advanced visualization techniques to help with data-driven decision making and management reporting.

  • Assisting business users in coming up with the right data and visualization solutions for their requirements which will involve rapidly transforming raw data into actionable information using ETL, analytics and visualization tools and techniques.

  • Work in an extremely Agile environment with continuous user interaction.

  • Empower business users for self-serve reporting by building robust domain and logical models.

  • Digesting and understanding Business Requirements and designing new modules/functionality to meet those needs.

  • Proactively look to develop, implement and further develop best practices across the group. The areas of focus should include, but not be limited to quality improvement, code reviews, code/architecture standards, code reuse, and reduction of support calls, technical documentation and technical design specifications.

  • Work directly with business units to define and prototype Power BI Dashboards.

  • Analytical mind with a problem-solving aptitude.

 

You will have

  • Educational Background: Ideally you hold a Bachelors /Masters in Computer Science Engineering/ Electrical Engineering / Electronics Engineering. 

  • Years of Experience: 2-6 years of relevant experience in Business Intelligence domain. 

Personal Attributes:

  • Ability to cope in a complex and fast-changing business environment, and to respond calmly and rationally to changing aspirations in a deadline-driven situation.

  • Good communication skills with a capacity to present, discuss and explain issues coherently and logically both in writing and verbally.

  • Good team player, self-motivated and able to work on own initiative.