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).
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.