Senior Cloud Data Engineer

Federal Reserve Bank of Boston; Boston (MA); On-site; USD 140,000 - 210,000; Full time

Job summary

The Federal Reserve Bank of Boston is seeking a Senior Cloud Data Engineer to design and manage data architectures and BI models for enterprise analytics. This role focuses on complex data design, metadata repositories, and data quality across systems, working with an Agile team onsite.

You will develop data pipelines, implement cloud-based data solutions using AWS services, perform ETL and SQL tasks, and contribute to dashboards and metrics for Audit and management.

Qualifications

• 9+ years of relevant work experience.
• Bachelor’s or higher degree in a relevant discipline.
• Certification related to IT preferred.
• Broad knowledge of programming, SQL queries, data warehouses, relational databases, and quantitative/qualitative data analytics techniques.
• Broad familiarity with analyzing performance measures and dashboards.

Responsibilities

• Design complex data architectures, metadata and repositories; manage and administer data assets.
• Configure database parameters and resources; validate data loaded for accuracy.
• Lead troubleshooting of database applications and data requirements analysis.
• Ensure data integrity and monitor data quality across systems.
• Improve infrastructure and automation efficiency.
• Produce complex analytic models, ad-hoc queries and reports for audits and management.
• Lead software testing including ETL, SQL and reporting tools; develop scripts.
• Collaborate within an Agile team to enable data-driven decision making and governance.
• Develop IT engineering designs supporting project infrastructure requirements.
• Ensure traceability from business requirements to design.

Skills

AWS

CI/CD

Terraform

Java

Python

Data modeling

SQL

ETL

Education

Bachelor’s or higher degree relevant discipline

Certification related to Information Technology preferred

Tools

GITLAB

Aurora PostgreSQL

S3

Glue

Job description

Company

Federal Reserve Bank of Boston

When you join the Federal Reserve—the nation's central bank—you’ll play a key role, collaborating with leading tech professionals to strengthen and protect our economic, financial and payments systems. We invest in contemporary and emerging technology each year to support the Federal Reserve and our economy, and we’re building a dynamic and diverse team for our future.

The District IT & Corporate Services portfolio provides enterprise technology solutions and services for the System's District IT needs as well as the corporate and administrative functions. This portfolio supports District IT for each of the 12 Reserve Banks and eight critical business lines Systemwide: Human Resources, Legal, Shared Administrative Services, Finance, Procurement, Audit, Law Enforcement and Facilities.

The selected candidate will reside within a reasonable commuting distance, as defined by the employing Reserve Bank, and will work full-time onsite.

Eligible Locations for Hire: Boston, MA- New York, NY- Philadelphia, PA- Cleveland, OH- Richmond, VA- Atlanta, GA- Chicago, IL- St. Louis, MO- Minneapolis, MN- Kansas City, MO- Dallas, TX- San Francisco, CA

This Senior Cloud Data Engineer role will be responsible for all aspects of business intelligence structure including analysis of requirements, design, troubleshooting, support and administration of schemas, data definitions, meta data, and architecture of all data analytic models, databases, and repositories used to create, retain, and analyze business intelligence data.

What You Will Do

• Responsible for complex data design, database architecture, metadata and repository creations, repository management, construction, and administration
• Configure database parameters, allocate database resources, and review data loaded into databases for accuracy.
• Leads trouble shooting database applications, product support, analysis of data requirements, maintenance of application and processing architectures, and database schemas.
• Establishes integrity of complex data definitions and underlying data models, and monitors/audits overall data quality
• Leads improvements to increase efficiency of infrastructure and automation processes.
• Produce complex data analytic models, ad-hoc queries, and reports for distribution to Audit and business management. Performs basic SQL queries for analysis of existing metrics and the development of new metrics.
• Leads software testing including code-level/unit testing, ETL processes, SQL or reporting tools, code-level unit testing, and script development of moderate complexity.
• Work and collaborates as a part of an Agile team to develop and implement capabilities to enable decision making processes and procedures including data, reporting, dashboards, metadata collection processes, metric collection processes, resolve data issues, data governance and data clean up and maintenance, data sharing agreement processes, etc.;
• Develops conceptual, logical, and physical IT engineering designs, that support the infrastructure requirements of varying levels of technical and business application projects.
• Completes analysis of business requirements, as it relates to technical infrastructure design, and ensure traceability of the design to the business requirements.

Knowledge And Skills

• Experience using core Aws services to build and support data solutions leveraging architecture best practices [S3, Glue, Lambda)
• Expertise in AWS Storage (S3, EBS), AWS Databases (Aurora Postgress,), AWS Data Integration (Glue).
• Good understanding of AWS Identify and Access management, AWS Networking and AWS Monitoring tools.
• Proficiency in CI/CD and deployment automation using GITLAB pipeline.
• Proficiency in Cloud infrastructure provisioning tools e.g., Terraform.
• Strong technical skill in software engineering for Java EE /Cloud technologies and proficiency in Java Lambdas, Java Streams API, Java functional programming.
• Proficiency in one or more programming languages e.g., Python, Scala.
• Knowledge in Workday data tools including Adaptive & Prism desirable, but not required.
• Knowledge in Ariba desirable, but not required.

Qualifications

• 9+ years of relevant work experience
• Bachelor’s or higher degree relevant discipline
• Certification related to Information Technology preferred.
• Broad knowledge of programming, SQL queries, data warehouses, relational databases, and quantitative/qualitative data analytic techniques
• Broad familiarity with analyzing performance measures and metrics and developing balanced scorecards and dashboards.

The salary range for this position is $139,800 - $209,600. The Boston Fed believes in salary transparency. The final salary and offer will be determined by the applicant’s background, skills, internal equity, and alignment with market data. Whether you’re developing into the job or are a more seasoned candidate, we aim to pay competitively. If you reside outside of the 1st District (Boston), you may be hired by your local Federal Reserve District and compensation will follow hiring District's range and policy.

All employees assigned to this position will be subject to FBI fingerprint/ criminal background and Patriot Act/ Office of Foreign Assets Control (OFAC) watch list checks at least once every five years. The above statements are intended to describe the general nature and level of work required of this position. They are not intended to be an exhaustive list of all duties, responsibilities or skills associated with this position or the personnel so classified. While this job description is intended to be an accurate reflection of this position, management reserves the right to revise this or any job description at its discretion at any time.

The Federal Reserve System is committed to a diverse and inclusive workplace and to provide equal employment opportunities to all persons without regard to race, color, religion, national origin, sex, sexual orientation, gender identity, age, genetic information, disability, or military service.

All employees assigned to this position will be subject to FBI fingerprint/ criminal background and Patriot Act/ Office of Foreign Assets Control (OFAC) watch list checks at least once every five years.

The above statements are intended to describe the general nature and level of work required of this position. They are not intended to be an exhaustive list of all duties, responsibilities or skills associated with this position or the personnel so classified. While this job description is intended to be an accurate reflection of this position, management reserves the right to revise this or any job description at its discretion at any time.

For this job, any offer of employment is contingent upon successfully passing a two-phase security screening. The first phase consists of the satisfactory completion of a physical examination (including a drug screening), reference checks, and a security investigation consisting of credit and criminal history checks.

The second phase, which might not be complete until after you begin working at the Reserve Bank, is an additional risk-based security screening determined by the risk rating of the position. Depending upon the sensitivity of the position, this phase may include, and is not limited to, work and residency eligibility verification, and personal interviews with the candidate, references, and prior employers.

All applicants must have resided in the United States for at least three (3) years

Full Time / Part Time

Full time

Regular / Temporary

Regular

Job Exempt (Yes / No)

Yes

Job Category

Information Technology Family Group

Work Shift

First (United States of America)

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