IT Data Analyst

Integrated Resources, Inc; City of Corning (NY); On-site; USD 80,000 - 120,000; Full time

Job summary

Integrated Resources Inc. seeks a key member for their Applied Advanced Analytics team. The role involves collaborating with data scientists and engineers to develop systems that extract insights from data, focusing on ETL processes, data mapping, and impactful data visualization. The ideal candidate will have strong .Net programming skills and experience with various database technologies.

Qualifications

• 2-5 years of experience in data-related roles.
• Strong programming skills in .Net technologies and scripting languages.
• Database experience with Oracle and Microsoft SQL Server.

Responsibilities

• Build and utilize data systems for analytical needs.
• Develop technical specifications and process documentation.
• Create data visualization solutions.

Skills

.Net technologies

Python

R

C++

Data analysis

ETL techniques

Education

BS in Computer Science

MS or commensurate experience

Tools

AWS

Hadoop

Spark

Oracle

Microsoft SQL Server

Job description

Integrated Resources, Inc., is led by a seasoned team with combined decades in the industry. We deliver strategic workforce solutions that help you manage your talent and business more efficiently and effectively. Since launching in 1996, IRI has attracted, assembled and retained key employees who are experts in their fields. This has helped us expand into new sectors and steadily grow.

Job Description

Job Description

In this role you will be a key member in the newly formed Applied Advanced Analytics team. The successful candidate will collaborate with data scientist and engineers to implement sophisticated systems and techniques to uncover hidden value in our data assets. Newly discovered insights will drive our manufacturing processes and provide feedback to our manufacturing information and analytics applications. You will be able to listen, observe and understand the true needs, be process curious, technically savvy, and have an overwhelming desire to provide impactful and useful solutions. The successful candidate will have a strong desire to stay technically relevant and be a technical subject matter expert in data-related planning, storage, extraction and transformation of data in traditional and evolving systems.

Day to Day Responsibilities:

· Build and utilize data systems that enable analytical needs.

· Development of technical best practices for data mapping, data transformations, data quality, data cleansing, ETL and other data movement related activities.

· Develop and document technical specification for the flow of data to and from our integrated manufacturing systems and other disparate data feeds.

· Improve efficiencies of the data loads and reconciliation of data across a wide range of time series and relational data sources.

· Design and develop high performance ETL code/processes to load data from various sources ranging from single point measurements to cloud based solutions.

· Create data visualization solutions.

Required Education:

· BS Computer Science or Software Engineering. Ideally, candidate will have MS or commensurate experience.

Required Years and Area of Experience:

· 2-5 years

Required Skills:

· Strong programming skill in .Net technologies and scripting languages such as python, R and C++.

· Knowledge and hands on experience working with data in multiple formats such as XML, CSV, Flat files and databases.

· Strong interest in relational databases and data analysis.

· Database experience with Oracle and Microsoft SQL Server

· Experience in technical application of ETL projects (Scoping, Requirements, Design, Development and Deployment).

· Experience interacting with various levels of the organization.

· Experience in following a structured software development process.

· Ability to create and present project related material in front of the Customer/Receiver

· Demonstrate experience designing, building datasets and processes using cloud-based storage and analysis platforms, AWS, Hadoop and Spark

· Ability to communicate with the Customer both from an Engineering and I/T requirements perspective

Desired Skills:

· Experience with Big Data technologies

· Strong desire to grow this area and see it succeed. Willing to provide customers direction and be able to “sell” our solutions.

· Must be able to communicate effectively and with an ear for the customer’s true needs. Must be coachable.

· Must be a team player (and resolve issues in consultation with other team members)

Manager Must Haves:

· Strong programming skill in .Net technologies and scripting languages such as python, R and C++.

· Database experience with Oracle and Microsoft SQL Server

· Experience in technical application of ETL projects (Scoping, Requirements, Design, Development and Deployment).

Qualifications

Required Education:

· BS Computer Science or Software Engineering. Ideally, candidate will have MS or commensurate experience.

Required Years and Area of Experience:

· 2-5 years

Manager Must Haves:

· Strong programming skill in .Net technologies and scripting languages such as python, R and C++.

· Database experience with Oracle and Microsoft SQL Server

· Experience in technical application of ETL projects (Scoping, Requirements, Design, Development and Deployment).