Customer Data Analyst
Customer Data Analyst-WAY05651 Working at Cargill is an opportunity to thrive—a place to develop your career to the fullest while engaging in meaningful work that makes a positive impact around the globe. You will be proud to work for a company with a strong history of ethics and a purpose of nourishing people. We offer a diverse, supportive environment where you will grow personally and professionally as you learn from some of the most talented people in your field. With 150 years of experience Cargill provides food, agriculture, financial and industrial products and services to the world. We have 150,000 employees in 70 countries who are committed to feeding the world in a responsible way, reducing environmental impact and improving the communities where we live and work. Learn more at www.cargill.com.
DescriptionPosition Purpose The Customer Data Analyst will be responsible for successfully collecting, cleaning, loading, and reporting each month for FIBI Commercial Excellence NA. The Customer Data Analyst will also be responsible to collect quarterly Global data on top Enterprise Accounts. The Customer Data Analyst will assist in developing and implement new scorecards. This role will partner with key stakeholders across the organization to identify Business Intelligence needs, analyze requirements, and provide proposals for reasonable and feasible solutions. The Customer Data Analyst will help implement and maintain the solutions. Cargill is a very diverse company, with many different systems supplying the data to FIBI Commercial Excellence NA. The Customer Data Analyst will need to develop an intimate understanding of these systems, as well as the ability to navigate and report off of them. This role will utilize the following technologies: Business Objects (report creation), SAP queries, SQL Query Development (Oracle), Alteryx and Microsoft Excel. Principal Accountabilities 40% Analyze and Deliver New Reporting Requests: Business stakeholders across all functions have cyclical and ad hoc requirements to see cross-Business data which resides primarily in FIBI Commercial Excellence NA's unique system. The Customer Data Analyst will take the business requirements and map out, prioritize, and implement a strategy to deliver the required data. Strong communication skills are required to solicit the requirements and communicate with non-technical business stakeholders effectively. The Customer Data Analyst will help the business achieve goals by providing insights from data. The Customer Data Analyst will also develop & present scorecards to relevant stakeholders as needed. 35% Support FIBI Commercial Excellence NA's Shared Sales: The Customer Data Analyst will be responsible for the monthly sales reporting and incentive compensation calculation. Multiple monthly Business data feeds must be combined, cleaned, and validated to provide management with sales reporting and feed into incentive compensation reporting. This includes, but is not limited to: validating the data received from the Business, validating customers are properly tagged to Shared Sales reps in a timely matter, validating new customers & products for Shared Sales members, accurately grabbing history for transferred customers. The Customer Data Analyst will also need to have a deep understanding of the Shared Sales compensation structure for Canada and US sales reps and be able to explain to sales reps & other team members. 15% Create and Troubleshoot Advanced Reporting/Data Solutions: FIBI Commercial Excellence NA has a variety of reporting solutions pulling in data from many systems. Some of these utilize Business Objects reporting, Alteryx, and advanced MS Excel workbooks with macros. Others utilize OLAP connections to a variety of relational databases or even MSAS data cubes. The Customer Data Analyst will help the business improve, understand, and help support all these systems. If Commercial Excellence takes on any data projects, the Customer Data Analyst will be the key tag between the project team and Commercial Excellence NA. 10% Improve Data Integrity: Any report is only as valuable as the accuracy of the data. The Customer Data Analyst will be responsible for helping maintain and improve Commercial Excellence NA data integrity across all source systems. This includes Data Management tasks.
If selected for an interview, you will be required to submit signed copies of your last two performance reviews. (A completed e-PMP is considered a signed copy.)
Equal Opportunity Employer, including Disability/Vet.
This position is posted internally as well as externally
- Bachelor's Degree in MIS, Accounting, Economics, Computer Science or Finance
- Strong analytical and decision making skills
- Ability to quickly learn and effectively navigate the organization
- Ability to take initiative and operate in ambiguous situations
- Self-motivated to problem solve with little direction
- Hard working and driven to achieve deadlines
- Highly detail oriented
- Ability to travel up to 5%
- Ability to handle confidential information
- Proficient with complex Excel formulas and Pivot Tables
- Extensive computer work is required
- 2 years of full-time Business experience
- Experience with query writing (SQL), report writing (Business Objects), MS Access, Alteryx
- Ability to understand business requirements and identify data patterns, trends and risks
- Experience leading, organizing, and presenting at meetings
- Comfortable working with complex data: relationships, analysis, support, ERD diagrams
- Experience with educating and training others and/or helping clients and customers with using data and reporting to solve problems
- Understanding of advanced reporting, business intelligence, database querying and data warehousing concepts
Equal Opportunity Employer, including Disability/Vet.
Primary Location US-MN-Wayzata
Job Type Standard
Shift Day Job