Analytics Engineer

About the role

We're building the data infrastructure that powers how we acquire, operate, and report on our portfolio — and we need someone to own it. This is a greenfield role. You'll be the first dedicated analytics hire at the firm, working directly with the entire organization to design and build a Microsoft Fabric-based data platform from the ground up.

What you'll build

• A centralized data lakehouse (Microsoft Fabric / OneLake / Azure Data Lake) that consolidates data from Yardi, Argus, Juniper Square, Chatham, and other source systems into a single reliable layer
• Power BI dashboards for property performance, portfolio analytics, investment underwriting support, and senior leadership reporting
• Automated ETL/ELT pipelines that eliminate manual data handling and stale exports across investments, accounting, and asset management
• The integration layer between the firm's data platform and AI tools (including Claude API and Azure OpenAI) that allows portfolio data to be queried and reasoned over in real time
• Data governance standards, documentation, and processes that make the platform durable as the firm grows

Compensation & Benefits

The heart of Bulfinch is our people. We are committed to the individual growth and development of our most important asset — our team members. The salary range for this position is: $90,000 – $130,000 annually, based on experience, qualifications, existing relationships, and overall skill set. Final compensation will be determined based on a variety of factors assessed throughout the interview process.

Bulfinch offers a competitive compensation and benefits package, along with meaningful opportunities for professional growth and advancement within the organization.

Bulfinch is proud to be an Equal Opportunity Employer. We celebrate diversity and are committed to fostering a diverse, inclusive, and collaborative workplace environment for all employees and applicants.

Position Requirements

• 3–5 years of professional experience in data engineering, analytics engineering, or BI development
• Hands-on experience building and maintaining data pipelines in Microsoft Fabric, Azure Data Factory, or Azure SQL
• Strong Power BI skills: data modeling, DAX, semantic models, workspace governance
• Solid SQL foundation: comfortable writing complex queries across multiple source systems
• Ability to communicate clearly with non-technical stakeholders

Preferred

• Microsoft Certified: Fabric Analytics Engineer (DP-700 or DP-600)
• Experience with CRE platforms: Yardi, Argus Enterprise, Juniper Square, Chatham
• Familiarity with Power Platform (Power Apps, Power Automate, Dataverse)
• Python for data transformation and pipeline scripting
• Hands-on experience integrating LLM APIs (Azure OpenAI, Claude, or similar) into data workflows
• Working knowledge of commercial real estate fundamentals — asset classes, leasing, investment underwriting

Education

Bachelor's degree required; graduate degree in a quantitative field is a plus but not a substitute for demonstrated experience.