Business Analytics Engineer

Business Analytics Engineer will design, develop, and maintain data, analytics, reporting, and geospatial solutions that support real estate portfolio decisions.

Responsibilities

• Develop and maintain reporting, analytics, and geospatial solutions to improve visibility into portfolio performance, workplace trends, operational metrics, and business outcomes
• Transform, validate, and manage data from multiple sources to support portfolio intelligence, operational reporting, forecasting, and decision support
• Partner with business stakeholders, account teams, and clients to translate business requirements into reusable technical solutions
• Support portfolio planning, workplace strategy, occupancy analysis, location intelligence, and operational decision-making through insight generation and visualization
• Identify opportunities to improve efficiency through automation, standardization, and adoption of emerging technologies, including AI-enabled tools
• Support the continued evolution of PAG’s analytics, reporting, geospatial, and technology capabilities
• Build and maintain dashboarding and reporting solutions for portfolio performance, workplace strategy, occupancy trends, operational efficiency, and service delivery using Power BI, Looker, Tableau, or similar platforms
• Create and maintain data pipelines, transformation processes, and data models that support analytics and reporting solutions, with Databricks experience strongly preferred
• Integrate data from internal systems, client platforms, commercial real estate technologies, and external sources
• Develop and maintain ArcGIS Online environments, maps, dashboards, and geospatial data products for location intelligence, market analysis, portfolio optimization, workplace planning, and operational decision-making
• Identify opportunities to automate repetitive reporting, data preparation, and operational processes
• Leverage AI-enabled tools to improve productivity, accelerate development, and enhance analytics capabilities
• Communicate technical concepts clearly to both technical and non-technical audiences
• Support user adoption, training, documentation, and continuous improvement efforts

Requirements

• 3-7 years of experience in business analytics, business intelligence, analytics engineering, reporting, data engineering, or related fields
• Experience developing dashboards, reporting solutions, and analytical products used by business stakeholders
• Experience with business intelligence platforms including Power BI, Tableau, Looker, or similar tools
• Experience building and maintaining data pipelines within modern cloud analytics platforms, with Databricks experience strongly preferred
• Strong problem-solving, analytical thinking, and data interpretation skills
• Experience gathering requirements and working directly with business stakeholders
• Ability to translate business requirements into technical solutions and explain complex concepts to business stakeholders, account teams, and clients
• Excellent written and verbal communication skills
• Experience with Databricks, Delta Lake, Unity Catalog, or modern cloud-based analytics platforms
• Experience using Python for analytics, automation, reporting, or workflow development
• Experience supporting commercial real estate, corporate real estate, portfolio planning, workplace strategy, occupancy management, facilities management, or related business functions
• Experience with ArcGIS Online, ESRI products, or geospatial analytics platforms
• Experience within consulting, professional services, or client-facing environments
• Experience leveraging AI-enabled tools such as Microsoft Copilot, Claude, Gemini, ChatGPT, or similar technologies
• Experience working with enterprise reporting, operational analytics, portfolio analytics, workplace analytics, or business performance management

Technologies

• Power BI, Looker, Tableau
• Databricks
• ArcGIS Online, ESRI
• SQL, Python
• Delta Lake, Unity Catalog
• Microsoft Office Suite (Excel, PowerPoint, Word)
• Google Workspace (Sheets, Docs, Slides)
• Microsoft Copilot, Claude, Gemini, ChatGPT

Location

• Creve Coeur, MO (onsite)

Compensation

• USD 106,250 - 125,000 per year

Education

• Bachelor’s degree in Data Analytics, Information Systems, Computer Science, Business, Geography/GIS, Engineering, Mathematics

Benefits

• Health, vision, and dental insurance
• Flexible spending accounts
• Health savings accounts
• Retirement savings plans
• Life and disability insurance programs
• Paid and unpaid time away from work
• Competitive pay (varies by eligibility factors such as geographic location, date of hire, total hours worked, job type, business line, and applicability of collective bargaining agreements)
• Opportunity to enroll in a variety of benefit programs

What “Success” Looks Like

• Stakeholders trust the data, reporting, and analytics solutions used for business and real estate decisions
• Reporting and analysis processes become more automated, scalable, and consistent
• Business users spend less time gathering, validating, and preparing data and more time acting on insights
• Analytics and geospatial solutions become integrated into standard account operations and decision-making
• Stakeholders use reporting, analytics, and geospatial solutions to support portfolio planning, occupancy strategy, location decisions, operational performance, and workplace initiatives