Information Technology Analyst II

24 months contract

Manager has requested local candidates in Cary North Carolina and Kansas City (Metro area Olathe) only to be submitted for review. Nonlocal candidates will not be reviewed. Please list local of candidate at the top of the resume. Client location will be based on candidate location either Client Cary North Carolina or Client Olathe.


35 years experience preferred in a technical support role.

Core Responsibilities as a Marketing Order Code Information Specialist are below:
Contribute information and ideas towards project/task evaluation
Update project management and resources accordingly including any relevant documentation
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 Business Support team and others
Collaborate with the MOCI Business Support Specialists as well as other stakeholders with the development execution and maintenance of various toolsets
Develop maintain and deliver internal and external training materials such as instructions for new toolsets
Act as the subject matter expert for MOCI data and toolsets

General Requirements
Language: English (required)
Education: Bachelors degree or other relevant discipline with relevant work experience.
Location: Cary NC colocated with MOCI Business Team
Working hours: MonFri 74 or 85
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)
Detailoriented
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 PowerBI and other reporting tools. Intermediate experience preferred

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 project work with occasional business support activities
SQL expert; designing complex SQL is a plus
Experience developing and maintaining SharePoint sites and PowerApps/PowerAutomate workflows
Familiarity with Client Products and Processes
Experience working in a crossfunctional global team environment
Experience in roles that required demonstration of a strong working knowledge of a Configuration Management System