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
Click
here to apply!
|