Analytics Engineer

Broadstone Net Lease, Inc.; New York, Northern (NY, KY); Hybrid; USD 65,000 - 80,000; Full time

Job summary

Broadstone Net Lease, Inc. is seeking an Analytics Engineer to build data pipelines, models, and APIs powering reporting and internal applications. You will work with internal teams to translate business needs into scalable data products and dashboards.

The role requires 1–3+ years in data/analytics engineering, with strong Python/SQL skills, and experience with Azure data services and Power BI. Hybrid office environment; base salary discussed during recruitment.

Qualifications

• Bachelor’s degree in Applied Statistics, Computer Science, Data Science, Information Systems, or related discipline.
• 1-3+ years of data, software, or analytics engineering experience.
• Familiarity with Power BI, including building datasets.
• Azure Data Factory, Functions, or DevOps experience strongly preferred.
• Experience building APIs with FastAPI or consuming external data APIs a plus.
• Experience integrating LLM/AI APIs or with AI-assisted development a plus.
• Azure WebApp services a plus.

Responsibilities

• Work with stakeholders across the organization to understand business needs and design dashboards, analytics, and scalable data products that answer real questions and drive decisions.
• Build and maintain automated data pipelines that ingest data from internal systems and external vendor APIs.
• Write and optimize SQL and contribute to database design, schema and data modeling, and warehouse architecture.
• Leverage AI coding tools to accelerate development while ensuring production-grade quality of code.
• Integrate LLM/AI capabilities into Broadstone Net Lease solutions where needed.
• Develop and evaluate options in infrastructure planning to support new applications and technologies.
• Partner with analysts and business teams to convert manual processes into automated, reusable data products.

Skills

Python

SQL

Cloud platforms

Azure

Power BI

FastAPI

APIs

LLM/AI tools

Communication

Organization

Education

Bachelor’s degree in a relevant field

Tools

Azure Data Factory

Azure Functions

DevOps

FastAPI

Job description

At BNL, we’re as passionate about people as we are about real estate.

BNL is a collaborative, inclusive, and creative workplace where people with unique talents can flourish, their opinions are valued, and their contributions are recognized. Our professionals enjoy fascinating, challenging work and are rewarded by sharing in the company’s success.

Headquartered in Victor, NY with a regional office in Phoenix, AZ, our team of professionals are engaged in work across the following areas: acquisitions and underwriting, property and asset management, finance and accounting, capital markets, investor relations, operations and administration, information technology and solutions, legal, and human resources.

Broadstone is committed to cultivating a culture of inclusion and belonging and we believe that varied backgrounds and experiences enhance our culture and drive our performance.

Here is what our employees say about working at Broadstone

There is a high level of individual respect from the top all the way down and from the bottom all the way up to the top again. It makes sharing opinions and suggestions easier, and greatly contributes to our culture of inclusion.

The best part about Broadstone is the intentional and unselfish focus to make sure everyone benefits proportionately from the company's success.

BNL respects all points of view. New ideas are welcomed and discussed at length. Employees are encouraged to speak up and challenge the status quo.

Our Mission

Our Values

Our corporate values serve as the foundation of our One Broadstone culture and guide our work and efforts each day.

Company Benefits

Our employees are our most valuable assets. To reward their commitment, we strive to provide a competitive and flexible mix of total rewards that have their best interests in mind and enhance our employee‑centric culture. BNL offerings include:

Broadstone is an Equal Opportunity Employer. We provide equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, sex, age, disability, religion, citizenship, national origin, ancestry, military status or veteran status, marital status, pregnancy, familial status, sexual orientation, gender identity or expression, domestic violence victim status, predisposing genetic characteristics and genetic information, reproductive health decision making, including the decision to use or access a particular drug or medical service; and any other status or characteristic protected by applicable federal, state, or local law.

We will reasonably accommodate individuals with disabilities throughout the employment selection process. If you need special assistance or an accommodation to apply for a posted position, please contact Nicole Kier, Director, Human Resources at [e-mail] or 585.413.5517.

The Analytics Engineer will support the development of Broadstone Net Lease's modern, automated data platform by building data pipelines, models, and APIs that power reporting, business analytics, and internal applications across the organization. The individual will leverage their interest in understanding how our business works in partnership with internal teams to support and implement durable, scalable data solutions, in addition to related projects and initiatives. The ideal candidate will work analytically, communicate effectively, prioritize multiple projects, and demonstrate the ability to succeed in a dynamic, growing environment. This position reports to the Director, Corporate Finance & Business Analytics.

• Work with stakeholders across the organization to understand business needs and design dashboards, analytics, and scalable data products that answer real questions and drive decisions
• Build and maintain automated data pipelines that ingest data from internal systems and external vendor APIs
• Write and optimize SQL and contribute to database design, schema and data modeling, and warehouse architecture
• Leverage AI coding tools (e.g., Claude Code, codex) to accelerate development while reading, understanding, and validating all AI-generated code, taking full ownership of the correctness and quality of work reaching production
• Integrate LLM/AI capabilities into BNL solutions where needed
• Develop and evaluate options in infrastructure planning to support new applications and technologies
• Work with stakeholders across the organization to understand business needs and design dashboards, analytics, and scalable data products that answer real questions and drive decisions
• Partner with analysts and business teams to convert manual processes into automated, reusable data products the organization relies on
• Executes duties and maintains standards in accordance with company policies and procedures
• Additional duties as required
• Overtime hours may be required as job duties demand

Skills/Qualifications:

• Working knowledge of Python and SQL programming languages
• Cloud platform exposure; Azure strongly preferred
• Ownership mindset with a drive to convert complex, manual problems into durable, automated solutions
• Business curiosity and a genuine interest in understanding how the business works, with a focus on building analytics that solve real problems
• Self‑starter with a proven ability to work independently, demonstrating resourcefulness in problem‑solving and decision‑making
• Excellent organization and planning skills; ability to prioritize and work on multiple projects and follow through in a timely manner
• Effective verbal and written communication skills with the ability to collaborate with stakeholders at all levels of technical knowledge
• High‑level proficiency in Microsoft Office, including Word, Excel, PowerPoint, and Outlook
• Solid work ethic and a professional, proactive, and positive approach to work

Education/Experience:

• Bachelor’s degree in Applied Statistics, Computer Science, Data Science, Information Systems, or related discipline from a four‑year accredited college or university required
• 1-3+ years of data, software, or analytics engineering experience
• Familiarity with Power BI, including building datasets
• Azure Data Factory, Functions, or DevOps experience strongly preferred
• Experience building APIs with FastAPI or consuming external data APIs a plus
• Experience integrating LLM/AI APIs or with AI‑assisted development a plus
• Azure WebApp services a plus

Environment and Physical Demands:

• Professional office environment with routine use of standard office equipment such as computers, phones, photocopiers, filing cabinets, and fax machine; noise level typical of a standard office environment
• Prolonged sitting, computer and telephone use, as well as standing, filing, stooping, bending, reaching and lifting, and carrying up to 15 pounds
• Ability to travel by plane, train, and automobile and operate a motor vehicle

The above description is not intended to define, in detail, the multitude of tasks that may be assigned, but rather to provide a general sense of the responsibilities and expectations of the position. As the nature of business demands change, so too may the functions of this position.

Our employees are our most valuable assets. To reward their commitment, we strive to provide a competitive and flexible mix of total rewards that have their best interests in mind and enhance our employee‑centric culture.

The base salary range for this role is: $65,000 - $80,000. This range is Broadstone’s good faith estimate of the annual base salary it reasonably expects to pay for the position at the time of this posting. The stated salary range does not include other forms of compensation or benefits offered in connection with the advertised role, such as performance‑based cash bonuses and restricted stock grants. There are several factors taken into consideration in making compensation decisions including but not limited to the individual’s experience, skillset, relevant education & certifications, job‑related knowledge, location, and other relevant factors identified through the recruitment & selection process.

We are committed to complying with all legal posting and notice requirements. Physical postings and notices are generally placed in Broadstone’s Corporate Offices and on Broadstone’s intranet platform. All such postings and notices are also linked here . If you need a physical or electronic copy of any required posting or notice, or if you believe that any required posting or notice has been removed or is missing, please contact Human Resources.