Data Engineer

Company: Pacific Western Bank
Location: Brea
Posted on: August 4, 2022

Job Description:

Overview:
The Data Engineer is responsible for coding data management processes including data preparation, Extract Transform Load (ETL), and unification of data from disparate source systems to Data Marts. - - -This individual will work cross functionally with various individuals within the IT team and business process owners to develop data processes from business specifications. - - -

Responsibilities:
Develops and maintains scalable data pipelines and builds out new integrations using Azure data factory, Azure pipeline, data flow, ETL tools and SQL technologies.Writes scripts, stored procedures and functions for database systems.Exporting Data and ingesting data from multiple disparate data streams from multiple input formats (DB, Flat Files, cloud) into a data lake.Assembling data into Data Marts for consumption by business. Exporting data interfacing with applications feedsWrites unit/integration tests, contributes to engineering wiki, and documents workPerforms data analysis required to troubleshoot data related issues and assist in the resolution of data issues.Works closely with a team of frontend and backend engineers, product managers, and analysts.Perform other duties as assigned.

Qualifications:
Required:Bachelor's Degree in Computer Science or related fieldMust have at least 2 years of experience in SQL and PL/SQL and coding ETL, pipelinesExperience in process design and documentationExperience in building data pipelines in cloud environment. Must have excellent analytical, interpersonal and communication skillsHands on experience on SQL and PL/SQLKnowledge to create data flow and pipelines in cloud environment.Ability to prioritize multiple projects and objectives in rapidly changing environmentMust be detail-oriented with organizational skillsMust be able to work in both a team and individual environment (i.e.: helpful, respectful, self-starter, willing to learn)Preferred: Hands on experience building data solutions in Azure and or other cloud environmentsPhysical Requirements:Role requires sitting or standing in front of a computer monitor for prolonged periods of time in a fixed neck position. Constant use of a computer or other office equipment resulting in repeating motions of the hands and wrists. Light work that may include moving objects up to 20 pounds.PWB is an EEO/AA/Disability/Vets Employer

Keywords: Pacific Western Bank, Fullerton , Data Engineer, Engineering , Brea, California