What are the responsibilities and job description for the Analytics Engineer position at Bulfinch?
ABOUT US:
Bulfinch is a third-generation commercial real estate firm specializing in the acquisition, development, management, and repositioning of commercial properties in Greater Boston. Since 1936, Bulfinch has taken a unique approach to creating value in commercial real estate and has successfully evolved and adapted to industry changes and the needs of all our stakeholders. The firm was founded on a commitment to our employees and the culture we began cultivating 90 years ago embodies our entrepreneurial spirit and sense of family.
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. Employment decisions are made without regard to race, color, religion, sex, age, national origin, disability status, veteran status, sexual orientation, gender identity, or any other protected characteristic under applicable federal, state, or local law.
Employment with Bulfinch is on an at-will basis, meaning either the employee or the company may terminate the employment relationship at any time, with or without cause or notice, subject to applicable law.
If you are excited about this role but don’t meet every requirement, we encourage you to apply. You may be the right candidate for this or another role at Bulfinch now or in the future.
Thank you for your interest in Bulfinch.
Position Requirements
Required:
- 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.
Salary : $90,000 - $130,000