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 typeso 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 statisticso Predictive Modelling§ Forecasting§ Anomaly detection§ Heat Maps
- ID: #21206131
-
State: Arizona
Phoenix
85001
Phoenix
USA
- City: Phoenix
- Salary: Depends on Experience
- Job type: Contract
- Showed: 2021-10-16
- Deadline: 2021-12-09
- Category: Et cetera