Analytics Engineer

About the Organization 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. Bulfinch's commitment to the growth and development of its employees is central. The firm offers top‑tier benefits and career‑enhancement opportunities to all employees and celebrates diversity by creating an inclusive environment. Bulfinch is proud to be an Equal Opportunity Employer. We are an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status or any other characteristic protected by law. Position Analytics Engineer, Artificial Intelligence & Technology 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 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. 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. Position Requirements What we're looking for 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. #J-18808-Ljbffr