Data Engineer/Sr. Data Engineer – CASH ADS

Federal Reserve Bank (FRB)
Federal Reserve Bank (FRB)

Job Overview

Data Engineer/Sr. Data Engineer The Federal Reserve Bank of San Francisco is looking to add a Data Engineer/Sr. Data Engineer to our Cash ADS team. Our team is the IT engine that supports and builds the core IT systems for the Cash Product Office (CPO). CPO is responsible for the distribution of all cash and coin, across our nation. We are embarking on a huge and exciting new program called NextGen which will modernize and upgrade the hardware and software used to manage the cash supply chain across the entire Fed system. Do you desire work that truly impacts your community in a positive way? Do you also hunger for work life balance and exceptional benefits? Is so, this could be a fantastic opportunity for you! As our Data Engineer/Sr. Data Engineer, you will be responsible for the full software life cycle of our data warehouse application. This includes data design, database architecture, metadata and repository creation, identification and resolution of information flow, content issues, and transformation of business requirements, troubleshooting problems and tuning existing warehouse applications. Our ideal candidate has at least five years of DW development, and at least two years of Cloud development. We are also looking for someone who is highly customer focused, is able to drive for success in a matrixed environment and enable and emphasize teamwork. Your strong accountability, leadership, and innovation will be greatly leveraged on this high profile, top priority system-wide effort. Essential responsibilities: Develop software from user requirements using standard design patterns. Code, in the ETL tool, the extraction, transformation and loading of data from source systems to the data warehouse. Evaluate all code and ensure the quality of all project deliverables. Monitor and tune data loads and queries. Analyze large databases and recommend appropriate optimization. Requirements: Bachelor’s degree in Computer Science, Information Systems, or other related field or equivalent work experience is required. Data Engineer level typically requires five or more years data engineering, data science, or software engineering experience, including knowledge of large data ecosystems; Sr. Data Engineer typically requires seven or more years data engineering, data science, or software engineering experience, including knowledge of large data ecosystems. At Sr. level, experience leading architectural design discussions, obtaining consensus among stakeholders, and carrying those designs through deployment and into operations is also required. Deep technical expertise with Informatica is required for this role, including experience installing and/or upgrading Informatica. Advanced SQL and MS SQL Server DTS is required Data Modeling – Dimensional and Normalized Relational; SQL (MS SQL Server, Oracle, etc.). Minimum of one year AWS Cloud experience required; understanding of core AWS services, uses, and basic AWS architecture best practices. Ability to use a CI/CD pipeline to deploy applications on AWS (GitLab, terraform). Willing and able to travel up to 25% in future if required. Nice to have but not required: AWS certification(s). HTML, JavaScript, Python scripting. Spark, Hive, SQL and other Hadoop framework components. Flume-Kafka integration. Development/modeling experience with Amazon Redshift. Understanding of the use of containers in the development process. Proficiency writing code for serverless applications. Ability to use the AWS service APIs, AWS CLI, and SDKs to write applications. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. At the Federal Reserve Bank of San Francisco, we believe in the diversity of our people, ideas, and experiences and are committed to building an inclusive culture that is representative of the communities we serve. The Federal Reserve Bank of San Francisco is an Equal Opportunity Employer.Data Engineer/Sr. Data Engineer - CASH ADS 1

View More
Job Detail
Shortlist Never pay anyone for job application test or interview.