This is a remote position.

Job Title:
Data Architect/Modeler

Location:
100% Remote

Duration:
12 months (ability to extend)

MUST have strong data modeling skills.
This is really a true Data Modeler position and less of a Data Architect role. Do not need Microsoft Fabric.

The firm has over 55 years of experience in growth investing, building world-class businesses around the globe. We are developing a cutting-edge data analytics platform built on
Microsoft Fabric
, designed to enable scalable, efficient, and real-time insights. We leverage modern
data lakehouse architectures
,
PySpark
, and best-in-class
data modeling
principles to drive business intelligence and analytics.

Role Overview

We are looking for a
highly skilled Data Architect
to design and implement an
enterprise-wide data architecture
that aligns with business and Enterprise Data Program goals. This role will be responsible for defining and managing
data models
within a
Delta Lakehouse architecture
, ensuring scalability, performance, and integrity. This position will also have a pivotal role to play in the implementation, and continuous improvement of enterprise data management practices across Warburg Pincus. The ideal candidate will have
strong expertise in data modeling (Star Schema, Snowflake, Data Vault)
, data management principles like metadata management, data quality, data stewardship etc., and
excellent analytical and communication skills
to work closely with business stakeholders and technical teams.

Key Responsibilities

• 
  Design and develop enterprise data models
  to support
  business intelligence, analytics, and operational reporting
  .
• 
  Define and implement best practices
  for
  data modeling
  in a
  lakehouse environment
  , ensuring models support business needs effectively.
• 
  Architect data structures
  for
  performance, scalability, and governance
  , leveraging concepts such as
  Star Schema, Snowflake Schema and Data Vault
  .
• 
  Collaborate with business stakeholders
  to understand reporting, analytical, and operational data needs, ensuring models are aligned with business objectives.
• 
  Work closely with Data Engineers
  to translate logical data models into
  optimized physical data models
  in
  Microsoft Fabric
  and
  Delta Lake
  .
• 
  Develop data governance frameworks
  , including
  metadata management, data lineage tracking, and data quality assurance
  .
• 
  Define and maintain canonical data models
  for key business domains, ensuring consistency across the organization.
• 
  Guide ETL/ELT strategies
  to ensure
  data integrity and optimal performance
  in
  Fabric's Medallion Architecture
  .
• 
  Establish and document data modeling standards
  , ensuring adoption across engineering teams.
• 
  Review and optimize existing data models
  , identifying areas for improvement in performance, maintainability, and business alignment.
• 
  Advise on the selection and implementation of data modeling tools
  and data management solutions.

Key Qualifications

• 
  7+ years of experience
  in
  data architecture, data modeling, or database design
  .
• 
  Expertise in data modeling methodologies
  , including
  Dimensional (Star/Snowflake), relational and Data Vault
  .
• 
  Deep understanding of relational and non-relational databases
  , including
  SQL, NoSQL, and Delta Lake architecture
  .
• 
  Strong familiarity with Microsoft Fabric, Delta Lake, and Medallion Architecture
  .
• 
  Experience designing data models
  for
  enterprise analytics, reporting, and operational use cases
  .
• 
  Strong SQL skills
  for data modeling, query optimization, and data analysis.
• 
  Hands-on experience
  with
  ETL/ELT processes
  and integration strategies.
• 
  Understanding of cloud-based data architectures
  , preferably in
  Azure (Azure Data Lake, Synapse, Databricks, etc.)
  .
• 
  Self-starter, Strong analytical and problem-solving skills
  , with the ability to understand and translate business needs into data models.
• 
  Excellent communication and stakeholder management skills
  , with the ability to interact effectively with business and technical teams.

Preferred Qualifications

• 
  Experience with
  Data Vault
  implementation.
• 
  Familiarity with
  data management and data governance tools like Alation, Collibra, Atacamma, Atlan etc.
• 
  Knowledge of
  KQL for querying data logs in Azure environments
  .
• 
  Experience with
  Graph Data Modeling
  and NoSQL databases (e.g., Cosmos DB).
• 
  Exposure to
  machine learning feature stores
  and analytical model design.
• 
  Knowledge of
  BI tools (Power BI, Tableau)
  for building EDM dashboards.

Why Join Us?

• 
  Shape the enterprise data architecture
  for a modern
  data analytics platform
  .
• 
  Work with
  cutting-edge data technologies
  in a
  Microsoft Fabric
  environment.
• 
  Engage directly with
  business leaders
  to craft data solutions that drive
  actionable insights
  .
• 
  Be part of an
  innovative, high-impact team
  delivering
  best-in-class data models
  .
• 
  Competitive compensation, benefits, and
  opportunities for professional growth
  .

If you are passionate about
data architecture, data management, business-driven modeling, and scalable data solutions
, we'd love to hear from you!