Senior Associate, Business Intelligence Engineering

Core Spaces; United States; On-site; USD 90,000 - 115,000; Full time

Benefits offered by this job

Health insurance

401(k) matching

Paid time off

Wellness allowance

Phone reimbursement

Parental leave

Volunteer time off

Retirement options

Job summary

Core Spaces is seeking a Senior Associate, Business Intelligence Engineering to own reporting and analytics powering decision-making across Finance, People Operations, Student Housing, Build-to-Rent, Construction, Marketing, and Investments.

The role requires designing, building, and maintaining semantic models, data pipelines, and Power BI solutions across Azure, Databricks, Delta Lake, Unity Catalog, and Power BI.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, or related field.
• 3+ years of hands‑on experience developing production BI and analytics solutions, including Power BI semantic models, data modeling, performance optimization, deployment practices, and production support.
• Advanced proficiency in Power BI, DAX, and Power Query (M), including time intelligence and measure performance tuning.
• Deep dimensional modeling experience, including star schema design, grain selection, conformed dimensions, slowly changing dimensions, and fact table design.
• Strong SQL development skills, including window functions, CTEs, complex joins, and query tuning.
• Working proficiency in PySpark or Python for data transformation and pipeline development.
• Hands‑on experience with Databricks, Delta Lake, and Unity Catalog in a governance context.
• Experience designing, building, maintaining, and troubleshooting orchestrated data pipelines.
• Ability to translate designs and business outcomes into scalable solutions, identifying missing data and dependencies.

Responsibilities

• Own the end-to-end delivery of production Power BI reports and dashboards from approved designs.
• Lead as a senior owner of the Power BI semantic layer, including star schemas and DAX libraries.
• Collaborate with Product Management to validate feasibility, data availability, and performance.
• Determine upstream data, modeling approach, and pipeline logic for reporting needs.
• Translate dashboard intent into Power BI implementation, including navigation and UX patterns.
• Design, develop, and maintain data ingestion and transformation pipelines using Spark SQL, PySpark, and Delta Live Tables.
• Onboard new source systems and coordinate validation with stakeholders.
• Implement business logic and measures in DAX per business definitions.
• Investigate and resolve data quality and performance issues at source layers.
• Validate figures against systems of record before release for financial and operational decisions.
• Optimize performance through query tuning, storage decisions, and partitioning strategies.
• Manage Power BI delivery lifecycle across development, testing, deployment, and production support.
• Operate independently across concurrent BI initiatives and communicate risks and next steps.
• Contribute to documentation, standards, patterns, and knowledge sharing.
• Occasional travel may be necessary.

Skills

Power BI

DAX

SQL

PySpark

Python

Databricks

Delta Lake

Unity Catalog

Azure Data Factory

Education

Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, or related field

Tools

Delta Live Tables

Azure Databricks

Power BI Service

Databricks Workflows

Job description

Who We Are

Core Spaces (Core) is more than a real estate company; it’s a people company. Where building relationships is just as important as building properties. From researchers and architects to designers and operators, Core is made up of risk takers and dreamers who are on a mission to invent the future of living. Our six cultural values guide us every day and we strive to live them in everything we do: PUSH (Invent Better Places to Live), GRIT (We Got This), LIFT (Help Each Other Win), SHINE (Bring Your Full Self), UPHOLD (Never Break Trust), GROW (Always Get Better). Everything Core does stem from this culture of collaboration and innovation, and the drive to constantly improve the resident experience. This unique approach has led to creating spaces and services that are redefining the way people live.

Who We Are

Core Spaces (Core) is more than a real estate company; it’s a people company. Where building relationships is just as important as building properties. From researchers and architects to designers and operators, Core is made up of risk takers and dreamers who are on a mission to invent the future of living. Our six cultural values guide us every day and we strive to live them in everything we do: PUSH (Invent Better Places to Live), GRIT (We Got This), LIFT (Help Each Other Win), SHINE (Bring Your Full Self), UPHOLD (Never Break Trust), GROW (Always Get Better). Everything Core does stem from this culture of collaboration and innovation, and the drive to constantly improve the resident experience. This unique approach has led to creating spaces and services that are redefining the way people live.

What We Do

Founded in 2010, Core is a vertically integrated real estate investment manager focused on acquiring, developing and managing across the student housing and build-to-rent ("BTR") sectors. Its residential communities feature world-class amenities, progressive design, and hospitality-driven service. Core’s student housing portfolio includes over 74,440 beds currently owned or managed, with a pipeline of over 53,860 beds in various stages of development. Core’s BTR division has over 3,000 homes under development, now leasing or in its pipeline in high-growth metros nationwide. For more information, visit www.corespaces.com.

• Portfolio and pipeline numbers as of Q2 2026

Benefits That Matter

• A culture that provides you with a sense of belonging
• Competitive pay that values your contributions
• Incentives designed to reward your achievements
• Paid flexible PTO to disconnect or celebrate life milestones
• Paid 14+ holidays, including your birthday, to disconnect and celebrate
• Paid Parental Leave that begins after 90 days
• Paid volunteer time off to give back to your community
• Monthly workshop weeks; fewer meetings & more collaboration
• Robust health plan options that begin within at least 30 days of your employment
• Monthly phone reimbursement
• Wellness allowance and perks, including a yearly subscription to a meditation app
• An environment that provides you a voice to share your perspectives
• Employee Assistance Program (EAP) for access to confidential support services
• Company retirement options including 401(k) + matching & Roth account option

Position Overview

Core Spaces is seeking a Senior Associate, Business Intelligence Engineering to own the reporting and analytics solutions that power decision-making across the business, translating complex data needs into scalable, trusted, and actionable insights. The Senior Associate is responsible for designing, building, and maintaining the semantic models, data models, data pipelines, and Power BI solutions that support decision-making across Finance, People Operations, Student Housing, Build-to-Rent, Construction, Marketing, and Investments. Working across a diverse technology landscape, the Senior Associate must navigate varying source systems, data structures, business definitions, and reporting requirements to deliver consistent and reliable analytics solutions across the business.

Core's analytics platform is built on Azure, Databricks, Delta Lake, Unity Catalog, and Power BI, and this role plays a critical part in developing the data foundation that powers business reporting. The Senior Associate will evaluate reporting requirements beyond the dashboard layer, identifying when new measures, business logic, data structures, or source system integrations are needed. Rather than relying on report-level workarounds, this individual is expected to architect and implement sustainable solutions that address challenges at the source while balancing strong technical expertise with a practical understanding of business needs.

What You Will Do

• Own the end-to-end technical delivery of production Power BI reports and dashboards from approved mockups, wireframes, and specifications, ensuring final solutions accurately reflect design intent while meeting standards for usability, performance, governance, accessibility, and long-term maintainability.
• Serve as a senior technical owner of the Power BI semantic layer, including star schema data models, reusable DAX measure libraries, calculation groups, incremental refresh configuration, row-level security, certification standards, and ongoing model stewardship.
• Partner with Product Management before development begins to validate technical feasibility, confirm data availability, surface design gaps or ambiguities, assess performance implications, estimate level of effort, and recommend implementation tradeoffs that balance speed, accuracy, scalability, and business value.
• Determine the upstream data, modeling approach, and pipeline logic required to support reporting outcomes, including situations where a needed measure, dimension, attribute, relationship, history, or grain does not currently exist in the data platform.
• Translate dashboard intent into the correct Power BI implementation, including visual selection, page structure, drill-through paths, bookmarks, cross-filtering behavior, slicer and parameter configuration, tooltip design, navigation, and user experience patterns appropriate for executive, operational, and analytical audiences.
• Design, develop, and maintain data ingestion and transformation pipelines using Spark SQL, PySpark, Delta Live Tables, and Databricks Workflows, ensuring pipelines are reliable, documented, observable, and aligned with enterprise data architecture standards.
• Onboard new source systems into the data platform as additional business functions come into reporting scope, including evaluating source data structures, defining ingestion patterns, mapping business entities, establishing refresh cadence, and coordinating validation with the appropriate stakeholders.
• Implement complex business logic and measure calculations in DAX consistent with business definitions established through Product Management, documenting assumptions, calculation methodology, dependencies, limitations, and downstream reporting impact.
• Investigate, diagnose, and resolve data quality, data integrity, reconciliation, and performance issues at the appropriate source layer, partnering with data architecture, engineering, product, and business stakeholders as needed to prevent recurring issues.
• Validate reported figures against applicable systems of record before release, including reconciling key metrics, documenting exceptions, escalating unresolved discrepancies, and ensuring reporting outputs can be trusted for financial and operational decision-making.
• Optimize report, semantic model, and pipeline performance through query tuning, aggregation strategy, storage mode selection, model size management, refresh duration analysis, partitioning strategy, and effective use of Power BI and Databricks capabilities.
• Manage the Power BI delivery lifecycle across development, testing, deployment, and production support, including workspace and app structure, deployment pipelines, promotion across environments, refresh monitoring, failure remediation, gateway configuration, access management, and release readiness.
• Operate independently across concurrent reporting and data engineering initiatives, proactively communicating status, risks, dependencies, tradeoffs, and recommended next steps to Product Management, Data and Analytics leadership, and business stakeholders.
• Contribute to documentation, technical standards, reusable patterns, and knowledge sharing that improves team efficiency and supports consistent reporting practices as Core’s analytics environment scales.
• Occasional travel may be necessary as needed.
• Perform all other duties and tasks as assigned by management.
• Must be able to complete all physical requirements of this role with or without a reasonable accommodation.

Ideally, You’ll Have

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field; or equivalent combination of education and professional experience.
• 3 or more years of hands‑on experience developing production business intelligence and analytics solutions, including significant ownership of Power BI semantic models, data modeling, performance optimization, deployment practices, and production support.
• Advanced proficiency in Power BI, DAX, and Power Query (M), including filter context, context transition, time intelligence, measure branching, calculation groups, row-level security, and measure performance tuning.
• Deep dimensional modeling experience, including star schema design, grain selection, conformed dimensions, slowly changing dimensions, fact table design, relationship strategy, model refactoring, and the ability to design models that scale across multiple reporting use cases.
• Strong SQL development skills, including window functions, common table expressions, complex joins, query tuning, reconciliation logic, and development against large and complex fact tables.
• Working proficiency in PySpark or Python for data transformation, pipeline development, automation, and troubleshooting within a modern cloud data platform.
• Hands‑on experience with a modern lakehouse or cloud data platform, ideally Databricks with Delta Lake and Unity Catalog, including an understanding of governed data access, catalog structure, and production data management practices.
• Experience designing, building, maintaining, and troubleshooting orchestrated data pipelines using Databricks Workflows, Delta Live Tables, Azure Data Factory, or equivalent tooling.
• Demonstrated ability to translate designs, mockups, specifications, and business outcomes into scalable technical solutions, including identifying missing data, ambiguous logic, modeling gaps, and downstream dependencies before development begins.
• Demonstrated ability to work independently with limited day‑to‑day direction, exercise sound technical judgment, prioritize competing work, communicate tradeoffs, and make recommendations that account for accuracy, maintainability, scalability, and business impact.
• Strong attention to detail and a demonstrated commitment to data accuracy, particularly for reporting used in financial, operational, executive, or compliance‑sensitive decision‑making.

You’ll Crush It If You Have Experience With

• Databricks with Unity Catalog, Delta Lake, and Delta Live Tables.
• Microsoft Fabric, including Lakehouse architecture, Direct Lake semantic models, and capacity management.
• Student housing, build‑to‑rent, multi‑family, real estate, or PropTech data, ideally supporting a vertically integrated owner and operator.
• Property management, ERP, HRIS, or construction management platforms and their underlying data structures, such as Entrata, Yardi, RealPage, Workday, or Procore.
• Revenue management, pricing, or forecasting analytics, including pre‑lease pace, net effective rent, and absorption reporting.
• Working within an Agile delivery process alongside Product Management, including Azure DevOps boards, sprint planning, and backlog refinement.
• Data quality testing frameworks and data pipeline observability practices.

Organizational Structure

Reports to: Director, Data Architecture and Engineering

Direct Reports: N/A; this is a senior individual contributor role.

Disclaimer

Please note that job responsibilities, reporting lines, and duties outlined in this job description are subject to change to meet the evolving needs of the organization.

As an Equal Opportunity Employer, Core Spaces celebrates diversity and is committed to creating an equitable and inclusive environment, which creates a sense of belonging for all employees. We do not discriminate and believe every individual should be proud of who they are and the community they represent.

Pay Range

USD $90,000.00 - USD $115,000.00 /Yr.

Additional Compensation

Employees may be eligible for discretionary bonuses, typically up to 10% of base salary annually, depending on individual and organizational performance.

Compensation Disclosure

The compensation range listed reflects the base salary or hourly rate that we reasonably and in good faith expect to offer for this role at the time of posting. Actual compensation may vary based on factors such as education, experience, skills, certifications, seniority, geographic location, and business needs.

This role may be eligible for additional forms of compensation, including bonuses, commissions, stipends, or non-cash incentives, depending on position and performance. Benefits may include health insurance, retirement plans, paid time off, and other role‑based offerings, subject to eligibility requirements.

All compensation components are subject to change based on business needs or market conditions.