Previous Job
Previous
Power BI Dashboard Developer
Ref No.: 21-00401
Location: Regina, Saskatchewan
 
Must have demonstrated experience delivering business-related output with PowerBI as follows:

1.   Minimum of three (3) years experience in data warehousing projects, and data preparation including:
  • Capable of handling project documentation and design methodology
  • Capable of developing dimensional and relational models that are compatible with warehouse standards
  • Must be capable of understanding business requirements and data models while taking care of the sources
  • Proficient in prototyping, designing, and requirement analysis

2.   Minimum of one (1) year's current and contiguous experience designing, developing, publishing, and scheduling PowerBI dashboards as per client requirements with demonstrated prior experience in:
  • Mapping data attributes to KPIs
  • Determining the appropriate level of granularity
  • Creating measures (calculated columns) in PowerBI
  • Creating PowerBI data models
  • Implementing advanced-level calculations on datasets in PowerBI
  • Creating Data Analysis Expression (DAX) queries in Power BI Desktop
3.   Proficient in SQL.

4.   Working knowledge of database concepts and data modeling with the ability to understand programming concepts.

5.   Prior experience with secondary tools in the data realm, such as:
  • SQL
  • Data Warehouse
  • Azure
  • Visual Studio
  • PolyBase
  • Others
Software Knowledge: SAP, PowerBI, Toad for Oracle Base

Typical Duties: Will include, but not be limited to:
  • Researches and evaluates data for the development, analysis, interpretation, and reporting of performance indicators, internal benchmarking, and opportunities for the client group
  • Connecting to, importing, and transforming data for Business Intelligence, using SaskTel sanctioned methods
  • Convert raw data into meaningful insights through interactive and easy-to-understand dashboards and reports.
  • Building and maintaining analysis service report models
  • Using Power BI Desktop for developing dashboards, visual reports, and key performance indicator (KPI) scorecards
  • Developing, scheduling, and publishing Power BI reports as per requirements
  • creating DAX and SQL queries in Power BI Desktop
  • Provide mentorship in Power BI dashboarding best practices

Deliverables:
PowerBI Artifacts: measures, data model, DAX and SQL queries, inline documentation of those queries, datasets, multi-tab dashboards

Certifications & Education Requirements:

Diploma/Certificate in electronic or computer technology as recognized by SASTT (Saskatchewan Applied Science and Technologists Technicians) AND Industry recognized course(s) in Analyzing and visualizing data in PowerBI

(OR)

Computer Science, Commerce, Maths, Stats, or Engineering degree from a recognized institution (other math or science-oriented degrees may be acceptable) AND Industry recognized course(s) in Analyzing and visualizing data in PowerBI

(OR)

Industry approved certifications related to the practice of data modeling and dashboard development

DAMA (Data Administration Management Association) Knowledge or Certification Alignment with Best Practices outlined in DM-BOC manual (Data Management Body of Knowledge)


For any queries contact Kalyan at 760 463 9309/kal@dantatechnologies.net