The
Business Intelligence Analyst partners with business leaders and departments across DLP Capital to turn data into actionable insights that drive informed decisions and improve business performance. This role works closely with teams across Lending, Servicing, Fund Management, Asset Management, Finance, and other business functions to understand their reporting needs, identify trends and opportunities, and deliver accurate, meaningful analytics. The analyst develops and maintains BigQuery/Dataform reporting models, establishes and validates KPI definitions, and builds executive and departmental dashboards and reports. The role also identifies opportunities to automate manual reporting processes, improve data accessibility, and enhance reporting efficiency. Working collaboratively with business stakeholders and the Data Warehouse & Integrations team, the analyst ensures reporting solutions are reliable, scalable, and aligned with business priorities.
What you have already achieved: (Requirements)- Experience in business intelligence, data analytics, or analytics engineering delivering decision-ready reports and dashboards.
- Advanced SQL, including complex joins, window functions, CTEs, performance tuning, and cloud data warehouse experience.
- Experience building and maintaining version-controlled transformation models using Dataform, dbt, or similar tools, with Git and snapshot/incremental processing concepts.
- Working knowledge of Python or similar scripting for reporting automation, data cleaning, and API-assisted data retrieval.
- Experience building stakeholder-focused dashboards in Power BI, Cognos, Looker Studio, Tableau, or comparable tools.
- Experience defining, documenting, validating, and reconciling KPIs against approved source systems.
- Ability to gather business requirements, translate questions into reporting specifications, and communicate findings to nontechnical stakeholders.
- Experience planning and delivering work in Jira or comparable sprint-based tools.
- Preferred: financial services, lending, private credit, fund or property management reporting; familiarity with Finastra, AppFolio, HubSpot, or related systems.
- Bachelor's degree in information systems, computer science, finance, statistics, or a related quantitative field.
What you are great at: (Responsibilities) - Learn existing BigQuery/Dataform models, BI platforms, data owners, and priority executive/departmental reporting requirements.
- Inventory owned reports and KPIs, agree on critical report definitions and validation checks, and establish baseline results for key numbers.
- Deliver initial assigned dashboard/report improvements and identify a prioritized backlog of manual reporting automations.
- Build and maintain documented, tested SQL reporting models in BigQuery and Dataform.
- Define, calculate, validate, and reconcile company KPIs using agreed-upon source-of-truth definitions.
- Design and maintain executive and department-level reports and dashboards that support decisions.
- Gather requirements with stakeholders, define acceptance criteria, and deliver useful reporting solutions.
- Automate manual recurring reports, spreadsheet preparation, and repeatable KPI calculations using governed warehouse data and BI tools efficiency.
- Monitor report outputs, investigate BI-layer errors and data-quality exceptions, and work with the integration owner on upstream issues.
- Document data dictionaries, KPI definitions, reporting workflows, validation steps, and runbooks.
- Manage assigned work in two-week Jira sprints, communicate status and blockers, and fulfill commitments.
- Improve report usability, performance, reliability, and adoption based on stakeholder feedback.
- Identify advanced forecasting or AI opportunities and partner with the Data Warehouse & Integrations team.
What you're motivated by: - Making an impact. Whether it's the residents who call our Thriving Communities home, the investors who trust us to be stewards of their capital, or the sponsors we work with to 10x their business, everything we do is about making an impact.
- Challenges. You see roadblocks as opportunities and are proactive in finding solutions.
- Growth. We've been named to the Inc. 5000 as one of the Fastest-Growing Private Companies in America for fourteen consecutive years.
Benefits and Perks:Unlimited PTO, health/dental/vision/life insurance, 401(k) matching, parental leave, adoption services reimbursement/learning/educational incentives, Volunteer Time Off, well-being programs, company events, self improvement/productivity tools, & the incredible feeling of making a difference.