Business Intelligence Analyst

About Us Inspired by Spaces, Empowered by People. At Enclave, we don't just build structures; we cultivate environments where our partners, team members, and communities flourish. Our very name reflects our essence - creating distinct spaces that inspires growth and success. As a unified real estate investment firm, Enclave brings together exceptional development, construction, and property management expertise to specialize in multifamily, industrial, and commercial developments across the Midwest and Mountain West.

Our Growth Story:
Since our founding in 2011, we've expanded to over 250 team members, completing more than 150 projects and managing assets exceeding $1.75 billion. Our rapid growth is a testament to the innovative and collaborative spirit that drives everything we do. For six consecutive years, Enclave has been recognized as one of the 50 Best Places to Work. This accolade reflects our commitment to fostering an environment where everyone feels valued, supported, and inspired to excel.

About the Role Business Intelligence Analyst The Business Intelligence Analyst serves as a strategic partner to FP&A, business leaders, and IT, translating financial, operational, and strategic business needs into scalable reporting, analytics, and business intelligence solutions. This role combines strong technical expertise with financial and business acumen to improve data accessibility, reporting capabilities, operational efficiency, and decision support across the organization.

The Business Intelligence Analyst partners closely with FP&A, business leaders, and the data warehouse team to transform complex financial and operational data into trusted insights that support informed business decisions.

Position Information Primary

Work Location:

Fargo, ND or St. Louis Park, MNWork Environment:
On-Site Work Type:
Full-time, Exempt Responsibilities Finance  and Business Partnership Partner with Finance, FP&A, business leaders, and IT to understand reporting, planning, forecasting, and analytics needs and develop practical solutions that support business goals.

Lead conversations with stakeholders to understand business needs, current processes, challenges, data sources, and desired outcomes.

Translate business needs into clear requirements, process documentation, report specifications, and prioritized projects.

Manage and prioritize reporting and analytics requests, balancing ongoing reporting, strategic projects, data quality, and ad hoc needs.

Develop a strong understanding of business systems and processes to identify gaps, clarify responsibilities, and recommend improvements.

Business Intelligence, Reporting, and Analytics Design, develop, maintain, and improve Power BI dashboards, reports, scorecards, and analytical tools for executive and operational audiences.

Analyze financial and operational data to identify trends, variances, risks, opportunities, and performance drivers, and communicate insights clearly.

Establish consistent reporting definitions, calculations, measures, and business rules while reducing manual reporting, consolidating duplicate reports, and increasing automation and self-service capabilities.

Use advanced Excel capabilities for analysis, reconciliation, forecasting, scenario modeling, and business reporting.

Support self-service reporting by creating reliable datasets, reusable report templates, clear documentation, and user guidance.

Data Modeling and Technical Development Develop and maintain Power BI semantic models using dimensional-modeling principles, well-defined relationships, measures, dimensions, and hierarchies.

Use SQL, DAX, and Power Query to query, validate, transform, and analyze data.

Leverage Microsoft Fabric and related Microsoft data tools to support reporting and analytical solutions.

Partner with technical resources to ensure reporting requirements are reflected in data models, transformations, and reporting structures.

Support appropriate data security, access controls, and report performance optimization.

Data Warehouse and Systems Integration Partner with IT, data engineering resources, external consultants, and business stakeholders to define data requirements and improve data integration, automation, and accessibility.

Understand how financial and operational data flows across source systems, Rayfin, data warehouse layers, semantic models, and reporting solutions.

Participate in testing and validation of data pipelines, integrations, and reporting outputs and maintain documentation of…