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.
