Sr/Data Engineer - Cloud

Company

Federal Reserve Bank of San Francisco

We are the Federal Reserve Bank of San Francisco—public servants with a mission to advance the nation’s monetary, financial, and payment systems to build a stronger economy for all Americans. We are a community-engaged bank, and are committed to understanding and serving the vibrant, expansive communities of the Twelfth District. That means we seek and appreciate new perspectives. We respect people for what they do and for who they are. We build opportunities to learn and grow. When you join the SF Fed, you become part of a diverse team united in its purpose to promote an economy that works for everyone.

The Federal Reserve Bank of San Francisco is looking for a Cloud Data Engineer to join the Data and Analytics Service (DAS) Team. We are a team based out of San Francisco that partners with business lines across the Federal Reserve System to deliver the cloud + big data solutions and advanced analytics products.

The successful candidate will design, implement, and manage cloud-based data solutions, ensuring scalable, secure, and repeatable data pipelines. The ideal candidate will have a strong background in data engineering, cloud infrastructure, scripting languages, and excellent analytical and communication skills.

Essential Responsibilities

• Contributes to the design, development, testing, implementation, and review of complex data warehouse and business intelligence solutions

• Develops all or part of complex data warehouse applications, develops software from established requirements, builds reports and dashboards, plans and coordinates work of lower-level programmers to meet delivery commitments, creates prototypes; offers insight on the feasibility of system designs

• Contributes to the design of technology infrastructure and configurations, recommends process improvements

• Reviews complex patches and new versions of data applications. Implements complex software packages and deploys code

• Key participant in cross-functional team initiatives and process improvement projects

• May require on-call status

• Excellent writing skills for writing user and system documentation

Qualifications:

• Bachelor’s degree in computer science, Information technology or equivalent work experience

• As a Data Engineer 5+ years data engineering, data science, or software engineering experience, including knowledge of Big Data ecosystem is required and as a Sr. Data Engineer 7+ years data engineering, data science, or software engineering experience, including knowledge of Big Data ecosystem is required.

• Expert in developing and analyzing complex SQL on a variety of RDBMS (Microsoft SQL Server, PostGre SQL)

• Experience with ETL tools

• Should be familiar with Microsoft solution, such as C#, SharePoint, etc.

• Ability to create quality ERD’s (entity-relationship diagrams)

• Expert knowledge of data modeling and understanding of different data structures and their benefits and limitations under particular use cases

• Experience using core AWS services to build and support data warehouse solutions leveraging AWS architecture best practices (S3, DMS, Glue, Lambda)

• Experience using the AWS service APIs, AWS CLI, and SDKs to build applications

• Proficiency in developing, deploying, and debugging cloud-based applications using AWS

• Ability to use a CI/CD pipeline to deploy applications on AWS (GitLab, Terraform, DBMaestro)

• Ability to apply a basic understanding of cloud-native applications to write code

• Ability to author, maintain, and debug code modules on AWS

• Experience creating scripts with Python

Preferred Qualifications:

• Ability to write code using AWS security best practices (e.g., not using secret and access keys in the code, instead using IAM roles)

• Experience with visualization tools (Tableau)

• Experience working on an Agile team

• Understanding of application lifecycle management

• Understanding of the use of containers in the development process

• Development/modeling experience with Amazon Redshift

Base Salary Range Data Engineer: Min: $113,600 - Mid: $147,600 - Max: $181,600 (Location: San Francisco)

Base Salary Range Sr. Data Engineer: Min: $138,900 - Mid: $180,400 - Max: $221,900 (Location: San Francisco)

Final salary and offer will be determined by the applicant’s background, experience, skills, internal equity, and alignment with geographic and other market data.

We offer a wonderful benefits