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.
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
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
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 package including Medical, Dental, Vision, Pre-tax Flexible Spending Account, Backup Childcare Program, Pre-Tax Day Care Flexible Spending Account, Paid Family Care Leave, Vacation Days, Sick Days, Paid Holidays, Pet Insurance, Matching 401(k), and Retirement/Pension.
We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, perform essential job functions, and receive other benefits and privileges of employment. The SF Fed is an Equal Opportunity Employer.
The Federal Reserve Banks believe that diversity and inclusion among our employees is critical to our success as an organization, and we seek to recruit, develop and retain the most talented people from a diverse candidate pool. The Federal Reserve Banks are committed to equal employment opportunity for employees and job applicants in compliance with applicable law and to an environment where employees are valued for their differences.
Always verify and apply to jobs on Federal Reserve System Careers (https://rb.wd5.myworkdayjobs.com/FRS) or through verified Federal Reserve Bank social media channels.