Data Warehouse and BI Developer Job at Corning Incorporated, Charlotte, NC

aUg3ZU1JL0pzR2JxdWt3ZFhKZFR1N2w3bXc9PQ==
  • Corning Incorporated
  • Charlotte, NC

Job Description

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 .

Job Tags

Full time, Worldwide,

Similar Jobs

MB Motors

Cashier Job at MB Motors

 ...Gas Station & Convenience Store Attendant MB FoodMart LLC Ferndale, Wa. About Us MB FoodMart LLC fuel service provider dedicated to delivering exceptional customer service and maintaining a clean, safe, and welcoming environment for all customers. We take pride in... 

Black & Veatch Family of Companies

Engineering Technician Intern Job at Black & Veatch Family of Companies

 ...Job Summary As a Summer Intern at Black & Veatch in Overland Park, KS, you will play...  ...critical infrastructure challenges. This internship offers the opportunity to contribute to...  ...year Engineering Technology program. No experience required. All applicants must be able to... 

Bayer

Lead Data Engineer Job at Bayer

 ...and meaningful career in a community of brilliant and diverse minds to make a real difference, there's only one choice.****Lead Data Engineer**Lead Data Engineer for Chicago, IL to develop models & create infrastructure to test automation and digital products;... 

Envirosafe Tanks

Industrial Maintenance Technician Job at Envirosafe Tanks

4 Day Work Week Join our team as an Industrial Maintenance Technician , where you will play a crucial role in maintaining the smooth...  ...wiring preferred. Working Environment/Physical Activities Outdoor and indoor environments, moderate to loud noise levels.... 

CHCP

Medical Assistant Externship Coordinator Job at CHCP

 ...Job Title: Medical Assistant Externship Coordinator Location: Austin, TX Employment Type: Full-Time Position Summary: Are you passionate about student success and building meaningful partnerships within the medical community? Join our team at [Institution Name...