BI Developer

URBAN LAND INSTITUTE•Washington, DC

1d•$70,000 - $100,234•Onsite

About The Position

The Urban Land Institute (ULI) is seeking a BI Developer to design, build, and maintain dashboards and reports that surface key organizational metrics. This role is part of the Data Analytics & Engineering (DA&E) team, which focuses on turning data into decisions by building and maintaining the infrastructure that various teams rely on. The BI Developer will work closely with the Lead Systems Developer and a small analytics team, translating requests into actionable reports. The position involves working with data primarily from the NetFORUM database, as well as Virtuous and Smartsheets, requiring strong DAX and SQL skills for complex measures, data querying, and modeling. This is a build-and-deliver role focused on creating accurate, well-engineered, and well-designed reports.

Requirements

Advanced DAX and strong SQL.
Clear communication with non-technical stakeholders.
Self-direction.
A genuine interest in people, not just data.
Comfort with ambiguity and scale.
Bachelor's degree in data science, information systems, computer science, business analytics, or a related field.
2 to 3 years of experience in BI development, data analytics, or a related technical role.
Advanced proficiency in Power BI, including report development, data modeling, and DAX.
Strong SQL skills for data extraction, transformation, and query optimization.
Experience designing and maintaining semantic data models and relational schemas.
Solid Excel skills, including pivot tables, VLOOKUP/XLOOKUP, and advanced data manipulation.
Excellent written and verbal communication skills, with the ability to present complex data clearly to non-technical audiences.

Nice To Haves

Experience with membership or association management systems is a plus; NetFORUM experience specifically is welcomed but not required, as full training is provided.
Familiarity with Python or R, predictive modeling concepts, dimensional modeling, Azure data services or Fabric, Git, or AI-assisted workflows is a plus but not required.
Experience in nonprofit or membership-based organizations is a plus.

Responsibilities

Design, build, and maintain interactive Power BI dashboards, paginated reports, and HTML dashboards for stakeholders across membership, events, the Foundation, and operations.
Write advanced DAX expressions to support complex business logic, time intelligence, and KPI calculations.
Write and optimize SQL queries against the NetFORUM database and other source systems to build reliable, well-structured data layers.
Own the monthly official membership report cycle: validating data against a fixed monthly snapshot, coordinating with teams responsible for further validation, and publishing the final report on schedule.
Conduct regular data quality checks, troubleshoot discrepancies, and work with stakeholders to resolve issues at the source.
Partner directly with non-technical stakeholders to gather requirements, ask the right clarifying questions, and translate ambiguous requests into concrete report designs.
Build and maintain reusable components, templates, and standards that promote consistency across the reporting portfolio.
Use AI tools to support query writing and DAX development where useful, while owning the hands-on design and build work that still requires human judgment.
Document data definitions, sources, and business rules to support broader data governance.