A large new healthcare company is seeking a Data Engineer to join their team headquartered in Mission Viejo, CA. This individual will be responsible for the following:
* Work closely with Data Warehouse product owner and BSA to thoroughly understand the business user stories
* Work with the Data Architect to accurately interpret the data modeling and design the ETL data flow
* Develop ETL/ELT data pipeline flow to load data from various data sources to the staging database and apply complex business logic to populate normalized and denormalized data structure
* Write efficient and well-performed stored procedures to extract and transform the source data
* Build reusable components for a scalable data integration methodology such as error handling, logging, and recoverability
* Participate in the data modeling / schema design
* Perform and support query development and optimization
This position will be onsite 2 days a week at their Mission Viejo office.
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.