Data Engineer

    • Job Tracking ID: 512170-594409
    • Job Location: Fremont, CA
    • Job Level: Mid Career (2+ years)
    • Level of Education: BA/BS
    • Job Type: Full-Time/Regular
    • Date Updated: January 09, 2018
    • Years of Experience: 5 - 7 Years
    • Starting Date: ASAP
    • Job Type: Exempt
Invite a friend
facebook LinkedIn Twitter Email


Job Description:

About Soraa

Soraa makes premier LED lighting solutions based around crystal-perfect GaN on GaN technology. We are completely vertically integrated and our data warehouse is the glue which ties together manufacturing and production test data. We’re currently running over 15M transactions per week (and expect to double over the next 12 months).

Responsibilities

The ideal candidate will help maintain & improve our data warehouse. Suggest and implement processes and systems to ensure that our data warehouse is consistent and up-to-date across all business units. Coordinate data accumulation from a large variety of sources (in-house and worldwide contract manufacturers). Own the integrity and quality of information stored in the data warehouse. Work with data producers to close data gaps in a timely manner. Create & maintain automation and queries as needed to support business units across the organization. Primary MS-SQL (SSIS w/ some python & matlab), but will interact with our MES system (Oracle - Application Express). Use Ignite DBA for performance analysis.

Experience and Skills:

Qualifications

  • 5+ years as data engineer, DBA, software engineer or similar role
  • B.S. in Computer Science or related Engineering field
  • Expertise in relational databases, data structures and query methodologies
  • Expertise in creating and maintain automated data pipelines via custom scripts or other workflow systems
  • Experience in high-tech manufacturing is a plus
  • Experience with heterogeneous server/database environments is a plus
  • Expertise in any of the following is a plus:  Microsoft SQL Server 2008+, SQL Server Integration Services (SSIS), Oracle Database 11/12, Oracle Application Express, Postgres, NoSQL, C#, Python, Java, Matlab
  • Experience with deploying and maintaining data analytics and reporting platforms is a plus
  • Experience in Linux operating systems and open source software deployment is a plus
  • Self-motivated and willing to assume ownership of projects
  • Strong communication skills (English required; Mandarin is a plus)