Solution Architect Engineer

Requisition Number: 62616

Corning is vital to progress – in the industries we help shape and in the world we share.

We invent life-changing technologies using materials science. Our scientific and manufacturing expertise, boundless curiosity, and commitment to purposeful invention place us at the center of the way the world interacts, works, learns, and lives.

Our sustained investment in research, development, and invention means we’re always ready to solve the toughest challenges alongside our customers. 

Our Optical Communications segment has recently evolved from being a manufacturer of optical fiber and cable, hardware and equipment to being a comprehensive provider of industry-leading optical solutions across the broader communications industry.This segment is classified into two main product groupings – carrier network and enterprise network. The carrier network product group consists primarily of products and solutions for optical-based communications infrastructure for services such as video, data and voice communications. The enterprise network product group consists primarily of optical-based communication networks sold to businesses, governments and individuals for their own use.

Overview

DWH Solution Architect will be a key member of the Manufacturing Analytics & Reporting team collaborating with key stakeholders to translate business data requirements 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.
• Foster close relationships with business personnel and development team to understand changing business requirements and drive adoption of 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
• Collaborating with other teams such as DBAs to continually fine tune solutions and put appropriate monitoring in place to ensure quality, reliability and performance

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)
• Strong experience with Cloud Based Technologies (Microsoft Azure, Databricks)
• Technical expertise in data warehousing, data models, and database design

Corning Puts YOU First!

We are committed to supporting your health, financial, career development, and life goals as you grow professionally and personally to achieve your highest potential. All benefits begin as soon as you start your career at Corning.

• Our monetary peer-to-peer recognition program is tied to our Values and celebrates you and your colleagues’ contributions.
• Health and well-being benefits include medical, dental, vision, paid parental leave, mental health/substance use, fitness, and disease management programs.   
• Companywide bonus and attractive short- and long-term compensation programs are available based on your role and responsibilities.  
• Professional development programs help you grow and achieve your career goals.

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. To request an accommodation, please contact us at accommodations@corning.com.