Data Warehouse and BI Developer

Corning•Charlotte, NC

61d•$106,089 - $145,873

About The Position

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)

Requirements

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.

Nice To Haves

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.

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.
Willing to work hours that are required for global support and/or to meet project timelines.

Benefits

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.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume