Lennar is looking for a Senior Data Analyst to design and build interactive dashboards, transform data for reporting, ensure robust data models, and collaborate with stakeholders to drive insights and decisions.
Requirements
- Deep, hands-on experience with Power BI: DAX, Power Query/M, Power BI Service (workspaces, row-level security, deployment).
- Strong data modeling skills: designing fact/dimension tables, relationships, hierarchies, slow-change logic, optimization.
- Expert-level SQL skills: able to write, optimize, and debug complex queries and data transformations.
- Experience building or managing a semantic / metrics / semantic modeling layer for BI reporting.
- Background working with multiple upstream data sources (OLTP systems, APIs, data warehouses, flat files).
- Familiarity with cloud analytics / data warehouse platforms (Azure Synapse, Azure SQL DW, Snowflake, BigQuery, Databricks).
- Experience with Power Platform / alternative BI or semantic tools (SSAS Tabular, Analysis Services, Looker, etc.).
Responsibilities
- Own the development and maintenance of financial operational dashboards (e.g. P&L, cash flow, revenue recognition, AR/AP, ledger reconciliation, forecasts vs. actuals).
- Design and build a centralized semantic model / semantic layer / metrics layer (e.g. in Power BI shared datasets, Tabular models, or equivalent) that becomes the canonical source for reporting across domains.
- Lead the creation of well-designed, maintainable, high-performance Power BI reports and dashboards (desktop, service, paginated).
- Develop and maintain relational and dimensional models (star schemas, snowflake models, slowly changing dimensions, bridge / fact tables).
- Write and optimize advanced SQL (CTEs, window functions, complex joins, subqueries) for data transformation, validation, and staging.
- Manage deployment, workspace structure, refresh scheduling, security/permissions, and dataset partitioning.
- Optimize performance (query folding, aggregations, incremental refreshes, performance tuning).
Other
- Bachelor’s degree (or higher) in a quantitative field (Computer Science, Engineering, Finance, Statistics, etc.).
- 5+ years of experience in analytics / BI / data roles, ideally in fintech, financial services, or operations-heavy environments.
- Excellent ability to collaborate with finance and business leadership to validate assumptions, build trust, translate needs.
- Excellent communication skills — able to explain technical detail to non-technical stakeholders.
- Prior experience in auditing, compliance, financial controls, or working with external auditors.
