Data Engineer II

At Thorlabs, we design and manufacture components, instruments, and systems that transform the world by identifying, enabling, and accelerating key photonics (i.e., light-based) technologies. The Data Engineer builds, maintains, and improves reliable data pipelines and models that power analytics, reporting, and data-driven decision-making at Thorlabs.

Requirements

• Develop and maintain ELT/ETL pipelines (Synapse Pipelines, Data Factory, SQL, notebooks) moving data from D365 into ADLS and Synapse
• Write efficient SQL (joins, views, CTEs, window functions) and basic PySpark/Python to transform and model data for analytics and certified datasets
• Implement and monitor data quality checks
• Maintain metadata, lineage, and clear documentation for tables, transformations, business rules, and dataset logic
• Use Git and Azure DevOps for version control, code reviews, task management, and release coordination

Benefits

• Medical insurance
• Dental insurance
• Vision insurance
• Company paid life insurance
• PTO package
• 401(k) plan
• Tuition reimbursement

Tagged as: Data Analysis, SQL