Principal Data/Business Intelligence Engineer
COHERENT
A complete application in a minute — tailored resume and cover letter, ready to send.
Job summary
Coherent Corp. in Santa Clara invites a senior data engineering leader to drive the architecture and evolution of the enterprise data warehouse and analytics platforms that support global operations.
You will define data modeling standards, govern pipelines, and lead Snowflake/dbt implementations with automated testing, CI/CD, and scalable ETL/ELT processes while mentoring engineers and partnering with Finance, Supply Chain, Manufacturing, and IT.
Qualifications
- Minimum 9+ years of experience in enterprise data engineering, BI engineering, analytics engineering, or related disciplines.
- Minimum 8+ years of hands-on experience with Oracle E-Business Suite (EBS), enterprise data warehousing, and Snowflake development.
- Deep expertise in enterprise data architecture, dimensional modeling, data warehouse design, and large-scale analytical systems.
- Advanced proficiency in SQL, PL/SQL, SnowSQL, T-SQL, and performance optimization techniques for large-scale data platforms.
- Extensive experience designing and developing advanced stored procedures, orchestration frameworks, and scalable ELT/ETL pipelines.
- Strong experience building enterprise-grade Snowflake data warehouse solutions using dbt with automated testing, lineage tracking, CI/CD integration, and engineering best practices.
- Extensive experience with enterprise data integration tools and platforms such as SAP Data Services, SSIS, Informatica, Snowflake Openflow, Airflow, or Azure Data Factory.
- Strong understanding of enterprise business processes within high-tech manufacturing environments, including Finance, Supply Chain, Manufacturing, and Operations.
- Strong expertise in Oracle ERP functional modules and Oracle EBS technical architecture, including schema design, interfaces, and data structures.
- Proven ability to lead complex technical initiatives and influence architectural direction across multiple organizations.
- Demonstrated experience mentoring engineers and providing technical leadership within enterprise engineering teams.
- Bachelor’s degree in Computer Science, Computer Engineering, Information Systems, or related field.
Responsibilities
- Lead architecture, design, and evolution of enterprise data warehouse and analytics platforms.
- Define and implement data modeling standards, governance, and scalable analytics frameworks.
- Design and optimize Snowflake-based solutions with SQL, dbt, JS stored procedures, and data pipelines.
- Lead the development of scalable dimensional data models with automated testing, lineage tracking, and documentation.
- Drive data integration initiatives involving Oracle EBS, ERP, manufacturing systems, external APIs, and cloud data platforms.
- Serve as the technical authority for enterprise BI and analytics engineering, mentoring engineers.
- Partner with Finance, Supply Chain, Manufacturing, Operations, and IT to translate business objectives into scalable solutions.
- Lead architecture reviews, performance optimization, data quality, and scalability planning for analytics systems.
- Establish best practices for ETL/ELT, CI/CD, code quality, testing frameworks, and operational support.
- Evaluate emerging technologies and recommend improvements to data architecture and analytics capabilities.
- Lead cross-functional programs coordinating activities to ensure delivery.
- Drive improvements for data governance, metadata management, reliability, and observability.
- Participate in strategic planning for analytics capabilities and platform roadmaps.
Skills
Education
Tools
Job description
- Lead the architecture, design, and evolution of enterprise-scale data warehouse and analytics platforms supporting global business operations and strategic decision-making.
- Define and implement enterprise data modeling standards, governance practices, and scalable architectural frameworks for analytics and reporting solutions.
- Design and optimize Snowflake-based solutions, including advanced SQL development, dbt frameworks, JavaScript-based stored procedures, and data pipelines.
- Lead the development of scalable and maintainable dimensional data models, including staging, intermediate, semantic, and enterprise reporting layers with automated testing, lineage tracking, and documentation standards.
- Drive enterprise data integration initiatives involving Oracle E-Business Suite (EBS), ERP systems, manufacturing systems, external APIs, and cloud-based data platforms.
- Serve as the technical authority for enterprise BI and analytics engineering solutions, providing guidance and mentorship to engineers and cross-functional technical teams.
- Partner with business leaders and stakeholders across Finance, Supply Chain, Manufacturing, Operations, and IT to translate strategic business objectives into scalable technical solutions.
- Lead architecture reviews, performance optimization efforts, data quality initiatives, and enterprise scalability planning for mission-critical analytics systems.
- Establish best practices for ETL/ELT development, CI/CD deployment processes, code quality, testing frameworks, and operational support procedures.
- Evaluate emerging technologies and recommend improvements to enterprise data architecture, analytics platforms, and reporting capabilities.
- Lead complex cross-functional programs and coordinate technical activities across multiple teams to ensure successful delivery of enterprise initiatives.
- Drive continuous improvement initiatives for data governance, metadata management, reliability, observability, and operational excellence.
- Participate in strategic planning discussions related to enterprise analytics capabilities, data modernization efforts, and long-term platform roadmaps.
- Minimum 9+ years of experience in enterprise data engineering, BI engineering, analytics engineering, or related disciplines.
- Minimum 8+ years of hands-on experience with Oracle E-Business Suite (EBS), enterprise data warehousing, and Snowflake development.
- Deep expertise in enterprise data architecture, dimensional modeling, data warehouse design, and large-scale analytical systems.
- Advanced proficiency in SQL, PL/SQL, SnowSQL, T-SQL, and performance optimization techniques for large-scale data platforms.
- Extensive experience designing and developing advanced stored procedures, orchestration frameworks, and scalable ELT/ETL pipelines.
- Strong experience building enterprise-grade Snowflake data warehouse solutions using dbt with automated testing, lineage tracking, CI/CD integration, and engineering best practices.
- Extensive experience with enterprise data integration tools and platforms such as SAP Data Services, SSIS, Informatica, Snowflake Openflow, Airflow, or Azure Data Factory.
- Strong understanding of enterprise business processes within high-tech manufacturing environments, including Finance, Supply Chain, Manufacturing, and Operations.
- Strong expertise in Oracle ERP functional modules and Oracle EBS technical architecture, including schema design, interfaces, and data structures.
- Proven ability to lead complex technical initiatives and influence architectural direction across multiple organizations.
- Demonstrated experience mentoring engineers and providing technical leadership within enterprise engineering teams.
- Bachelor’s degree in Computer Science, Computer Engineering, Information Systems, or related field.
- Strong analytical and problem-solving capabilities
- Self-motivated and able to work independently in a fast-paced environment
- Excellent collaboration and communication skills
- Detail-oriented with a focus on quality and reliability
- Experience with Python for data ingestion, API integration, and automation
- Familiarity with workflow orchestration tools (Airflow, Azure Data Factory)
- Experience with BI tools such as Power BI, Tableau, or similar platforms
Hybrid work environment with collaboration across cross-functional teams
Fast-paced, project-driven workload with multiple concurrent priorities
Regular interaction with business stakeholders, data engineers, and leadership teams
Primarily computer-based work involving data analysis, dashboard development, and reporting
Participation in meetings, project planning sessions, and operational support activities
Standard business hours with occasional flexibility needed to support project deadlines and deliverables
- Prolonged periods of sitting and working on a computer
- Frequent use of hands and fingers for typing and data analysis tasks
- Ability to communicate effectively verbally and in writing
- Ability to view and interpret detailed data on computer screens for extended periods
- Occasionally move or lift office materials and equipment up to 15 pounds
- Ability to participate in virtual and in-person meetings and presentations
All employees are required to follow the site EHS procedures and Coherent Corp. Corporate EHS standards.
Depending on location, this position may be responsible for the execution and maintenance of the ISO 9000, 9001, 14001 and/or other applicable standards that may apply to the relevant roles and responsibilities within the Quality Management System and Environmental Management System.
Ensure adherence to company’s values (ICARE) in all aspects of your position at Coherent Corp.:
I ntegrity – Create an Environment of Trust
C ollaboration – Innovate Through the Sharing of Ideas
A ccountability – Own the Process and the Outcome
R espect – Recognize the Value in Everyone
E nthusiasm – Find a Sense of Purpose in Work
Coherent Corp. is an equal opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.
If you need assistance or an accommodation due to a disability, you may contact us at talentacquisition@coherent.com .
Coherent is a global leader in lasers, engineered materials and networking components. We are a vertically integrated manufacturing company that develops innovative products for diversified applications in the industrial, optical communications, military, life sciences, semiconductor equipment, and consumer markets. Coherent provides a comprehensive career development platform within an environment that challenges employees to perform at their best, while rewarding excellence and hard-work through a competitive compensation program. It's an exciting opportunity to work for a company that offers stability, longevity and growth. Come Join Us!
2012430
Bachelor's Degree
Full time
$141,563 - $195,875 per year
#LI-JF1
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
