IT Data Analyst
At a glance
Mid-level Data Analysis & BI role at Integrated Resources INC. Corning · contract.
Pay not stated Data Analyst salary
dataroles summary, based on the employer's posting.
What you'll do
- Build data systems that support analysis and set practices for mapping, cleaning, transforming and moving data
- Document how data moves between manufacturing systems and separate data feeds
- Make data loading and reconciliation more efficient across time-series and relational sources
- Develop ETL processes for data from individual measurements through cloud-based sources
- Create visualizations that make analytical findings usable
What you bring
- A computer science or software engineering degree, with a master's degree or equivalent experience preferred
- Two to five years of experience, with strong .NET and scripting skills in Python, R or C++
- Hands-on Oracle and Microsoft SQL Server experience, plus practical delivery of ETL projects from scoping through deployment
Who this fits
This mid-level contract role suits someone who can work with data scientists and engineers and turn manufacturing data needs into technical solutions. The position is onsite in Corning.
From the employer
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
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
· MDX Queries, SSIS, Historian Databases
· 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).
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).
Kind Regards,
Pramod Kumar
Technical Recruiter
Integrated Resources, Inc.
DIRECT # - 732-844-8730