Infrastructre Engineer

Sumas Corporation Inc; SOUTH PLAINFIELD (NJ); On-site; USD 60,000 - 80,000; Full time

Job summary

Sumas Corporation Inc is hiring a full-time role based in South Plainfield, NJ, focusing on optimizing database performance and data analysis. The candidate will be responsible for developing strategies and implementing custom code while using advanced Excel functions. A bachelor's degree in Industrial Engineering, Computer Science, or a related field is required. This position offers a great opportunity for individuals with 0-2 years of experience looking to grow in the data science field.

Qualifications

• Bachelor's degree in a relevant field is required.
• 0-2 years of experience preferred.
• Knowledge of data mining tools is advantageous.

Responsibilities

• Optimize queries and performance tuning for databases.
• Develop strategies and implement custom code.
• Consolidate data and develop ETL solutions using R and Python.

Skills

Data analysis

Advanced Excel functions

ETL development

R programming

Python

Education

Bachelor’s degree in Industrial Engineering, Computer Science, Computer Engineering, or Industrial Technology

Job description

Job Code: SCJ-023

Job Location: South Plainfield, NJ

Type Of Job: Fulltime

Hours Per Week: 40

Experience: 0-2 Years

Job Description

• Optimize queries and performance tuning for database.
• Enter, Analyze systems data as per requirement.
• Develop strategies, design, implement custom code, scripts, database technologies and data science applications.
• Use advanced Excel functions to generate spreadsheets and pivot tables.
• Coordinate with concerned department to establish business needs and understand data for developing real time analytical models.
• Consolidate the data and develop ETL solutions using R and Python and process data to provide strategies.
• Extract, Compile data using datamining tools.
• Trouble-shoot and bug fixes.
• Maintains, monitors, and supports the infrastructure environment and/or facilities.
• Follows defined procedures to monitor systems and resolve problems.
• Monitors system-operating capacity in terms of (e.g., disk space, storage, and CPU utilization).
• Recommends settings changes to the operating system to improve performance and reliability.
• Develops, maintains, recommends, documents, and supports tools and back-end utilities to provide capacity planning management.
• Monitors database performance and recommends changes.

Requirements

The minimum educational requirement is a bachelor’s degree in Industrial Engineering or Computer Science or Computer Engineering or Industrial Technology.