GCP Data Modeler - Banking Domain

Vsg Business Solutions
Charlotte, NC, United States
7 days ago
Apply on www.careerjet.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Working hours
Regular working hours

Tech stack

Third Normal Form Adaptable Database Systems Agile Methodology Business Analytics Applications BigQuery Cloud Database Data Architecture Data Dictionary Data Governance Data Integration Extract Transform Load (ETL) Data Structures
+15 more
Data Systems Data Warehousing Database Design Database Queries Dimensional Modeling Metadata Reference Data Cloud Services Google Cloud Data Lakes Data Lineage Star Schema Google Bigquery Data Management Physical Data Models

Job description

We are seeking an experienced GCP Data Modeler with strong expertise in data modeling, cloud data platforms, and the banking/financial services domain. The ideal candidate will be responsible for designing conceptual, logical, and physical data models for enterprise-scale data platforms on Google Cloud Platform (GCP). The candidate will work closely with data architects, engineers, business stakeholders, and application teams to translate complex banking requirements into scalable and governed data solutions., * Design and maintain conceptual, logical, and physical data models for enterprise banking applications and data platforms.

  • Develop scalable data models for GCP-based data warehouses, data lakes, and analytical platforms.
  • Work extensively with Google BigQuery and cloud-based data architecture.
  • Analyze business requirements and translate them into robust data structures and models.
  • Develop data models supporting banking functions such as:

  • Retail and commercial banking
  • Customer and account management
  • Deposits and lending
  • Payments and transactions
  • Credit and risk
  • Regulatory reporting
  • Fraud and AML
  • Define entities, attributes, relationships, keys, constraints, and business rules.
  • Establish and maintain enterprise data modeling standards and naming conventions.
  • Collaborate with data architects and engineers to ensure models are optimized for performance, scalability, and maintainability.
  • Support data warehouse and data lake design using dimensional modeling techniques such as Star and Snowflake schemas.
  • Perform source-to-target mapping and assist with data integration and ETL/ELT design.
  • Work with data governance teams to support data quality, lineage, metadata, and master/reference data management.
  • Identify data redundancies, inconsistencies, and gaps and recommend appropriate solutions.
  • Optimize physical data models for BigQuery and other GCP data services.
  • Create and maintain data model documentation and metadata.
  • Participate in architecture reviews, technical discussions, and Agile ceremonies.
  • Provide guidance and mentoring to data engineers and development teams., Data Modeler Charlotte, NC- Onsite from day 1 Hire type: contract Responsibilities: Design and maintain conceptual, logical, and physical data models for Home Lending and Regu…
  • 1 day ago
  • Apply easily, Title: Data Modeler Location: Charlotte, NC Job Overview The Data Modeler is responsible for designing and testing enterprise data products, articulating and documenting why a…
  • 6 days ago +

Requirements

  • 10+ years of experience in data modeling, database design, or data architecture.
  • Strong hands-on experience with GCP data technologies, particularly BigQuery.
  • Strong knowledge of conceptual, logical, and physical data modeling.
  • Experience with dimensional modeling, Star Schema, Snowflake Schema, and 3NF.
  • Strong SQL skills and experience working with large enterprise datasets.
  • Strong understanding of data warehousing, data lakes, and modern cloud data architectures.
  • 5+ years of experience in banking or financial services.
  • Strong understanding of banking data domains, business processes, and terminology.
  • Experience with data modeling tools such as ER/Studio, ERwin, or similar tools.
  • Experience creating source-to-target mappings and data dictionaries.
  • Strong understanding of data governance, data quality, metadata, and data lineage.
  • Excellent communication and stakeholder-management skills.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerjet.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:30 min

Leveraging BigQuery ML for scalable SQL-based segmentation experiments

Julian Joseph · LIVE

1:47 min

Comparing Egeria to alternative open metadata solutions

Ferd Scheepers · World Congress 2022

3:24 min

The governance failures of centralized data lakes

Mario Meir-Huber · LIVE

2:36 min

Integrating business experts and conceptualizing analytical use cases

Stefan Donsa Stefan Donsa +1 · LIVE

2:08 min

Creating standard APIs via the Egeria open metadata project

Ferd Scheepers · World Congress 2022

6:24 min

Distributed data lakes and containerized computing clusters

Ulrich Wurstbauer +1 · LIVE

Videos

See all

Related articles

See all