Data Warehouse & BI Engineer

Corning Incorporated; Charlotte (NC); Presencial; USD 110 000 - 151 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Bonuses & incentives

401(k) matching

Comprehensive benefits

Resumo da oferta

Corning Incorporated is seeking a Data Warehouse & BI Engineer to lead the design, development, and delivery of data warehouse, reporting, and analytics solutions. You’ll own the full lifecycle from requirements to deployment, collaborating with manufacturing and IT teams to translate complex data into actionable insights.

The ideal candidate has 7+ years in DW/BI, strong SQL Server, SSRS/SSIS/SSAS, and Power BI experience, plus a track record of scalable analytics in a manufacturing environment.

Qualificações

• 7+ years in DW/BI design, develop, support.
• Experience with Microsoft BI stack (SQL Server, SSRS/SSIS/SSAS).
• Strong analytical and troubleshooting skills.

Responsabilidades

• Lead end-to-end delivery of DW, reporting, and analytics solutions, including requirements, design, development, testing, deployment, and support.
• Design and maintain data warehouse and BI solutions supporting manufacturing and enterprise priorities.
• Partner with business stakeholders and tech teams to understand requirements and deliver data capabilities.
• Develop and maintain T-SQL procedures, functions, queries, and scripts for data integration and reporting.
• Design, build, and support ETL processes for data ingestion and transformation.
• Research, analyze, and troubleshoot data issues, stored procedures, and reports (SSRS/Power BI).
• Collaborate with DBA team to optimize server health, DB performance, and queries; implement improvements.
• Develop data migration procedures for projects and operations; maintain SDLC versioning.

Conhecimentos

Power BI

SQL Server

SSRS

SSIS

SSAS

T-SQL

Data warehousing

Formação académica

BS in IT/CS/Engineering

Ferramentas

TFS

GitLab

Descrição da oferta de emprego

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.

Requisition Number: 78507The 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 Summary

The Data Warehouse & BI Engineer supports Corning’s manufacturing environment by leading the design, development, and delivery of data warehouse, reporting, and analytics solutions that drive operational visibility and business decision-making. This role is responsible for the full solution lifecycle, including requirements gathering, architecture and design, development, testing, deployment, and ongoing support. This is a hands-on role for a technically strong professional who can work across business and technology teams to translate complex requirements into scalable, reliable, and high-value solutions. The ideal candidate brings strong expertise in data warehousing, SQL development, ETL, and reporting, along with a passion for building data solutions that support manufacturing operations, improve performance, and enable informed decisions.

• Lead the end-to-end delivery of data warehouse, reporting, and analytics solutions, including requirements gathering, solution design, development, testing, implementation, and support.
• Design, develop, and maintain high-quality data warehouse and business intelligence solutions that support manufacturing and enterprise priorities.
• Partner with business stakeholders and technology teams to understand requirements, define solution approaches, and deliver impactful data and reporting capabilities.
• Develop and maintain T-SQL procedures, functions, queries, and scripts to support data integration, reporting, and analytics needs.
• Design, build, and support ETL processes for the intake and transformation of data from manufacturing and other enterprise systems.
• Research, analyze, and troubleshoot data issues, stored procedures, and associated SSRS or Power BI reports.
• Collaborate with the DBA team to assess server health, database performance, and query optimization opportunities; recommend and implement improvements such as indexing and query tuning.
• Develop and support data migration procedures and scripts as needed for project and operational initiatives.
• Contribute to the development and ongoing evolution of data warehouse architecture, ensuring solutions are scalable, maintainable, and aligned with best practices.
• Ensure data warehouse and analytics code is maintained in version control and developed in accordance with SDLC standards.
• Support operationally critical work and project timelines, including flexibility to work hours needed for global support when required.

Required Qualifications

• Bachelor’s degree in Information Technology, Computer Science, Engineering, or a related technical field.
• 7 years of experience designing, developing, and supporting Data Warehouse and Business Intelligence solutions.
• 7 years of experience with Microsoft BI technologies, including SQL Server, SSRS, SSIS, and SSAS.
• Strong experience with T-SQL development, including stored procedures, functions, performance tuning, and query optimization.
• Experience developing data warehouse, ETL, and end-user reporting solutions, including Power BI or similar dashboard/reporting tools.
• Strong analytical, problem-solving, and troubleshooting skills.
• Ability to work effectively with both technical and non-technical stakeholders and manage multiple priorities in a fast-paced environment.

Preferred Qualifications

• Experience using Agile project methodologies.
• Experience supporting manufacturing or factory floor systems and processes using tools such as Camstar, Siemens Opcenter or other Manufacturing Execution Systems such as MES, CMMS, SPC, and OSI PI, including knowledge of their underlying data models.
• Knowledge of industry best practices in data warehousing, business intelligence architecture, and analytics delivery.
• Experience working with relational databases in Microsoft SQL Server.
• Experience using MS Team Foundation Server (TFS), GitLab, or similar source control platforms.
• Understanding of cubes and complex reporting or information models.
• Clear understanding of OLTP and OLAP systems.
• Experience supporting analytics or reporting solutions in a regulated or operationally sensitive environment.

This position does not support immigration sponsorship. The range for this position is $110,133.00 - $151,433.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.

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 aspirations, and career from day one.

• 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.
• As part of our commitment to your financial well-being, we provide a 100% company-paid pension benefit with fixed contributions that grow throughout your career. Combined with matching contributions to your 401(k) savings plan, Corning’s total contributions to your retirement accounts can reach between 7% and 12% of your pay, depending on your age and years of service.
• Our health and well-being benefits include medical, dental, vision, paid parental leave, family building support, fitness, company-paid life insurance, disability, disease management programs, paid time off, and an Employee Assistance Program (EAP) to support you and your family.
• 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 recognition program to celebrate successes and reward colleagues who make exceptional contributions.

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 [e-mail].