Cloud Database Management Systems Engineer

13 Apr 2024

Vacancy expired!

Company Federal Reserve Bank of Richmond

The Richmond Fed is the proud home of the Federal Reserve's National IT organization-a nationwide team delivering technology solutions and support across the Federal Reserve System. Many National IT employees are located in Richmond, while others are based across the U.S. at other Federal locations.

When you join our team, you'll become part of a culture that welcomes differences, cares about our communities, and empowers each other to lead from where we are to make things better. Bring your passion and we'll provide challenging and purposeful careers in a variety of fields, opportunities to grow and a wide range of benefits and perks that support your health and wealth. It's all part of what makes #MyRichmondFed a great place to work!

About the Opportunity

The Enterprise Data Service has an immediate opening for a Cloud Data Engineer Advanced position reporting to Assistant Vice President.

The Federal Reserve System's cloud provides the centralized data and analytics platform housing advanced data management and analytics solutions for business lines in the Federal Reserve System. We work with state-of-the-art technologies that are part of the next generation data ecosystem, which includes services used for data storage, processing, integration, data lakes, warehousing, and data analytics.

A high-level goal of this position is to participate in engineering and product architecture. You will work cross-functionally with other architects, product managers, design engineers, developers, operations, and product owners in a rapidly evolving environment. As an Advanced Engineer, you will be accountable for secure and scalable designs that meet business needs.

As part of the National IT team, our cloud data service team works with multiple business lines, our Board, and IT groups from Federal Reserve System districts. You will have an opportunity to showcase your critical thinking and technical skills across many disciplines and across the Federal Reserve System. This role will be instrumental in shaping the direction of enterprise data.

What You Will Do:
  • Understand technology vision and strategic direction of business needs
  • Understand our current data model and infrastructure, proactively identify gaps, areas for improvement, and prescribe architectural recommendations with a focus on performance and accessibility.
  • Partner across engineering teams to design, build, and support the next generation of our analytics systems.
  • Partner with business and analytics teams to understand specific requirements for data systems to support both development and deployment of data workloads ranging from Tableau reports to ad hoc analyses.
  • Own and develop architecture supporting the translation of analytical questions into effective reports that drive business action.
  • Automate and optimize existing data processing workloads by recognizing patterns of data and technology usage and implementing solutions.
  • Solid grasp of the intersection between analytics and engineering while maintaining a proactive approach to assure solutions demonstrate high levels of performance, privacy, security, scalability, and reliability upon deployment.
  • Provide guidance to partners on effective use of the database management systems (DBMS) platform through collaboration, documentation, and associated standard methodologies.
  • Design and build end to end automation to support and maintain software currency
  • Create automation services for builds using Terraform, Python, and OS shell scripts.
  • Develop validation and certification process through automation tools
  • Design integrated solutions in alignment with design patterns, blueprints, guidelines, and standard methodologies for products
  • Participate in developing solutions by incorporating cloud native and 3rd party vendor products
  • Participate in research and perform POCs (proofs of concept) with emerging technologies and adopt industry best practices in the data space for advancing the cloud data platform.
  • Develop data streaming, migration and replication solutions
  • Demonstrate leadership, collaboration, exceptional communication, negotiation, strategic and influencing skills to gain consensus and produce the best solutions.
  • Engage with Senior leadership, business leaders at the Federal Reserve and the Board to share the business value.

Qualifications:
  • Demonstrates mutual respect, embraces diversity, and acts with authenticity
  • Bachelor's degree in Computer Science, Management Information Systems, Computer Engineering, or related field or equivalent work experience; advance degree preferred
  • Seven or more years of experience in designing and building large-scale solutions in an enterprise setting in both
  • Three years in designing and building solutions in the cloud
  • Expertise in building and managing Cloud databases such as AWS RDS, DynamoDB, DocumentDB or analogous architectures
  • Expertise in building Cloud Database Management Systems in Snowflake, Databricks Lakehouse or analogous architectures
  • Expertise in Cloud Data Warehouses in Redshift, BigQuery or analogous architectures a plus
  • Deep SQL expertise, data modeling, and experience with data governance in relational databases
  • Experience with the practical application of data warehousing concepts, methodologies, and frameworks using traditional (Vertica, Teradata, etc.) and current (SparkSQL, Hadoop, Kafka) distributed technologies
  • Refined skills using one or more scripting languages (e.g., Python, bash, etc.)
  • Experience using ETL/ELT tools and technologies such as Talend, Informatica a plus
  • Embrace data platform thinking, design and develop data pipelines keeping security, scale, uptime and reliability in mind
  • Expertise in relational and dimensional data modeling
  • UNIX admin and general server administration experience required
  • Presto, Hive, SparkSQL, Cassandra, or Solr other Big Data query and transformation experience a plus
  • Experience using Spark, Kafka, Hadoop, or similar distributed data technologies a plus
  • Able to expertly express the benefits and constraints of technology solutions to technology partners, business partners, and team members
  • Experience with leveraging CI/CD pipelines
  • Experience with Agile methodologies and able to work in an Agile manner is preferred
  • One or more cloud certifications
Discover the Reason Why So Many People Love It Here!

When you join Federal Reserve's National IT organization, not only will you find a challenging and purposeful career, you'll also have access to a wide range of benefits and perks that support your health and wealth, including:
  • Great medical benefits
  • Pension and 401(k) with employer match
  • Paid time off
  • Tuition reimbursement
  • Employee resource networks
  • Paid volunteer leave
  • Flexible work options
  • Onsite amenities that make working here fun

Other Requirements and Considerations:
  • A requirement of this position is that the employee must be fully vaccinated against COVID-19; individuals who are unable to be vaccinated due to a medical condition or sincerely held religious belief may request an accommodation from the Bank.
  • Candidates should review the Bank's Employee Code of Conduct to ensure compliance with conflict of interest rules and personal investment restrictions.
  • Sponsorship is not available for this role. Selected candidate is subject to special background check procedures.
  • The selected candidate will be subject to a government security investigation and must meet eligibility requirements for access to classified information. Eligibility for this specific position requires U.S. Citizenship or three or more years of Permanent Resident (Green Card) status.
  • Salary offered will be based on the job responsibilities and the individual's knowledge, skills, and experience as defined in the job qualifications/experience.

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