Senior Cloud Data Engineer

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 sharin...