Data Analyst​/Engineer, Artificial Intelligence & Technology

Data Analyst / Engineer, Artificial Intelligence & Technology

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.

The heart of Bulfinch is our people. We are committed to the individual growth and development of our most important asset – our team members. Bulfinch offers top-tier benefits and career‑enhancement opportunities to all employees. We celebrate diversity and are committed to creating an inclusive environment for all employees.

Bulfinch is proud to be an Equal Opportunity Employer.

We are seeking a skilled and detail-oriented Data Analyst / Engineer to serve as the firm's centralized data infrastructure owner. This foundational hire will directly enable Bulfinch's AI strategy‑building and maintain the clean, connected data layer that powers Power BI dashboards, AI models, and decision‑making across the organization.

Reporting into the AI & Technology function and working closely with the firm's AI Steering Committee and external AI Strategist, this individual will architect and maintain a Microsoft Fabric and Azure-based data lakehouse, integrating source systems including Yardi, Argus, Juniper Square, SharePoint, and Chatham into a single queryable source of truth. The role sits at the intersection of data engineering, financial analytics, and commercial real estate operations, translating complex data into strategic insights that drive informed business decisions across investments, asset management, leasing, and accounting.

• Design, build, and maintain a centralized data lakehouse using Microsoft Fabric, Azure Data Lake, and One Lake, consolidating data from Yardi, Argus, Juniper Square, SharePoint, Chatham, and other source systems.
• Develop and manage automated data pipelines that extract, clean, and load data from all source systems into a single, reliable layer accessible to Power BI, AI models, and future tools.
• Execute daily, weekly, and monthly data integrity processes crucial for supporting quantitative models and portfolio reporting.
• Optimize data gathering and validation processes for efficiency and scalability as the firm’s data footprint grows.
• Ensure data governance and consistency across all integrated platforms, reducing reliance on stale exports and manual reporting.

• Develop and maintain Power BI dashboards for property performance, portfolio analytics, investment underwriting, and leadership reporting.
• Collaborate with cross‑functional teams to develop data‑driven narratives using visualization dashboards for internal asset operations and investor reporting.
• Conduct research and curate datasets from internal and external sources; derive actionable insights to inform leasing, acquisitions, and capital planning decisions.
• Provide financial analysis support across business units including investments, asset management, and accounting.
• Translate complex data into clear, strategic insights that drive informed business strategies for senior leadership.

• Serve as the data infrastructure owner for AI initiatives including Ask Bulfinch, automated deal memos, lease abstraction, and email triage—ensuring AI models have access to clean, well‑structured Bulfinch data.
• Integrate Azure OpenAI and/or Claude API with the firm’s data layer, enabling AI tools to query and reason over live portfolio information.
• Collaborate with the external AI Strategist and AI Steering Committee on data requirements for new AI tool builds and model deployments.
• Support Dataverse implementation for structured CRM‑style records, deal tracking, and Power Apps integrations where applicable.

• Facilitate data…