Information Technology Analyst II
Contract: 12 months
Shift: M-F 7-4 or 8-5
Pay rate: Negotiable
Location: Cary North Carolina 27513
Description:
*Please ensure SQL and knowledge of macros are listed on the resume along with candidate location. Candidates can be located onsite in Cary, NC or Olathe, KS (hybrid schedule currently)
Visa sponsorship is not available, now or in the near future, for this position.
MOCI (Marketing Order Code Information) is proprietary John Deere software. Please see attached document for position requirements.
Core Responsibilities
Respond to and address any questions and/or requests from MOCI users and/or external stakeholders
Respond to and address any Service Now tickets sent to MOCI business team
Develop and maintain queries, tools, and reports for MOCI users and/or external stakeholders using various relational databases (DB2, HANA, SQL, EDL)
Develop solutions to enhance the efficiency and effectiveness of the various processes/tools that are utilized by the MOCI Admin team and others
Develop and manage knowledge base for MOCI
Conduct thorough system testing on MOCI functionality as needed
Conduct efficient and accurate data loads as needed
General Requirements
Language: English (required)
Education: Bachelor’s degree or other relevant discipline with relevant work experience.
Location: Cary NC or Olathe KS co-located with MOCI Business Team
Working hours: Mon-Fri, 7-4 or 8-5
Travel: 0%
General Knowledge & Experience
· Process and/or project management experience
· Experience with influencing without authority
· Strong collaboration, communication, and negotiation skills
· Experienced facilitator (virtually and in person)
· Detail-oriented
· Experience with learning, maintaining, and supporting multiples systems and processes
· Expert at Microsoft Suite (Excel, Outlook, Word, PowerPoint, SharePoint, PowerApps)
· Exceptional Excel knowledge and experience (data, macros, etc.)
Database / Technical Knowledge & Experience
· Demonstrated SQL experience used weekly in the past 6 months in handling large data sets and relational databases using one of more of DB2, HANA, SQL Server, etc.
· HANA experience is preferred
· Ability to decipher data models, interpret data and analyze results with minimal guidance
· Managing and designing a reporting environment, including data sources, security, and metadata
· Experience performing some coding with macros or other tools to provide reports in Excel, Tableau, QlikView and other reporting tools
What Makes a Strong Candidate
· Ability to provide professional responses (verbal and written) in English
· Independent learner, knowing when to ask questions
· Problem solver: ability to dig into the details of what is happening to determine root cause
· Ability to multitask with changing priorities while keeping focus on current task
· Willingness to balance daily support activities with project work
· SQL expert: designing complex SQL is a plus
· Experience developing and maintaining SharePoint sites and PowerApps/PowerAutomate workflows
· Familiarity with Deere Products and Processes
· Experience working in a cross-functional, global team environment
· Experience in roles that required demonstration of a strong working knowledge of a Configuration Management System