First Tech Federal Credit Union
Senior Enterprise Data Warehouse Engineer
First Tech Federal Credit Union, Rocklin, California, United States, 95765
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 95765 (HYBRID)
Target Compensation:Hillsboro, OR: $125k - $135k annually + annual bonusRocklin, CA: $137k - $148k annually + annual bonusSan Jose, CA: $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
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 95765 (HYBRID)
Target Compensation:Hillsboro, OR: $125k - $135k annually + annual bonusRocklin, CA: $137k - $148k annually + annual bonusSan Jose, CA: $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