Data Architect/Modeler

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