16 days old

Senior Data Architect

Federal Reserve Bank (FRB)
St Louis, MO 63103
  • Job Code
    266370

The St Louis Fed is one of 12 Reserve Banks serving all or parts of Missouri, Illinois, Indiana, Kentucky, Tennessee, Mississippi and Arkansas with branches in Little Rock, Louisville and Memphis. The St. Louis Fed's most essential responsibilities include: promoting stable prices and economic growth, fostering a sound financial system, providing payment services to financial institutions, supporting the U.S. Treasury's financial operations, and advancing economic education, community development and fair access to credit.


Overview

Treasury Technology Services (TTS) is the embedded information technology organization for the Treasury Division at FRB St. Louis. TTS develops and supports applications ranging from off-the-shelf cash management packages to enterprise-level custom accounting systems. TTS is made up of two organizations: Engineering and Shared Services. The Engineering team consists of several application development teams, each of which are dedicated to specific Treasury business lines. The Shared Services team consists of the Project Management Office, the Architecture Office, the Data Management team, and the DevOps teams.

TTS is looking for a Senior Data Architect to lead efficient database release deliverables into all development, test and production environments. As our Senior Data Architect, reporting to a Senior Manager, you will support a team to assure the database release, along with its associated software, satisfies the requirements of our customer for systems that are essential to the infrastructure of the Department of the Treasury. You also will design well coded database objects such as stored procedures, Oracle packages, functions, and views, and database PL/SQL scripts used for data migration, fixes, transformations and test data generation; and, test and maintain database release code throughout the project's Software Development Life Cycle.


Responsibilities

  • Translate business functions into conceptual, logical and physical data models.
    • Build data mappings for new systems and data migration projects. Implement subject area of business functions and publish the models for collaborative development.
  • Analyze databases in different aspects such as data integrity, technical debt, data model, security (DAR), availability and performance.
    • Work with stake holders to create a technology roadmap to fix the findings.
  • Lead strategic projects to design and implement analytics platforms.
    • Provide expertise in centralized and distributed data engineering solutions. Capture and share best practices across data systems.
  • Design distributed database solutions in AWS such as Elastic Map Reduce (EMR), Redshift, Kinesis, Amazon Machine Learning, Amazon Web Services Lambda, Data Pipeline, AWS Informatica, Casandra, S3, and the Relational Database Service (RDS)
  • Develop strategies, plan and work with technical team to implement DAR (Data Security at rest). Publish best practices and data dictionary.
  • Incubate and influence innovative technologies to solve complex database and data processing issues that would change the enterprise data management and contribute to business. Have experience in essential technologies, methodologies and run POC's
  • Support the data needs of multiple teams, systems and products.
  • Manage expectations of software delivery with stake holders, resource planning, effort estimation and guide the data projects for technically sound solutions. Build networking and relationships.






Posted: 2021-01-05 Expires: 2021-02-03
Sponsored by:
ADP Logo
Sponsored by:
Bank of America Logo

Featured Jobs[ View All ]

Featured Employers

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Senior Data Architect

Federal Reserve Bank (FRB)
St Louis, MO 63103

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast