Company

Federal Reserve Bank of St. Louis

When you join the Federal Reservethe nation's central bankyou'll play a key role, collaborating with leading tech professionals to strengthen and protect our economic, financial and payments systems. We dedicate more than $1 billion to technology each year to support the Federal Reserve and our economy, and we're building a dynamic and diverse team for our future.

Overview
We are 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 DMO 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 stakeholders 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 stakeholders, resource planning, effort estimation and guide the data projects for technically sound solutions. Build networking and relationships.

Qualifications

Bachelor's degree with a major or specialized courses in Information Technology or commensurate experience
10+ years related experience in Oracle and Postgres including a combination of the following experience:
- Experience implementing big data solutions using cloud technologies
- Experience in creating complex data models for OLTP, Data Warehouse, logical Data warehouse applications
- Current knowledge building data models, data layer using data federation and master data management
- Experience with AWS cloud services: EC2, S3, RDS, Redshift, and CDK Toolkit.
- Experience using GitLab CI/CD pipelines
- Experience scripting with Python, TypeScript, and Shell
- Creative in identifying ways to reduce risks to avoid project delays
Travel (5%)
US Citizen
Candidates with less experience may be considered at a lower pay-range/job-grade
All Federal Reserve Bank of St. Louis employees must be fully vaccinated against COVID-19, including receiving a COVID-19 booster when eligible, unless the Bank grants an accommodation based on a medical condition or sincerely held religious belief.

Total Rewards

Bring your passion and expertise, and we'll provide the opportunities that will challenge you and propel your growthalong with a wide range of benefits and perks that support your health, wealth, and life.

Salary: $114,000 $155,000

In addition to competitive compensation, we offer a comprehensive benefits package that all brought together in a flexible work environment where you can truly find balance:

Generous paid time off
Tuition & Training assistance/reimbursement
401(k) match & Annuity/Pension fund
Top-notch health care benefits
Child and family care leave
Professional development opportunities
And more...

Ranked as the #2 Top Workplace in the St. Louis Region in 2020, the Federal Reserve Bank of St Louis is committed to building an inclusive workplace, where employees' diversityin age, gender, race and ethnicity, sexual orientation, gender identity or expression, disability, and cultural traditions, religion, life experiences, education and socioeconomic backgroundsare recognized as a strength. Learn more about the Bank and its culture; check out our Careers Site.

The Federal Reserve Bank of St Louis is an Equal Opportunity Employer.

Full Time / Part Time

Full time

Regular / Temporary

Regular

Job Exempt (Yes / No)

Yes

Job Category

Information Technology

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