Data Analyst I-II (Power BI)

21 Nov 2024

Vacancy expired!

Role Description

(90% PowerBI & SQL / 10% Python & Stats)•

PowerBI Experience - Advancedo Level of Detail (LoD) Calculationso Utilizing variables within measureso Should be able to define and utilize the following DAX functions:§ Date/time functions§ Aggregation functions§ Filter functions§ Logical functions§ Information functions§ Parent and Child functions§ Relationship functions§ Table Manipulation functions§ Time intelligence functions

•

Oracle SQL (PL-SQL) – Intermediate to Advancedo Must be able to write complex queries utilizing the following:§ Multiple joins (complex join logic)§ Common Table Expressions (CTE's)§ User-defined functions§ Converting data types

o

Understanding of data normalization§ Dimension Tables vs. Fact Tables

•

Python experience – Basic to Intermediate o Basic Descriptive Statistics§ Averages, Standard Deviation, Control Limits, etc.§ Normalizing sample statistics

o

Predictive Modelling§ Forecasting§ Anomaly detection§ Heat Maps

  • ID: #23207690
  • State: Georgia Atlanta 30301 Atlanta USA
  • City: Atlanta
  • Salary: Depends on Experience
  • Job type: Contract
  • Showed: 2021-11-21
  • Deadline: 2022-01-03
  • Category: Et cetera