Share this Job

Sr. Business Intellegence Analyst

Apply now »

Date: Nov 25, 2020

Location: Hefei, 34, CN, 230011

Company: Corning

Requisition Number: 42174

 

Corning is one of the world’s leading innovators in materials science. For more than 160 years, Corning has applied its unparalleled expertise in specialty glass, ceramics, and optical physics to develop products that have created new industries and transformed people’s lives.

Corning succeeds through sustained investment in R&D, a unique combination of material and process innovation, and close collaboration with customers to solve tough technology challenges.

Purpose of the Position:

 

Collaborate with teams across the manufacturing and business operations to translate business needs to technical requirements. Acts as a technical Subject Matter Expert (SME) for business and manufacturing IT capabilities and helps to ensure successful delivery of IT capabilities and services.

 

Day to Day Responsibilities:

 

  • Responsible for analysis, design, development, implementation and maintenance of local reporting systems for the AGS manufacturing environment, will work closely with engineering, operations and business leaders to deliver expected manufacturing and business reports.
  • Function as both a Manufacturing reporting analyst and a MI technical support.
  • The person will become the expert for the MI database and reporting system as well as the data feeds to reporting systems.
  • Maintain close relationships with business personnel to understand changing business requirements and drive adoption to standard reporting practices.
  • Provide table, view, stored procedure design as needed for both SQL Server and Oracle databases.
  • Assist in the conversion of other reporting software to SSRS (SQL Server Reporting Services).
  • Create SSAS Cubes and data warehouse needed
  • Create and publish CAMSTAR / Power BI reports. Help maintain permissions to premium workspaces. Facilitate the transfer of high-level reporting systems to a Power BI platform.
  • Assist in SQL Server administration and performance enhancement

 

Education & Experience

  • Bachelor or above as Computer Science or IT application related
  • 5+ years of combined experience in manufacturing industry IT area, 2 years dedicated on reporting
  • Digital / MES / CAMSTAR system experience will be a plus

 

Required Skills

  • Good at creating various functional reports and strong sense on big data analysis with popular reporting tools
  • Experience using Microsoft SQL Server Business Intelligence Development Studio and Power BI
  • Experience in developing manufacturing data extraction packages / reports / analysis cubes using SSIS.
  • Strong Back End development skills and knowledge of relational databases (Oracle, Microsoft SQL Server, or others)
  • Good Database development experience for both OLTP & OLAP Systems

 

We prohibit discrimination on the basis of  race, color, gender, age, religion, national origin, sexual orientation, gender identity or expression, disability, or veteran status or any other legally protected status.

We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.