This job has closed.

Corning Incorporated · 2 months ago

Data Warehouse and BI Developer

Charlotte, NC

Full-time

Onsite

Senior Level

$106K/yr - $146K/yr

5+ years exp

Corning Incorporated is one of the world’s leading innovators in glass, ceramic, and materials science. The Data Warehouse and BI Developer will support Corning’s manufacturing environment by developing high-quality data warehouse and reporting solutions while collaborating with engineering, operations, and business leaders to meet analytics needs.

Manufacturing

No H1B

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

Qualification

Data Warehouse DevelopmentBusiness Intelligence SolutionsMicrosoft BI ToolsETL ProceduresT-SQLRelational DatabasesSource Control SystemsManufacturing Systems KnowledgeStructured Problem-SolvingAgile MethodologiesAnalytical SkillsCollaboration SkillsCustomer FocusEffective Communication

Required

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