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 operate 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 what happens when individuals collaborate across team, function, and time zone. 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 department and region, 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, and should have solid skills in data modeling, data visualization, and overall business intelligence solutions.

Essential Job Functions

• Collaborate with internal business stakeholders to gather business needs, define and translate business requirements into specifications and actionable data requests.
• Develop detailed requirements documentation, including user stories, design specifications, data flows, and acceptance criteria.
• Lead data architecture efforts to structure, integrate, govern, store, describe, model, and maintain data in the enterprise for optimal accuracy and usage

• Design, develop, and maintain data models and scalable, automated reports, dashboards, visualizations, etc., that will support our analytical and business needs.

• Optimize performance of data queries and processes to ensure efficient data retrieval and processing.

• Ensure data quality and integrity by implementing data validation and monitoring processes

• Extract, transform, load, and maintain data from various sources in the data warehouse

• Create and handle 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 the integrity of data to be used for analysis
• Respond and resolve operational problems as necessary. Document, troubleshoot, and resolve day-to-day data issues

Core Competencies:  

• Resourcefulness: Accesses resources effectively and quickly to get things done; arranges information and files in a useful manner; is detail-oriented
• Attention to Detail: Thoroughness and precision in analyzing data, preparing reports, and executing transactions accurately
• Time Management: Strong organizational skills and the ability to manage multiple tasks and priorities efficiently, meeting deadlines in a fast-paced environment
• Problem Solving: Aptitude for identifying complex problems, formulating creative solutions, and making sound decisions under pressure
  

Technical Competencies:

• Experience with relational and dimensional database modelling (Relational, Kimball, Data Vault)

• Strong experience designing and deploying full stack data analytics platforms including the use of cloud-based data warehouse technologies and data visualization tools such as PowerBI and Tableau
• In-depth understanding of database management systems, online analytical processing (OLAP & ETL (Extract, transform, load) frameworks, Databricks, Delta Lake
• Experience 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 (e.g., SQL Server, MySQL PostgreSQL)
• Experience with ETL tools (e.g., 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 (e.g., Hadoop, Spark) and cloud platforms (e.g., Azure, Snowflake, AWS, GCP)
• Familiarity with data visualization tools (e.g., Tableau, Power BI, Sigma) and BI concepts
• Familiarity with LLMs (e.g., GPT 3.5, 4.0, Gemini, Microsoft Co-Pilot etc)

• Excellent technical documentation and writing skills, and have published 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)
• Must be willing to travel 20% of time

--------------------------------------------

Closing

Base Salary Range: $145,000 – $185,000.  This represents the presently-anticipated low and high end of the Company’s base salary range for this position.  Actual base salary range may vary based on various factors, including but not limited to location and experience. 

Benefits:  The Company provides a variety of benefits to employees, including health insurance coverage, retirement savings plan, paid holidays and paid time off (PTO).

The additional total direct compensation and benefits described above are subject to the terms and conditions of any governing plans, policies, practices, agreements, or other materials or documents as in effect from time to time, including but not limited to terms and conditions regarding eligibility.

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. Our employment decisions are based on individual qualifications, job requirements and business needs without regard to race, color, marital status, sex, sexual orientation, gender identity and/or expression, age, religion, disability, citizenship status, national origin, pregnancy, veteran status and or any other legally protected characteristics. We are committed to providing reasonable accommodations, if you need an accommodation to complete the application process, please email recruiting@eqoffice.com