Job Description:

Company

Federal Reserve Bank of San Francisco

The Data Engineer is responsible for developing, testing, implementing, debugging, and supporting computer software used to create data warehouse applications. 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.

We are looking for the Sr. Data Engineer to be customer focused, drive for success, put an emphasis on teamwork, effective communication, innovation and flexibility and adaptability. The Data Engineer is responsible for detailed technical design, development, and support of software applications using the AWS platform. They formulate concepts and develop solutions using defined user requirements and are able to interpret requirements and work with the customer to clarify requirements as needed.

They design, code, test, and document enhancements to existing systems of high complexity and scope, working with common application designs and specifications, utilizing industry and System standard procedures, products and methodologies, and execute performance and stress testing, as necessary.

RESPONSIBILITIES

• Conducts logical and physical database design


• Develops, tests, implements, and maintains database management applications including Big Data applications


• Constructs and implements operational data stores, data lakes. and data marts


• Translates user requirements into technical designs and implementations


• Ensures all automated processes preserve data by managing the alignment of data availability and integration processes


• Integrates data from one or more source systems into data repositories that are optimized for reporting and analytics


• Works with other development teams to review and approve database changes according to database design standards and principles


• Supports data and batch/real-time analytical solutions leveraging transformational technologies


• Works on one or more projects as a team member designing and developing software applications, testing, and building automation tools


• Designs key and indexing schemes and designs partitioning


• Implements security and recovery tools and techniques as required


• Creates a data catalog


• Resolves conflicts between models, ensuring that data models are consistent with the Bank’s enterprise

Qualifications:

• Bachelor’s degree in Computer Science, Information Systems, or other related field


• 7+ years data engineering, data science, or software engineering experience, including knowledge of AWS cloud technology


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


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


• Excellent writing skills for writing user and system documentation


• Understanding of core AWS services, uses, and basic AWS architecture best practices (S3, DMS, Glue, Lambda)


• Development/modeling experience with Amazon Redshift


• 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)


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


• Proficiency writing code for serverless applications


• Must be a U.S Citizen
   

#LI-Hybrid 

We offer a wonderful benefits package including: Medical, Dental, Vision, Pre-tax Flexible Spending Account, Backup Child Care Program, Pretax Day Care Flexible Spending Account, Vacation Days, Sick Days, Paid Holidays, Pet Insurance, Matching 401(k), and a Retirement / Pension
 

***Effective October 1, 2021, all employees must be fully vaccinated against COVID-19 or qualify for an accommodation from the Bank’s vaccination policy; the Bank will provide accommodations as required by law for individuals unable to be vaccinated due to medical condition or sincerely held religious belief.

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.

Full Time / Part Time

Full time

Regular / Temporary

Regular

Job Exempt (Yes / No)

Yes

Job Category

Analytical

Work Shift

First (United States of America)

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.

Privacy Notice

Salary: $170,000.00

Apply Now