Data Analyst -Remote With Travel - The Dignify Solutions, LLC

Keywords: Data visualization, data storytelling, improving organization, driving efficiencies, utilizing AI and process flow automation, presentations, communications, Power BI, training, DAX Code, Excel VBA, Smartsheet, Microsoft Power Automate, ChatGPT, Planview, ServiceNow, Microsoft Project

• On a program level, resource should use communications skills and technical training in business analytics to enhance program reporting across multiple areas.

Must have strong experience with Powe BI & excel

High level metrics

• Power BI: Created 6 Power BI reports with 25+ dashboards including 40+ individual uses of DAX or M code. Many reports required cleaning imported data, joining data, and manipulating data with pivots and linked queries. These reports help drive efficient data storytelling to allow viewers (from managers to exec leadership) quickly digest key metrics.
• Smartsheet: Created 30+ Smartsheet sheets and reports, including over 50 unique formulas across sheets. 5+ Smartsheet dashboards. 15+ unique automations. Saves time for management and drives efficient and effective reporting.
• Excel: Wrote 2 sets of extensive VBA code (~1⁄2 to 1 page long), 4+ Excel Scripts (~1⁄2 to 1.5 pages long), and 50+ unique formulas (INDEX/Match, XLOOKUP, IFS, SUMPRODUCT, etc.). Saves time for management and drives efficient and effective reporting.