Job Summary:
We are seeking a detail-oriented and proactive Data & Automation Analyst. This role focuses on transforming data into actionable insights through advanced data modeling, reporting, and process automation. You will be responsible for building robust dashboards, streamlining data workflows, and automating repetitive tasks to improve business efficiency and decision-making.
Key Responsibilities
Data Analytics & Reporting
• Collect, clean, and transform data from procurement systems (SAP, Fieldglass, GEP, etc.) using Excel or other data cleansing software.
• Create and maintain interactive dashboards that provide actionable insights for leadership and stakeholders.
• Utilize advanced Excel functions (Power Query, Power Pivot, VBA a plus) to build reports and key performance indicators (KPIs).
• Ensure data accuracy, integrity, and security across all reporting and analytics solutions.
• Perform ongoing maintenance and updates to data universes as needed.
• Leverage system knowledge to fulfill ad hoc reporting requests, collaborating with stakeholders to understand their unique data and reporting requirements.
• Drive innovation by enhancing and optimizing existing reporting and dashboarding processes, making them more efficient and impactful for the business.
Process Automation & Optimization
• Automate manual processes and repetitive tasks using Microsoft Power Automate, focusing on workflows related to SAP, Fieldglass, GEP, SharePoint, Teams, and Outlook.
• Develop and implement solutions that enhance efficiency in reporting, data collection, approvals, dashboarding and communication processes.
• Monitor and maintain existing automated processes to ensure they are functioning correctly and delivering accurate results.
• Identify and recommend improvements to existing data processes and automation workflows.
Stakeholder Collaboration
• Collaborate with cross-functional teams, including all Indirect Sourcing teams and other internal business teams.
• Present data findings, and process improvements in a clear and actionable format to both technical and non-technical audiences.
Required Qualifications:
• Proven experience as a Data Analyst with exposure to SAP, Fieldglass, GEP or other E-Procurement systems.
• Proficiency with SAP reporting and data extraction.
• Advanced expertise in Microsoft Excel, including Power Query and Power Pivot.
• Experience designing and managing Excel dashboards that are dynamic and user-friendly.
• Proficiency with Microsoft Power Automate or other process automation tools.
• Strong analytical thinking and problem-solving skills with a focus on data accuracy and process efficiency.
• Excellent communication and collaboration skills to work effectively with diverse teams and stakeholders.
• Ability to work independently and be resourceful.
Preferred Qualifications
• Proficiency in VBA and/or other programming languages.
• Advanced skills in Excel macros.
• In-depth understanding of the procurement process, ensuring the ability to design meaningful dashboards that provide actionable insights.
• Experience with various reporting tools beyond Excel.
Horizontal is proud to be an Equal Opportunity and Affirmative Action Employer. We seek to provide employment opportunities to talented, qualified candidates regardless of race, color, sex/gender including gender identity and/or expression, national origin, religion, sexual orientation, disability, marital status, citizen status, veteran status, or any other protected classification under federal, state or local law.
In addition, Horizontal will provide reasonable accommodations for qualified individuals with disabilities. If you need to request a reasonable accommodation in order to complete the application or interview process, please contact us. All applicants applying must be legally authorized to work in the country of employment.
PandoLogic. Keywords: Data Analyst, Location: MENDOTA HEIGHTS, MN - 55129 , PL: 596978264...Job Description Job Description We need to add to our team of cabinet installers. We have a full schedule for the next several months with more sales coming. You will install custom cabinets in closets, garages, offices, pantries etc. You have a good attitude and...
...The police officer's responsibilities are to preserve public peace, protect life and property, prevent crime, arrest violators, and... ...available are numerous supplemental insurance packages. 401(k) or ROTH retirement with up to 5% employer matching after one year of employment....
...our team of talented medical professionals to conduct one-time, non-treatment Veteran Disability Exams in Bemidji, MN. Employment Status: Part Time Compensation: This is a hourly position, paid bi-weekly. Schedule: Part Time, 2 days a week, Monday-Thursday, 8:...
...Home Provider - Iowa/Cerro Gordo & Mitchell Counties at Mosaic summary: As a Home Provider in Iowa... ...by sharing your home and providing assistance with daily living tasks. This role allows for a meaningful work opportunity while fostering independence and cultivating...
...through our industry-leading talent placement firm YUPRO Placement. If you receive an internship, it may be at Harvard University, Wayfair, Salesforce, or Wellington Management among other leading organizations in the Greater Boston area. Are you eligible? You...