Associate, Business Intelligence Engineer

About EQ Office
EQ Office is Blackstone’s US office portfolio company with best-in-class expertise across acquisitions, asset management, leasing, redevelopment, and property operations. EQ’s focus is to create and operate inspiring workplace destinations by offering solutions that blend the best of work, home, and hospitality. Our diverse team of ~160 professionals currently operates a portfolio of over 20 million square feet for approximately 1,200 customers across major US markets including Atlanta, Boston, Chicago, Los Angeles, New York, San Francisco, and Seattle. OneTeam is EQ’s Core Foundation. It's that innovative idea that starts to stick when we come together under one roof; it's the desire to be part of something bigger than ourselves, striving to find greater purpose. By sharing best practices across departments and regions, extending impact beyond work and into our communities, and integrating our foundational principles, we ultimately do better when we operate together. At EQ Office, our culture is centered around OneTeam with the following principles: Kindness, Respect and Trust; Merit; Accountability; Integrity; Essential Transparency; Never be Complacent; Work Hard and Have Fun.

Role Summary
Collaborating with the Head of Technology, the Business Intelligence Engineer will design, develop, and support business intelligence solutions that turn data into actionable insights that support business decision-making, analytics, and product development. An ideal candidate should be very data-savvy, with solid skills in data modeling, data visualization, and overall business intelligence solutions.

Essential Job Functions
- Collaborate with internal business stakeholders to gather business needs and translate requirements into specifications and actionable data requests.
- Develop detailed requirements documentation (user stories, design specifications, data flows, acceptance criteria).
- Lead data architecture efforts to structure and maintain data in the enterprise for optimal accuracy and usage.
- Design, develop, and maintain data models and scalable reports, dashboards, and visualizations to support analytical and business needs.
- Optimize performance of data queries and processes to ensure efficient data retrieval and processing.
- Ensure data quality and integrity through validation and monitoring processes.
- Extract, transform, load (ETL), and maintain data from various sources in the data warehouse.
- Create and manage complex SQL queries and views, including those used in ETL scripts or transformations using DBT.
- Establish and maintain standard processes for the design, development, and support of BI solutions.
- Process, clean, and validate data integrity for analysis.
- Respond and resolve operational problems as necessary. Document, troubleshoot, and resolve day-to-day data issues.
- Must be willing to travel 20% of the time and be in the office 5 days a week.

Core Competencies
- Resourcefulness: Access resources effectively and quickly; detail-oriented.
- Attention to Detail: Thorough and precise in analyzing data and preparing reports.
- Time Management: Strong organizational skills and ability to manage multiple tasks efficiently.
- Problem Solving: Aptitude for identifying complex problems and formulating creative solutions.

Technical Competencies
- Experience with relational and dimensional database modeling (Relational, Kimball, Data Vault).
- Strong experience designing and deploying full stack data analytics platforms (cloud-based data warehouse technologies, data visualization tools such as PowerBI and Tableau).
- In-depth understanding of database management systems, OLAP & ETL frameworks, Databricks, Delta Lake.
- Familiarity with Microsoft Azure Data Integration Stack and related cloud services (Azure Data Lake Gen2, Azure Data Factory, SSIS, Azure SQL Server).
- Proficiency in SQL and experience with relational databases (SQL Server, MySQL, PostgreSQL).
- Experience with ETL tools (DBT, Apache Airflow, Talend, Informatica).
- Proven experience with all aspects of the Data Pipeline (Data Sourcing, Transformations, Data Quality, etc.).
- Strong programming skills in languages such as Python, Java, or Scala.
- Experience with big data technologies (Hadoop, Spark) and cloud platforms (Azure, Snowflake, AWS, GCP).
- Familiarity with data visualization tools (Tableau, Power BI, Sigma) and BI concepts.
- Familiarity with LLMs (e.g., GPT 3.5, 4.0, Gemini, Microsoft Co-Pilot).
- Excellent technical documentation and writing skills, and experience in publishing API documentation or similar.
- Experience with visual modelling tools including UML.

Preferred Qualifications
- Bachelor’s degree in Computer Science, Engineering, or related field.
- Certification in relevant technologies (e.g., AWS Certified Big Data - Specialty, Microsoft Certified: Azure Data Engineer Associate).

Closing
- Base Salary Range: $145,000 – $185,000 (subject to variation based on location and experience).
- Benefits include health insurance coverage, retirement savings plan, paid holidays, and paid time off (PTO). The additional total direct compensation and benefits are subject to the terms and conditions of applicable governing plans and policies.

EEO Statement
Our company is proud to be an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees, basing our employment decisions on individual qualifications and business needs, without regard to race, color, marital status, sex, sexual orientation, gender identity, age, religion, disability, citizenship status, national origin, pregnancy, veteran status, or any other legally protected characteristics. We provide reasonable accommodations for applicants needing assistance in the application process; please email recruiting@eqoffice.com.