Inventory Analyst
Acutec Global Services LLP
full-time
Posted on:
Location Type: Hybrid
Location: Alpharetta • 🇺🇸 United States
Visit company websiteSalary
💰 $26 - $32 per hour
Job Level
Junior
Tech Stack
SQL
About the role
- Executes accurate, scheduled daily, weekly, and monthly reports.
- Reconciles report data to ensure data integrity.
- Audits processing errors or bad data points before releasing reports.
- Maintains report contact database, controls user access to shared network drives and other common resources, and executes regular backups.
- Maintains production reports, makes approved changes to report data by modifying Teradata SQL, formatting Excel macros, and Access databases.
- Executes on demand processes and reports, adjusts input parameters, data, and formatting prior to execution, and validates report data prior to publishing results.
- Assists in ad-hoc report development and execution, including modifying existing or developing new SQL, running reports, and formatting data using advanced Excel capabilities.
Requirements
- Bachelors’ Degree in Mathematics, Statistics, Operations Research, Computer Science, Engineering, Supply Chain, Logistics or a similar quantitative discipline
- APICS, CPFM, CPM preferred
- 1 year required of related experience, preferably in distribution industry
- Ability to follow established processes and schedule to deliver timely and consistent report execution
- Ability to work independently, check your results, troubleshoot problems and exercise judgment
- Expert knowledge of Microsoft Excel, including creating and editing macros and utilizing other advanced functionality
- Knowledge of Microsoft Access, including creating basic queries, code and reports
- Understanding of relational databases, including creating SQL statements
- Knowledge of other applications, including Microsoft Word, PowerPoint and Outlook
- Excellent analytical and problem solving skills, proven ability to apply these in business environment
- Strong verbal and written communication skills
- Knowledge of distribution industry, supply chain, purchasing, and inventory concepts, practices, and procedures
Benefits
- paid time off
- medical/dental/vision insurance
- retirement savings plans
- participation in a bonus or sales compensation plan
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
Teradata SQLExcel macrosAccess databasesSQL statementsdata integrityreport executionad-hoc report developmentdata formattinganalytical skillsproblem solving
Soft skills
independent worktroubleshootingjudgmentcommunication skillsprocess adherencetimelinessconsistency
Certifications
Bachelors’ DegreeAPICSCPFMCPM