Business Intelligence Analyst

Savills North America; New York (NY); Hybrid; USD 80,000 - 115,000; Full time

Job summary

Savills in New York seeks an Analyst, Business Intelligence to support capital projects analytics and reporting. You will prepare, validate, and visualize data for client-facing and internal reports using Excel and BI tools, and own recurring dashboards.

You will collaborate with project leadership to gather requirements, build dashboards in Power BI or Tableau, reconcile data, and contribute to reporting improvements while working in a hybrid model (office Mon-Thu, Fridays remote when possible).

Qualifications

• 2–4 years of experience in data analysis, BI, or a related field.
• Bachelor’s degree in a quantitative, analytical, or business-related field.
• Strong proficiency building dashboards in Power BI, Tableau, or similar tools.
• Experience owning recurring reports or dashboards in a business or client-facing environment.
• Independent and detail-oriented with clear communication.

Responsibilities

• Prepare, validate, and visualize project data using Excel and reporting tools.
• Build dashboards in Power BI and Tableau and maintain them.
• Own recurring reports and dashboards within established standards.
• Support reporting for budgets, schedules, risks, and KPIs.
• Collaborate with project teams to gather requirements and meet deadlines.
• Document data sources, assumptions, and calculations.

Skills

Data analysis

Power BI

Tableau

Excel

Independent worker

Communication

Education

Bachelor's degree in a quantitative field

Tools

Smartsheet

Job description

Savills is an organization full of extraordinary individuals. Brilliant people who are driven to succeed, hungry to remain at the forefront of their specialties, and eager to propel themselves, our clients, and our business forward. We are one of the preeminent commercial real estate firms with services ranging from tenant representation and project management to workplace strategy and occupant experience - showcasing the breadth and depth of our expertise.

Find your place to thrive.

No matter the role you're in, we all share one purpose: to help people thrive through places and spaces. The DNA ingrained in our business guides us on this mission, shaping the way we behave to deliver the best results. When you join Savills, our ask for you is simple:

Be extraordinary, together.

ABOUT THE ROLE

The Analyst, Business Intelligence supports Savills' capital project and program management (PPM) analytics and reporting efforts. This role is intended for an analytically strong professional who already has tangible hands-on experience delivering business intelligence & reporting solutions. They should be comfortable operating independently on assigned reporting and analytics responsibilities.

The Analyst will work closely with project leadership and internal teams to prepare, validate, and visualize data used in both client-facing and internal reporting. This role requires an individual who is comfortable working in Excel and BI tools and can quickly take ownership of recurring reporting within established standards and processes with limited ongoing technical supervision.

KEY DUTIES AND RESPONSIBILITIES

Data Analysis and Reporting

• Prepare, review, and validate project and portfolio data using Excel and established reporting tools.
• Build, update, and maintain dashboards in Power BI and/or Tableau.
• Own recurring reports and dashboards within established standards and processes, ensuring accuracy, consistency, and timely delivery.
• Perform reconciliations, calculations, and quality checks to identify and resolve data issues.
• Clearly document assumptions, calculations, and data sources used in reporting.

Project Data Support

• Support reporting related to capital projects, including budgets, commitments, invoices, schedules, risks, and other project-related key performance metrics.
• Organize and structure project data for reporting and analysis.
• Produce reports to roll-up to portfolio, program, and/or project levels.
• Respond to ad hoc reporting requests with defined requirements.

Collaboration and Execution

• Partner with project leadership and internal teams to understand reporting needs and deadlines.
• Coordinate with teams to collect, verify, and reconcile data inputs.
• Incorporate feedback efficiently into reporting deliverables.
• Escalate data quality or logic issues appropriately when clarification is required.
• Identify opportunities to improve reporting clarity, efficiency, and data accuracy.
• Contribute to incremental improvements in templates, documentation, and reporting workflows.
• Apply lessons learned to reduce rework and improve reporting reliability over time.

QUALIFICATIONS

REQUIRED

• 2-4 years of experience in data analysis, business intelligence, or a related field.
• Bachelor’s degree in a quantitative, analytical, or business-related field (e.g., Information Systems, Data Analytics, Finance, Economics, Real Estate, Engineering, Mathematics, or similar).
• Strong proficiency and hands-on experience building or maintaining dashboards in Power BI, Tableau, or similar BI tools.
• Experience owning recurring reports or dashboards in a business or client-facing environment.
• Comfort working independently and managing deliverables with limited supervision.
• Strong analytical thinking and attention to detail.
• Clear written and verbal communication skills.

PREFERRED

• Experience working with project management, real estate, construction, or financial data.
• Familiarity with Smartsheet or similar project tracking tools.
• Exposure to data validation, reporting automation, or data transformations.
• Experience supporting reporting for multiple stakeholders or projects simultaneously.

WORK ENVIRONMENT

This role requires being in the office or on a client site Monday-Thursday. Friday is remote unless project needs require otherwise.

Savills values a diverse work environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity or expression, sexual orientation, national origin, genetic information, disability, age, veteran status, or any other protected characteristic.

Savills participates in the E-Verify program.