Senior Enterprise Data Warehouse Engineer - Rocklin, United States - First Tech Federal Credit Union

Description

The Senior EDW Data Engineer builds and maintains a data pipeline infrastructure for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL , cloud based relational or non-relational databases and employing Talend and/or scripting languages like Perl/Python.

Here's what you can expect from the job and what you need to be successful:

Job Duties

Lead analysis, design, development, and deployment of complex data platforms and pipelines across functional teams involving multiple integration and other technologies to meet committed deliverables
Partner and collaborate with business and IT stakeholders to deliver solutions to meet the business needs with quality and within the defined timeline
With minimal supervision, build and maintain complex data platforms and large scale CI/CD data pipelines utilizing a variety of technologies (REST APIs, TeamCity, Jenkins) and cloud databases (Snowflake)

Identify, design, and implement internal process improvements:
automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
Partner with data and analytics experts to strive for optimal functionality in our data integration platform
Collaborate on a day to day basis with business partners, architects and technical teams to identify, troubleshoot and resolve enterprise data warehouse issues
Resolve data issues by identifying multiple potential solutions and assessing them for both technical and business suitability, and work closely with all stakeholders (including technical peers and end users) to ensure technical compatibility and user satisfaction
Follow established best practices guidelines related to enterprise data warehouse configuration and change control processes
As a subject matter expert, mentor less experienced Data Engineers on a day to day basis
Conduct performance testing, tune and optimize data pipelines to meet the SLAs

Essential Skills

Minimum 6 years of developing data pipelines using Talend\Informatica and Python including the processing of NoSQL and JSON, XML formats, preferably in the financial services industry using Agile development process
Advanced working experience in SQL/PL-SQL, Snowflake, API
Excellent skills in scripting languages, including Python, Perl and Shell
Excellent skills with Ant, Maven, GIT, Jenkins, TeamCity
Excellent skills in source code repository tools such as Clear Case, SVN, CVS, and Gi.
Deep understanding of ETL, ELT, Talend, Informatica, Hadoop, data warehousing schema and Cloud platforms
Ability to work autonomously to manage time effectively and prioritize work appropriately to meet deadlines
Excellent problem solving and critical thinking skills
Strong business communication skills; able to write/speak clearly and professionally for a variety of audiences
Demonstrate independence, creativity, and initiative
Working knowledge of Microsoft Office Suite

Minimum Education:
Bachelor's degree in Information Technology, Computer Science or other related fields of study, or equivalent work experience

Certification/License:
Talend Certification is preferred

Location:
Hillsboro, OR 97124 | San Jose, CA 95134 | Rocklin, CA HYBRID)

Target Compensation in Hillsboro, OR:
$125k - $135k annually + annual bonus

Target Compensation in Rocklin, CA 95765: $137k - $148k annually + annual bonus

Target Compensation in San Jose, CA 95134: $156k - $169k annually + annual bonus


Benefits options include:
Traditional medical, dental, and vision coverage
401K matching up to 5% per pay period
Accrue up to 17 days of Paid Time Off your first year of employment
11 paid federal holidays
Special employee pricing on lending products such as mortgage, auto, and personal loans (eligibility for special employee pricing is subject to standard account requirements and underwriting criteria)

What makes First Tech different? Click

here

to learn more

First Tech is not currently offering Visa transfer/ sponsorship for this position

#J-18808-Ljbffr