Business Intelligence Analyst

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, MN
• Work 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 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.

Qualifications

• Bachelor's 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.

Physical Environment

• 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.

Culture & Total Rewards Approach

• Why Join Enclave?
• 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 don't accept the status quo to bring the best service and product to the marketplace.
• Total Rewards Approach
• 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, we're 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 spaces—we 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