Data Warehouse and BI Developer

Requisition Number: 70760

The company built on breakthroughs. ​  
Join us.​    

Corning is one of the world’s leading innovators in glass, ceramic, and materials science. From the depths of the ocean to the farthest reaches of space, our technologies push the boundaries of what’s possible.  ​  

How do we do this? With our people. They break through limitations and expectations – not once in a career, but every day. They help move our company, and the world, forward. ​  

​At Corning, there are endless possibilities for making an impact. You can help connect the unconnected, drive the future of automobiles, transform at-home entertainment, and ensure the delivery of lifesaving medicines. And so much more.​   

​Come break through with us.  

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.

Role Purpose

• Candidate will be supporting Corning’s manufacturing environment. In this capacity, candidate will work closely with engineering, operations and business leaders to enable Corning’s manufacturing Divisions with data availability and analytics needs.
• Foster close relationships with business personnel and development team to understand changing business requirements and drive adoption to standard reporting practices.
• This is a hands-on position where the qualified candidate will be responsible for developing solutions that encompass all phases of the Data Warehouse/Business Intelligence development lifecycle (from requirements gathering, design, testing, implementation, and support)

Key Responsibilities

• Develop high-quality data warehouse and reporting solutions.
• Use T-SQL to develop and implement procedures and functions.
• Review and interpret ongoing business requirements and deliver solutions to meet those requirements.
• Research, analyze and troubleshoot data, stored procedures, and associated SSRS or PowerBI reports.
• Work with the DBA team to analyze server health, database performance, existing SQL queries for performance improvements; Suggest new queries or indexes where appropriate. 
• Develop procedures and scripts for data migration.
• Design and implement ETL procedures for intake of data from various manufacturing systems.
• Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization.
• Ensure all data warehouse architecture codes are maintained in a version control system.

Required Skills & Experience

• Possess Bachelor’s degree in an analytical related field, including information technology, science, or engineering discipline
• 5+ years’ experience developing DWH, and business intelligence solutions using SDLC process
• In-depth knowledge of industry best practices in DWH, business intelligence approaches and techniques
• Experience with relational databases in Microsoft SQL Server and Oracle.
• 5+ years’ experience with development in Microsoft BI tools (SSRS, SSAS, SSIS, SQL Server)
• Understanding of Cubes and complex data / information reporting models.
• Experience using Microsoft Team Foundation Server (TFS), GitLab or similar for source control.
• Experience in development of DWH, ETL, and end user facing Reports and Business Intelligence Dashboards (Power BI or Equivalent).
• Clear understanding and design goals of OLTP and OALP systems.
• Experience in Manufacturing factory floor processes and systems such as Manufacturing Execution System (MES), Equipment Management Systems (CMMS), Process Control Systems (SPC/OSI PI) and their underlying data model.
• Willing to work hours that are required for global support and/or to meet project timelines.
   

Desired Skills & Experience

• Structured Problem-Solving Skills (Root Cause analysis).
• Experience using Agile project methodologies.
• Experience with Camstar or similar MES (Manufacturing Execution System).
• Strong Analytical Skills.
• Self-discipline and motivation.
• Collaborate with multiple teams across multiple regions.
• Process oriented and customer focused.
• Must be able to clearly and effectively communicate with engineers, production associates, managers and business leaders.    

This position does not support immigration sponsorship.  

The range for this position is $106,089.00 - $145,873.00 assuming full time status. Starting pay for the successful applicant is dependent on a variety of job-related factors, including but not limited to geographic location, market demands, experience, training, and education. The benefits available for this position are dependent on hours worked and may include medical, dental, vision, 401(k) plan, pension plan, life insurance coverage, disability benefits, and PTO.

A job that shapes a life.  

Corning offers you the total package.  

Your well-being is our priority. Our compensation and benefits package supports your health and wellness, financial, and career from day one

• As part of our commitment to your financial well-being, we provide a 100% company-paid pension benefit that grows throughout your career.  We also offer a 401(k) savings plan with company matching contributions.  
• Our health and well-being benefits include medical, dental, vision, paid parental leave, family building support, fitness, company-paid life insurance, disability, and disease management programs. 
• Company-wide bonuses and long-term incentives, align with key business results and ensure you are rewarded when the company performs well – when Corning wins, we all win.     
• Getting paid for our work is important but feeling appreciated and recognized for those contributions motivates us much more. That’s why Corning offers a peer-to-peer recognition program to celebrate success by recognizing colleagues who demonstrate above-and-beyond behaviors.  

We prohibit discrimination on the basis of race, color, gender, age, religion, national origin, sexual orientation, gender identity or expression, disability, 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. To request an accommodation, please contact us at accommodations@corning.com.