BI Dashboard Analyst Level 1

Job Description

Job Description

Job Description

This role reports directly to the Senior Manager ofAnalytics and Asset Protection and supports reporting needs across all levelsof the organization. The team is seeking a candidate with strong experience inbuilding Power BI reports from the ground up, leveraging a variety of datasources such as databases, Excel, flat files, and other structured orunstructured formats. The ideal candidate will be highly proficient in writingDAX (Data Analysis Expressions), creating data relationships, and using Power Querywithin Power BI. Advanced SQL skills are also essential, including the abilityto write complex queries involving joins, nested logic, and recursivestatements. The team will provide onboarding support, including an overview ofcurrent reporting structures and data integration processes. In addition todeveloping new reports, the candidate will also be responsible for maintainingand enhancing existing Power BI reports.

Must have skills and experience (1-3 years) :

Power BI - should be able to Develop reports from scratchand update and maintain existing Power BI Reports

SQL - must be able to write complex queries

MS Excel - must be proficient

R - if they do not have experience with R, Python is ok

Statistical analytical skills must be able to analyze,interpret, and explain data to various audiences

Database knowledge - not just pulling data, but creatinglinks to data so that all metrics that they use are available

Nice to have skills and experience :

Python

Alteryx

Soft skills : Communication

Will be talking with many different departments anddifferent levels of personnel (team leads, executive members, etc.) and must beable to communicate effectively and efficiently

Team player

Willing to help the rest of the team if their projecthappens to be slow

Go-getter mindset

Willing to think outside-the-box

Must be able to work independently with minimal guidance

Key Responsibilities

Automate existing reporting methods to make data moreaccessible

Work closely with the Analytics and Asset Protection teamin order to determine what reports are needed and how they can be modified

Create links to data so that all metrics needed areavailable

Utilize available technologies to re-engineer allreporting

Note to Vendors

Title : BI Dashboard Analyst - Level 1

Contract or Contract to Hire : Contract

Duration : 1 year with possibility to extend

Location : 100% remote, any US location, no travelrequired

If in Cincinnati, they can work at the GO location ifthey choose - 1014 Vine Street, Cincinnati, OH 45202

Hours : EST business hours

Bill Rate : Please submit at market rate for a level 1resource

Team dynamic :

Fast paced - will sometimes transition from one projectto another quickly, and will be working with all areas of the business(storefront, warehouse, etc.)

Currently 2 contract Developers (adding a 3rd) and 1internal Team Lead Developer

Pre-screen : 5 video questions, a game, and codingchallenge. Candidates should code in Python, R, or SQL, whichever they are mostcomfortable with.