Sr. Data Engineer – FCP Tech

Federal Capital Partners; Chevy Chase (MD); On-site; USD 100,000 - 130,000; Full time

Job summary

Federal Capital Partners is seeking a Sr. Data Engineer to join their team in Chevy Chase, Maryland. The role focuses on designing and developing AI-assisted data pipelines and supporting investment decisions using advanced analytical tools.

Ideal candidates should possess a Bachelor’s degree in Engineering or Computer Science, with a minimum of 4 years of experience in data engineering and analytics. Familiarity with Azure and Python is essential. This is an opportunity to work in a fast-paced, collaborative environment with a focus on real estate.

Qualifications

• Bachelor’s or advanced degree in Engineering or Computer Science with excellent academic credentials.
• Minimum of 4 years of relevant work experience.
• At least 2 years of experience building data engineering solutions on cloud platforms.

Responsibilities

• Design and develop AI-assisted data pipelines.
• Build and maintain data ingestion pipelines.
• Develop automated financial data analysis workflows.

Skills

Data pipeline design and development

Python programming

Data analysis

Azure cloud platforms

Power BI

SQL

AI and machine learning

Education

Bachelor’s or advanced degree in Engineering or Computer Science

Tools

Microsoft Fabric

Python data libraries

Power BI & DAX

Databricks

Job description

Real estate private equity is an exciting industry with the power to shape communities and change the built environment. 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.

FCP is a leading real estate investment company that has invested in or financed more than $12.5 billion in assets since its founding in 1999. We are seeking an experienced Sr. Data Engineer to join our Washington, DC team. This is a rare opportunity to help build and scale a modern data and AI platform at a high‑performing real estate private equity firm.

YOUR IMPACT:

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

YOUR QUALIFICATIONS:

• Bachelor’s degree or advanced degree in Engineering or Computer Science with excellent academic credentials
• 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
• Experience or previous interest in Real Estate strongly preferred
• Required Technical Skills:
  • Excel (Complex Formulas, PivotTables, Formatting)
  • Microsoft Fabric (Lakehouse, Data Factory, Notebooks)
  • Python
  • SQL
  • Power BI & DAX
• Preferred Technical Skills:
  • Azure OpenAI & AI Services
  • Databricks
  • JavaScript/HTML/CSS
  • LangChain or other AI/LLM orchestration frameworks
  • Financial Modeling