Ingram Micro

VBA Macros Specialist

Posted on: 6 Feb 2021

Irvine, CA

Job Description

Description

Ingram Micro helps businesses fully realize the promise of technology.TM No other company delivers the full spectrum of global technology and supply chain services to businesses around the world. Ingram Micros global infrastructure and deep expertise in technology solutions, supply chain, cloud and mobility enable its business partners to operate efficiently and successfully in the markets they serve. Combined with distinct market insights and the trust and dependability generated from decades of strong partner relationships, Ingram Micro stands apart as the global technology services provider for the future.

SUMMARY OF RESPONSIBILITIES

In this role you will be the primary point of contact and subject matter professional for export compliance systems operations, advise with compliance knowledge and technical expertise. you will be responsible for working with stakeholders to understand business scenarios in various ERP systems via building reporting tools (queries) and data analyses, propose and validate solutions by performing UAT and production QA to meet business needs. The ideal candidate will also help drive process improvements by sharing the primary goal to increase efficiencies, accuracies and productivities.

Major Responsibility: Export Compliance Program Management for Clients

Supporting Actions:

* Collaborate with high profile clients and project managers on multiple large projects that span across multiple platforms or ERPs (SAP, Impulse, Shipwire, etc.) and multiple development teams
* advise with compliance knowledge and technical expertise during the requirements gathering process
Major Responsibility: Automation, Process Improvement and System Enhancement
Supporting Actions:
* Partner cross-functionally to create and provide data and system requirements needed to develop metrics.
* Initiate in delivering business and systems process automation improvements and provide solutions with primary goal to increase efficiencies, accuracies and productivity.
* capture feature/function information at varying levels and document them in a requirements management tool (BRDs, JIRA, etc.)
* Create test cases and provide UAT results

Major Responsibility: Performance Metrics, Reporting, and Scrutiny
Supporting Actions:

* Develops key performance metrics and dashboards and presentations to help drive key business judgment-making and provide data-driven improvement recommendations through data mining and analyses.
* Detailed monthly reports along with occasional ad hoc reporting will be required.

Major Responsibility: Supporting Systems Operations and Auditing
Supporting Actions:

* Resolve issues and bug reports raised by users in a timely manner.
* Enhance scripts/applications based on additional new requirements.
* Produce technical design as required. Create and maintain documentations to provide a comprehensive understanding of scripts/applications.

JOB QUALIFICATIONS AND EDUCATIONAL REQUIREMENTS

Education: Bachelor's degree.

Excellent interpersonal, verbal and written communication skills

complex level of knowledge of the MS office Suite, including:

* MS Excel writing macros, developing formulas, using functions such as pivot and lookup tables
* MS Access multi-table queries, report generation, macros, forms (preferred)
* General knowledge in MS Outlook, Word, Power Point.

Experience with Query Languages (SQL, Python) recommended

Working knowledge with Magellan or other Business Intelligence software, creating queries and report generation is a plus

Familiarity with ERP system such as SAP/GTS, or other Trade Compliance systems and tools is a plus.

Ability to examine and interpret statistical reports.

Time management, prioritization, and organizational skills; ability to prioritize among demanding and sometimes conflicting requirements.

Attention to detail and data integrity; with high level of diligence and professionalism

Occasional extended work hours may be required.

Ingram Micro Inc. is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, veteran status, or any other protected category under applicable law.

Ingram Micro

Irvine, CA

Ingram Micro Inc. distributes information technology (IT) products; and provides supply chain and mobile device lifecycle services worldwide. The company offers IT peripherals, such as printers and scanners; digital signage products; CE products; AIDC/POS products; physical security products; components; and supplies and accessories. It also provides systems, including rack servers, tower and blade servers, desktops, portable personal computers, and tablets; and software products comprising business application, operating system, entertainment, security, storage, and virtualization software products, as well as middleware and developer software tools.

In addition, the company offers networking hardware, such as switches, hubs, routers, wireless local area networks, wireless wide area networks, network interface cards, cellular data cards, network-attached storage, and storage area networks; communication products that consist of voice over Internet protocol, communications, modems, phone systems, and video/audio conferencing; and network security hardware, including firewalls, virtual private networks, intrusion detection, and authentication devices and appliances.

Further, it provides mobile handsets, tablets, navigation devices, aircards, SIM cards, flash memory, and other mobile companion products; multi-vendor solutions; integration, marketing, financing, training and enablement, technical support, and inventory management services; and electronic commerce tools. The company sells its products to resellers of IT products and services through sales representatives. It has a strategic alliance with Microsoft Corp. to build, scale, and monetize cloud and digital services with the CloudBlue platform. Ingram Micro Inc. was founded in 1979 and is headquartered in Irvine, California. Ingram Micro Inc. is a subsidiary of Tianjin Tianhai Investment Co., Ltd.

 

 

Similar Jobs