Sr. Data Engineer – Real Estate Private Equity

FCP; Chevy Chase (MD); On-site; USD 130,000 - 170,000; Full time

Job summary

FCP in Washington, DC is seeking a Senior Data Engineer to join our private equity technology team. You will design AI-assisted data pipelines, semantic models, and Power BI reports to support investment decisions and operations.

You will build data ingestion pipelines in Azure and Microsoft Fabric, automate financial data analyses, and govern data across disparate sources, partnering with leadership to drive analytics with AI capabilities.

Qualifications

• Bachelor’s degree or advanced degree in Engineering or Computer Science with excellent academic credentials.
• Experience or previous interest in Real Estate strongly preferred.
• Minimum of 4 years of relevant work experience.
• Minimum of 2 years of experience building and deploying data engineering solutions on cloud platforms (Azure preferred).
• Minimum of 2 years of relevant data analytics work experience.
• Minimum of 2 years of experience with python and associated data libraries.
• Minimum of 2 years of experience with databases & queries.
• Excellent written and oral communication skills; ability to present to leadership.

Responsibilities

• Design and develop AI-assisted data pipelines, semantic models, and Power BI reports to support investment decisions and operations
• Build, automate, and maintain data ingestion pipelines using Microsoft Fabric Data Factory and Python
• Develop automated financial data analysis workflows and reporting solutions that leverage AI and machine learning capabilities
• Integrate and govern disparate financial and operational data sources within FCP’s Microsoft Fabric lakehouse environment
• Lead data quality, reconciliation, and lineage initiatives across investment, financial, and asset management datasets

Skills

Data analytics

Communication skills

Independent worker

Education

Bachelor's degree or advanced degree in Engineering or Computer Science

Tools

Python

SQL

Microsoft Fabric

Azure

Power BI

Databricks

LangChain

Job description

Real Estate Private Equity is an exciting industry with the power to shape communities and change the built environment. FCP®, a subsidiary of Federated Hermes, Inc, is a leading real estate investment company that has invested in or financed more than $14.8 billion in gross asset value since its founding in 1999.

We are currently seeking a Sr. Data Engineer to join our Washington, DC team. FCP’s technology team is at the forefront of this transformation, leveraging AI, automation, and modern data platforms to drive smarter investment decisions and operational excellence. This role offers a unique opportunity to work directly with firm leadership, industry experts, and cutting-edge tools to make a measurable impact on the business.

RESPONSIBILITIES:

As a Sr. Data Engineer, you will support our business lines, clients and investment decisions by:

• Design and develop AI-assisted data pipelines, semantic models, and Power BI reports to support investment decisions and operations
• Build, automate, and maintain data ingestion pipelines using Microsoft Fabric Data Factory and Python
• Develop automated financial data analysis workflows and reporting solutions that leverage AI and machine learning capabilities
• Integrate and govern disparate financial and operational data sources within FCP’s Microsoft Fabric lakehouse environment
• Lead data quality, reconciliation, and lineage initiatives across investment, financial, and asset management datasets

REQUIREMENTS:

• Bachelor’s degree or advanced degree in Engineering or Computer Science with excellent academic credentials
• Experience or previous interest in Real Estate strongly preferred
• Minimum of 4 years of relevant work experience
• Minimum of 2 years of experience building and deploying data engineering solutions on cloud platforms (Azure preferred)
• Minimum of 2 years of relevant data analytics work experience
• Minimum of 2 years of experience with python and associated data libraries
• Minimum of 2 years of experience with databases & queries
• Ability to analyze qualitative and quantitative information and translate into strategic deliverables
• Ability to work independently and within a team
• Experience working in Microsoft Azure and/or Microsoft Fabric; familiarity with AI services such as Azure OpenAI strongly preferred
• Excellent written and oral communication skills
• Experience in presenting ideas and analysis to groups and leadership
• Motivated self-starter with effective time management skills and strong attention to detail
• A desire to work within a fast-paced, collaborative, and entrepreneurial environment
• Required Technical Skills:
• Microsoft Fabric (Lakehouse, Data Factory, Notebooks)
• Python
• SQL
• Power BI & DAX
• Preferred Technical Skills:
• Databricks
• LangChain or other AI/LLM orchestration frameworks

About FCP

FCP invests in all asset classes and provides equity, preferred equity and structured debt investments for commercial and residential real estate. The firm, based in Chevy Chase, MD, owns and manages in excess of $14.8 billion in assets. FCP is currently investing its sixth investment fund, a $1.1B commingled, value-add discretionary fund.

FCP is committed to hiring and retaining a diverse workforce. We are an Equal Opportunity Employer, making decisions without discrimination on the basis of race, color, religion, sex, national origin, age, veteran status, disability, sexual orientation, genetic information or any other protected class, in accordance with applicable law.

For further information on FCP, please visit https://www.fcpdc.com/