Databricks/Data Modeler

Company

Federal Reserve Bank of New York

Working at the Federal Reserve Bank of New York positions you at the center of the financial world with a unique perspective on national and international markets and economies.

You will work in an environment with a diverse group of experienced professionals to foster and support the safety, soundness, and vitality of our economic and financial systems.  

The Bank’s flexible work model supports balancing the demands of work and life, while prioritizing the value of connecting and collaborating with our colleagues in person.

Employees are expected to live within a commutable distance of their primary work location to support team collaboration.

What we do:

Provides leadership in data management and analytics (supported by data) to define and solve important business problems in collaboration with business leaders.

Partners with management and delivers viable solutions and operations to support data initiatives.

Defines business data requirements and works with Technology service providers to define and deliver the appropriate solutions.

Supports creation of data standards, ongoing data quality support, and exception management as it relates to projects and support of ongoing production applications while working closely with the Data Management teams to aid in the procurement of data services.

More specifically:

o    Create data products in Databricks
o    Leverage best design practices for modeling a data lakehouse architecture to convert current (RDBMS) data models to best represent data in Databricks
o    Re-architect legacy data (from existing applications and/or databases) to migrate to Databricks while optimizing for query performance, compute and storage costs.

Your role as a Data Modeler:


* Create data products in Databricks


* Leverage best design practices for modeling a data lakehouse architecture to convert current (RDBMS) data models to best represent data in Databricks


* Re-architect legacy data (from existing applications and/or databases) to migrate to Databricks while optimizing for query performance, compute and storage costs

Top Skills


* Financial industry experience, strong knowledge of business domains including fixed income products, trades, positions, and reference data


* Data modeling experience (conceptual, logical, and physical), relational and dimensional data model design


* ETL experience with Databricks and Spark


* Data processing and analytics in Databricks


* Strong analytical skills

What we are looking for:

Core Responsibilities


* Leverage financial industry expertise to define conceptual, logical and physical data models in Databricks to support new and existing business domains


* Work with product owners, system architects, data engineers, and vendors to create data models optimized for query performance, compute and storage costs


* Define best practices for the implementation of the Bronze/Si...