Data Analyst

PlanIT Group, LLC; United States; On-site; USD 90,000 - 130,000; Full time

Job summary

PlanIT Group, LLC is seeking a data analytics professional to design, inspect, mine, transform, and model data to boost productivity and decision making within an engineering setting.

The role supports end-to-end data processing, collaborates with developers and data scientists, and focuses on SNC/TMS onboarding and supplier coordination to meet deployment timelines. Experience with Oracle, SQL, SQL Server and data quality is valued, with preferred exposure to EWI, SAP CAMS, and MES systems.

Qualifications

• 4–6 years of Oracle experience.
• 4–6 years of SQL experience.
• 4–6 years of SQL Server experience.
• 4–6 years of Data Analysis experience.
• 4–6 years of Data Cleansing techniques.
• 4–6 years of Data Management experience.
• 4–6 years of Data Quality Analysis experience.
• 4–6 years of Oracle Database Management experience.

Responsibilities

• Develops, inspects, mines, transforms, and models data to raise productivity and improve decision making.
• Manages end-to-end data processing and verifies data accuracy, liaising with business stakeholders.
• Collaborates with technical developers and data scientists to define outcomes and governance.
• Supports SNC/TMS onboarding and supplier coordination to meet deployment timelines.

Skills

Oracle

SQL

SQL Server

Data Analysis

Data Cleansing

Data Management

Data Quality

Oracle DB Management

Job description

Job Description

Develops, inspects, mines, transforms, and models data to raise productivity, improve decision making, and gain competitive advantage in an engineering setting. Conducts statistical analysis on data and information to ensure correct predictive forecasting or classification. Manages all aspects of end-to-end data processing utilizing customized report building functions of systems. Maintains analytical systems, verifies the accuracy of the data, and acts as liaison with business. Works with technical developers and data scientists to define business outcomes and govern capabilities. A focus on supply chain design and execution is necessary to mitigate the following: program delays, impaired customer / partner relations, inefficient Company operations, and compromised LM Aero competitive position. A supply chain professional is needed to execute and coordinate the on-boarding of the suppliers into the Supplier Network Collaboration (SNC) and Transportation Management System (TMS). The candidate will work within the defined process to ensure suppliers are meeting the time sensitive goals aligned with system deployment schedule. The position includes frequent supplier interactions including communicating the strategy and the tasks associated with SNC/TMS acceptance. Daily troubleshooting and supplier assistance related to SNC/TMS questions, on-boarding efforts and issues. Assist with status reports for leadership reviews. Assist in developing mechanisms for monitoring project progress and for intervention and problem solving with the project manager, suppliers and the internal customer. Manage and track supplier task completion, provide system access based on training completion, support team efforts to ensure security levels are completed and accurate. Knowledge of the supply chain management systems landscape and sourcing process a significant plus. The most desired skill sets include the ability to collaborate cross-functionally, build consensus, shape/influence opinion and articulate the future state. There will be a large focus on transforming and mapping data from one system to another.

Preferred: EWI and SAP CAMS experience.

Acceptable: MES (manufacturing execution system) experience.

SKILLS MATRIX: Required Experience

• Oracle Yes 4 - 6 Years
• SQL Yes 4 - 6 Years
• SQL Server Yes 4 - 6 Years
• Data Analysis Yes 4 - 6 Years
• Data Cleansing Techniques Yes 4 - 6 Years
• Data Management Yes 4 - 6 Years
• Data Quality Analysis Yes 4 - 6 Years
• Oracle Database Management Yes 4 - 6 Years