Business Intelligence Analyst

At Enclave we dont 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 weve 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.

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.

• Primary Work Location: Fargo ND or St. Louis Park MN
• Work Environment: On-Site
• Work Type: Full-time Exempt

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 KPI definitions business rules data sources and reporting logic.

Data Quality Governance and Continuous Improvement

• Monitor and resolve data quality reconciliation access performance and reporting issues in partnership with appropriate stakeholders.
• Drive continuous improvement by automating manual processes simplifying analysis improving reporting efficiency and expanding access to trusted information.
• Develop and execute testing coordinate user acceptance testing and reconcile reporting to source systems and approved business totals.
• Document report purpose data sources definitions assumptions business rules and ownership to support consistency and long-term maintainability.
• Train and support business users on Power BI trusted datasets report interpretation and self-service analytics.
• Support emerging AI and advanced analytics initiatives by helping define business value data requirements validation criteria risks and governance considerations.

• Bachelors degree in Information Systems Data Analytics Finance Accounting or a related field; equivalent experience may be considered.
• 3 years of experience in business intelligence data analysis financial analysis reporting business analysis or a related field.
• Experience with Microsoft Fabric OneLake Fabric Data Warehouse Lakehouse Data Factory or related Microsoft cloud analytics capabilities.
• Hands-on experience developing Power BI reports and semantic models using DAX and Power Query.
• Working proficiency with SQL for data analysis reconciliation testing and validation.
• Experience gathering and documenting business requirements and translating them into reporting analytics or process-improvement solutions.
• Experience with dimensional data modeling KPI development data visualization data quality and user acceptance testing.
• Working knowledge of financial and operational reporting including budgeting forecasting variance analysis and performance metrics.
• Ability to communicate complex data and technical concepts clearly to both business and technical audiences.
• Ability to lead requirements discovery clarify ambiguous requests define KPIs and business rules and establish measurable acceptance criteria.

The physical requirements listed here are representative of those that must be met by an employee to successfully perform the essential functions of the job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• This position requires the ability to sit or stand for extended periods of time while performing office tasks and have the capacity to maintain proper posture and ergonomics to prevent discomfort or injury.
• This position requires manual dexterity and proficiency in using computer keyboards mice and other office equipment.
• This position must have the ability to handle and manipulate paperwork files and office supplies.
  
• This role may occasionally visit construction sites to where they will be exposed to the outdoors and possible inclement weather conditions.

When you become part of Enclave you join a team of trailblazers in the real estate construction and property management industry. Our collaborative and fun-loving culture encourages you to thrive both professionally and personally. Our Core Values define what we say and do.

• Care For Each Other: We value people for who they are and take pride in our relationships with team members clients and partners
• Do The Honorable Thing: We are committed to upholding the highest standards in our words and actions.
• Be Empowered: We encourage true autonomy which results in team members who are remarkably inspired and high-performing.
• Promote Innovation: We constantly reach further and dont accept the status quo to bring the best service and product to the marketplace.

Our salary ranges are established based on a combination of market data internal equity and the unique characteristics of our organization such as our size revenue and industry. Within the range individual pay is determined by multiple factors including job-related skills experience and relevant education or training.

At Enclave were proud to offer a comprehensive benefits package that supports your personal well-being professional growth and financial future.

Financial Wellbeing

• Competitive base salary with ongoing performance review
• Role specific bonus potential
• 401(k) with company match
• Various supplemental insurance options
• Employee referral program

Health & Wellness

• Medical dental & vision plans
• Company-paid life & disability insurance
• Health Savings Accounts (HSA) with employer contribution
• Dependent Care Flexible Spending Accounts (FSA)
• Mental health resources & employee assistance programs
• Paid bereavement & parental leave program
• Paid Time Off (PTO) plans paid holiday and volunteer programs

Career & Culture

• Tuition reimbursement and leadership development opportunities
• Team-building and community engagement opportunities
• Employee recognition programs
• Supportive values-driven work environment
• Regular team member feedback surveys to drive workplace improvements

At Enclave we build more than spaceswe build rewarding careers. Join a team where your growth is supported your contributions are valued and your future is invested in.

Applicants must be legally authorized to work in the United States. This role is not eligible for immigration sponsorship now or in the future (e.g. H-1B TN F-1 OPT).

Enclave provides equal employment opportunity to all individuals regardless of their race color creed religion gender age sexual orientation national origin disability veteran status or any other characteristic protected by state federal or local law.

Enclave does not work with any third-party recruiters or agencies without a valid signed agreement and partnership with the Talent Acquisition Team.

Required Experience:

IC