Senior BI Engineer — Power BI & Data Platform

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

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.