Share this Job

IT Solutions Architect, Manufacturing Data Warehouse, Reporting & Analytics

Apply now »

Date: Feb 10, 2021

Location: Charlotte, NC, US, 28216

Company: Corning

Requisition Number: 43498

 

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.

The global Information Technology (IT) Function is leading efforts to align IT and Business Strategy, leverage IT investments, and optimize end to end business processes and associated information integration technologies.  Through these efforts, IT helps to improve the competitive position of Corning's businesses through IT enabled processes.  IT also delivers Information Technology applications, infrastructure, and project services in a cost efficient manner to Corning worldwide.

Overview: Data Warehouse Solution Architect will be a key member of the Manufacturing Analytics & Reporting team collaborating with the stakeholders to translate business data requirement into solutions that integrate data from multiple plant floor systems into data warehouses. This role requires extensive knowledge of data warehousing principles with ability to build out solutions encompassing all phases of the data warehouse/Business Intelligence development lifecycle from strategic planning, requirements gathering, ETL design, development of solution to production deployment and support. Role also requires establishing and developing best practices to scale solutions to multiple manufacturing facilities.

Responsibilities:

  • Be able to serve as lead designer and developer for all ETL activities and BI solutions
  • Collaborate with stakeholders to identify, create, and deliver solutions according to business requirements
  • Design and support development efforts to produce integrated, near-real-time data warehouse solutions. Assist ongoing development of technical best practices for data movement, data quality, data cleansing and other ETL related activities
  • Define metadata governance and best practices to ensure accuracy, validity, reusability and consistency of the data warehouse
  • Create and maintain data models; Identify/Detect data discrepancies and data quality issues and provide solutions
  • Define solution architectures, design standards, and quality assurance policies and procedures.
  • Collaborate and influence members of the team to adopt best practices established
  • Work closely with project team to ensure that the end to end design and delivered solution meets business and data requirements and performance around user experience
  • Create Dashboard and visualization using BI tools
  • Develop and support unit and integration test activities and assist with User Acceptance Testing
  • Document all technical and system specifications for ETL and Data Warehouse processes
  • Partner with DBAs to continually fine tune solutions and put appropriate monitoring in place to ensure quality, reliability and performance of solutions in place
  • Willing to be on off hours call on a rotational basis

Education & Experience:

  • BS/MS degree preferably in Information Management, Computer Science, Engineering or other related fields
  • 10+ years of designing, developing, and implementing ETL and Data Warehouse solutions
  • 5+ years of experience working with manufacturing execution systems, inspection and metrology systems
  • Hands on experience working with large scale data and analytics systems
  • Hands on experience with SQL, reporting and BI systems such as PowerBI, Qlik or Tableau
  • Hand on experience with ETL tools e.g. SSIS
  • Strong experience with development in Microsoft BI tools (SSRS, SSAS, SSIS, SQL Server)
  • Technical expertise in data warehousing, data models, and database design

Other Qualifications

  • Programming experience with a high-level language such as Python, Java or equivalent
  • Experience with Big Data Platform and framework like Hadoop, Spark etc.
  • Strong relationship building, technical collaboration and communication skills
  • Proven success working in highly matrix environment
  • Excellent analytical and decision-making abilities
  • Must demonstrate a proven willingness to go the extra mile, to take on the things that need to be done and maintain a positive attitude that can adapt to change.
  • Strong leadership and excellent verbal and written communications skills, with the ability to develop and sell ideas

 

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.


Nearest Major Market: Charlotte