Required Work Experience:
- Minimum of 5 years of experience in a role requiring analytics or reporting.
Physical and Mental Requirements:
- Ability to sit for prolonged periods.
Knowledge:
- Expertise in creating, managing, and analyzing large master data sets.
- Working understanding and experience with relevant Order to Cash processes.
- Systems knowledge: QLS, QBS, QDSS, Cognos, QPS, QMPS, IDAA.
Skills:
- Proficiency with the Microsoft Power Platform (Power Apps, Power BI, Power Automate).
- Experience with data science tools and programming languages, including Python and packages such as Pandas, NumPy, Scikit-learn, and PySpark.
- Advanced SQL skills, including Common Table Expressions (CTEs) and User Defined Functions (UDFs).
- Understanding of data pipeline management, including underlying scripts, edge cases, scalability, future-proofing, and API configurations.
- Advanced proficiency in Excel, including Regular Expressions, Pivot Tables, Chart Designs, Dashboard Creation, VBA/Macros, and various lookup functions (XLOOKUP, HLOOKUP, VLOOKUP, INDEX/MATCH).
- Expertise in rational database query and creation (Access & SQL).
- Direct experience influencing operational leaders.
- Proven track record in analyzing data and drawing actionable conclusions.
- Strong communication skills, with the ability to hunt down data, transform it, and clearly express opportunities.
- Strong presentation skills.
Software / Programming Requirements:
- MS Excel: data mining, modeling, and tool origination/refinement.
- MS Power Platform: Microsoft PowerBI, Power Apps, Power Automate
- Minitab: statistical analysis of historical data.
- Python: data extraction/building methods
- MS Access: database queries and creation.
- SharePoint / Tableau: distribution of metrics and data sets.
- Bonus: MS Visio
Attributes:
- Results-oriented.
- Collaborative.
- Analytical.
- Problem-solving.
- Customer-focused.
- Negotiating skills.
- Functional/technical skills.
- Organizational skills.
Education:
Certifications:
- Green Belt Certification.