My Shortlist

Your shortlisted jobs will appear here. To view your shortlist, please login or register

More Jobs Like This
DATE ADDED: Mon 15/10/2018

Data Modeler For Banking Data Warehouse Projects

Los Angeles, USA
APPLY NOW

COMPANY: NOVUM PARTNERS

Job Description

 

Description:

We are seeking a seasoned data modeler with experience developing data models for banking and financial services. Candidates must have experience developing business, logical, and physical data models for both 3NF and dimensional architectures. Experience developing and implementing physical data models for MPP database platforms such as Greenplum, Netezza, or Teradata is preferred.

 

Requirements and Responsibilities

  • Excellent communication skills - both written and oral
  • Knowledge of and experience with all aspects of a data warehouse project - data profiling and analysis, design and modeling, mapping, ETL development, and testing
  • Use business and functional requirements to develop integrated data models to support regulatory reporting, risk and fraud analytics, and customer management.
  • Develop entity and attribute descriptions and definitions for the models and ensure that conflicts in descriptions and definitions are resolved
  • Develop business data models, logical data models, and physical data models
  • Develop database scripts to migrate and install packages (DDL, DML, functions, etc)
  • Maintain and update data models as part of ongoing support
  • Optimize physical database models to improve loading and query times
  • Expert knowledge and experience with data warehousing and data marts in a banking environment.
  • Experience with every aspect of the SDLC in a banking environment

Required Experience

  • 10+ years developing data models within a banking environment
  • Advanced SQL, including writing functions and stored procedures
  • 10+ years working directly with project teams within a structured project environment developing data warehouse and BI solutions within the banking and financial service industry.

Related Technical Skills

  • Expert SQL (Oracle, SQL-Server, PostgreSQL, etc.). Experience with Greenplum DBMS is preferred
  • Expert understanding of various data models and design patterns used in data warehousing including: 3NF models, and Type 1, 2, and 3 dimensional loading
  • Expert experience with Inmon/Corporate Information Factory architecture
  • Expert experience with banking reference models (IBM/BDW, Teradata/LDM, or similar)
  • Experience with ERWin, ER-Studio, or similar data modeling tools
  • Experience with Collibra, Analytix, or similar metadata management tools

Education and Training

  • Bachelor's degree required, degree in business/MIS/CIS preferred
  • Applicable certifications and training for data modeling

Other

This a role for a full-time employee with Novum Partners, Inc, a technology consulting firm. Candidates who are hired for this role will be eligible to convert to full-time employment with Novum's clients after 18 months.

About Novum Partners

Novum Partners is a boutique consulting firm focused building new data and analytic capabilities for our clients in the banking and financial services space. Specific projects are in the area of regulatory reporting, risk and fraud analytics, and using data to drive customer profitability and service.

Headquartered in Salt Lake City, UT, Novum provides consulting services to clients around the USA.

About Novum Partners:

Novum Partners is a boutique consulting firm focused building new data and analytic capabilities for our clients in the banking and financial services space. Specific projects are in the area of regulatory reporting, risk and fraud analytics, and using data to drive customer profitability and service.

Headquartered in Salt Lake City, UT, Novum provides consulting services to clients around the USA.

Company Description
Novum Partners is a boutique consulting firm focused building new data and analytic capabilities for our clients in the banking and financial services space. Specific projects are in the area of regulatory reporting, risk and fraud analytics, and using data to drive customer profitability and service.

Headquartered in Salt Lake City, UT, Novum provides consulting services to clients around the USA.


Role: Data Modeler for Banking Data Warehouse Projects
Job Type:
Location: Los Angeles,

Apply for this job now.
APPLY NOW