Data Warehouse and BI Developer

Location

Charlotte, NC, US, 28216 Corning, NY, US, 14831

Corning

70760

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.

• 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)

• 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 Power
  
  BI 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.

• 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), Git Lab 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 OLAP 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.

• Structured Problem‑Solving Skills (Root Cause analysis).
• Experience using Agile project methodologies.
• Experience with Camstar or similar…