Vacancy expired!
SQL ETL Data EngineerAbout the RoleKey responsibilities for the Data Engineer include:
- Write complex SQL queries to move data from various source systems (flat files, SQL Server databases, xls files, JSON files, etc.) into the Operational Data Store (ODS).
- Create reconciliation processes to ensure data is loaded into the ODS completely and accurately.
- Create error handling and logging processes in the ODS
- Implement performance and tuning activities in the ODS
- Work closely with the data modelers, data analysts, and QA team to ensure that the data is properly loaded into the ODS
- Exceptional analytical skills
- Knowledge of ODS concepts and best practices
- Strong oral and written communications skills
- Meticulous and detail-oriented
- Must be a problem solver, critical thinker, self-motivated and possess integrity and a strong work ethic
- Ability to work independently on concurrent tasks and adhere to deadlines
- Ability to easily adapt to changing priorities
- Ability to meet high expectations for precision and accuracy
- High degree of initiative and intellectual curiosity
- 5+ years' experience performing data engineering in a ODS environment
- 5+ years' experience in creating and modifying SSIS packages
- Experience with SQL Server upgrade would be very helpful
- Experience with Boomi would be highly desirable
- Deep knowledge of database structures, normalization, de-normalization and entity relationships
- Deep knowledge of ODS concepts, data loading issues and best practices
- Strong data manipulation and data analysis skills
- Ability to work both independently as well as a team
- Experience working in an Agile environment
- Experience in a financial services industry preferred
Vacancy expired!