Sr. Software Quality Engineer

Job Req ID: 30461

About Supermicro:

Supermicro® is a Top Tier provider of advanced server, storage, and networking solutions for Data Center, Cloud Computing, Enterprise IT, Hadoop/ Big Data, Hyperscale, HPC and IoT/Embedded customers worldwide. We are the #5 fastest growing company among the Silicon Valley Top 50 technology firms. Our unprecedented global expansion has provided us with the opportunity to offer a large number of new positions to the technology community. We seek talented, passionate, and committed engineers, technologists, and business leaders to join us.
 

Essential Duties and Responsibilities:

1. ETL Pipeline Engineering and Operations (40%)
- Maintain and scale daily ETL/ELT pipelines using workflow or scheduling tools.
- Build extractors for manufacturing reports in multiple formats (Excel, CSV, email attachments, compressed archives).
- Implement incremental loads with idempotent transforms (deduplication, checkpoints, rerun-safe jobs).
- Optimize PostgreSQL batch ingestion (COPY / UPSERT) for large volumes with stable memory use.
- Monitor scheduled production runs; handle failures, alerting, and recovery.

2. Data Services, Analytics, and Reporting (25%)
- Maintain backend data APIs and services that power analytics dashboards and reports.
- Write and tune PostgreSQL queries (CTEs, window functions) for operational and analytical use cases.
- Support dashboard / reporting needs: KPI definition, trend analysis, and ad-hoc data requests.
- Standardize manufacturing metrics such as station yield, First Pass Yield (FPY), and repair turnaround time (TAT).
- Apply basic statistics or data science methods (e.g. anomaly detection, SPC-style quality tracking) where they improve insight.

3. Data Governance and Cross-site Communication (15%)
- Serve as the technical contact for data exchange with contract manufacturing sites.
- Align report formats, column schemas, and naming standards with site engineering teams.
- Improve data quality on incomplete or inconsistent fields (e.g. defect classification, part numbers).
- Manage master data versioning (e.g. BOM) and coordinate automated report collection.
- Investigate source-data issues: template changes, corrupted files, and encoding / formatting errors.

4. Database Administration and Warehousing (20%)
- Design and maintain warehouse layers: staging, ODS, DW, and application summary tables.
- Manage PostgreSQL schema changes, indexing, and routine database maintenance.
- Enforce role-based access control for ETL, BI, and administrative users.
- Maintain data quality checks, pipeline tests, and documentation.
- Own historical backfill procedures: backup, reset, reprocess, and verify.

Qualifications:

Required (Must-Have)

- Python 3: 2+ years hands-on experience; proficient in pandas, numpy, and related libraries for data processing and ETL.

- SQL and relational databases: strong PostgreSQL (or Oracle / MS SQL) skills, including CTEs, window functions, UPSERT, schema design, and indexing.

- Automated data pipelines: experience building and operating production ETL/ELT jobs with workflow or scheduling tools.

- Data quality: schema validation, deduplication, batch processing, and basic error handling / alerting.

- Version control: Git branching workflows and configuration management.

- Communication: able to discuss data requirements with engineering and operations teams in Chinese and English.

- Education: BS/MS in Computer Science, Information Management, Electrical Engineering, Statistics, Mathematics, or a related technical field.

Preferred (Nice-to-Have)

- Web / API backend development (e.g. Python web frameworks) and dashboard / reporting services.

- Data warehousing: staging / ODS / DW layers and aggregate summary tables.

- Analytics: exploratory analysis, KPI definition, and manufacturing or quality metrics (yield, FPY, TAT, SPC).

- Data science fundamentals: statistics, feature preparation, or basic machine learning for reporting and insight.

- Parsing semi-structured files (Excel, CSV, PDF, email attachments, archives).

- Deployment: Windows Server, task scheduling, or Docker.

- Interest in LLM / RAG applications on top of internal data platforms.

EEO Statement

Supermicro is an Equal Opportunity Employer and embraces diversity in our employee population. It is the policy of Supermicro to provide equal opportunity to all qualified applicants and employees without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status or special disabled veteran, marital status, pregnancy, genetic information, or any other legally protected status.