Senior Data Modeler: BigQuery & Data Warehousing Architect

Compunnel Inc.

Fort Mill (SC)

On-site

USD 90,000 - 120,000

Full time

14 days+

Get a reply from this recruiter

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

A leading data solutions provider is seeking an experienced Data Modeler to design and deploy robust data models in the retail banking sector. The ideal candidate will possess over 5 years of experience with data modeling, governance, and architecture. Strong expertise in GCP and BigQuery is required, alongside proficiency in SQL and Python. Applicants should be detail-oriented communicators with a solid understanding of data quality and compliance. This position offers the opportunity to influence data solutions that enhance business insights.

Qualifications

  • 5+ years of experience in data modeling, governance, and architecture.
  • Hands-on with GCP, BigQuery, Dataflow, SQL, and Python.
  • Strong understanding of normalization and dimensional modeling.

Responsibilities

  • Design and implement relational and dimensional data models.
  • Develop conceptual, logical, and physical data models.
  • Optimize data models for pipelines using Airflow, Dataflow, Spark.

Skills

Data modeling
SQL
GCP
BigQuery
Data governance
Python
Data modeling tools
Data accuracy

Education

Bachelor’s or master's degree in Computer Science or related field

Tools

Wherescape
ERwin
ER/Studio

Job description

We are seeking an experienced Data Modeler to design and deploy robust, scalable data models and pipelines supporting analytics and data product development within the retail banking sector. The ideal candidate will have strong expertise in financial data, advanced knowledge of GCP and BigQuery, and hands-on experience with relational and dimensional modeling. This role requires proficiency in handling large-scale structured and semi-structured datasets and collaborating with cross-functional teams to ensure high-quality, compliant, and scalable data solutions.

Key Responsibilities:

  • Design and implement relational and dimensional data models for enterprise data warehouses.
  • Develop conceptual, logical, and physical data models aligned with business and compliance requirements.
  • Perform data profiling and analysis to understand data quality, structure, and relationships.
  • Build and optimize data models to support ingestion and transformation pipelines using Airflow, Dataflow, Pub/Sub, Spark, and Python.
  • Manage and process structured and semi-structured data formats, including JSON and complex data types.
  • Apply data modeling and database design best practices to ensure scalability and performance.
  • Collaborate with product managers and stakeholders to design data products that provide actionable insights.
  • Enforce data quality, lineage, and governance across all data assets.
  • Define and document data models, entity relationships, pipelines, and processes to ensure transparency and maintainability.
Required Skills:
  • Bachelor’s or master's degree in Computer Science, Data Engineering, Information Systems, or related STEM field.
  • 5+ years of experience in data modeling, data governance, and data architecture roles.
  • Hands-on experience with GCP, Big Query, Dataflow, SQL, and Python.
  • Ability to define domain relationships and build connected entity models.
  • Strong understanding of normalization, dimensional modeling, and data warehousing principles.
  • Experience handling structured and semi-structured data.
  • Detail-oriented with strong data accuracy and validation skills.
  • Understanding of retail banking/credit card data domains and regulatory considerations.
  • Proficiency with SQL and data modeling tools such as Wherescape, ERwin, or ER/Studio.
  • Excellent communication and documentation skills.
Preferred Skills:
  • Certifications such as GCP Professional Data Engineer or GCP Architect.
  • Experience with data governance frameworks and metadata management.
  • Exposure to data product lifecycle or data mesh principles.
Education:

Bachelor's or master's degree in a related field.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Modeler
Data Modeler

Compunnel Inc. • Fort Mill (SC)

On-site
USD 90,000 - 120,000
Data Architect
Data Architect

TechDigital Group • San Jose (CA)

On-site
USD 90,000 - 150,000
Senior Data Architect — Enterprise Banking Data Strategy
Senior Data Architect — Enterprise Banking Data Strategy

Compunnel Inc. • New York (NY)

On-site
USD 120,000 - 150,000
Data Modeler
Data Modeler

Ethereum Technologies LLC • New York (NY)

On-site
USD 120,000 - 180,000
Data Modeler
Data Modeler

Robotic Process Automation LLC • New York (NY)

On-site
USD 120,000 - 190,000
Data Modeler
Data Modeler

Quantum Technologies LLC • New York (NY)

On-site
USD 110,000 - 150,000
Data Modeler
Data Modeler

Valiant Technologies LLC • New York (NY)

On-site
USD 120,000 - 170,000
Data Modeler
Data Modeler

Robotics Technologies LLC • New York (NY)

On-site
USD 120,000 - 170,000
Senior Data Warehouse Analyst
Senior Data Warehouse Analyst

TechDigital Group • Secaucus (NJ)

On-site
USD 90,000 - 120,000
Enterprise Data Architect
Enterprise Data Architect

TechDigital Group • Alpharetta (GA)

On-site
USD 140,000 - 190,000