Analyst, Data Insights Job at April Housing in Los Angeles

April Housing is a leading owner and operator of high-quality affordable housing throughout the United States. Founded in 2022 and headquartered in Los Angeles, April Housing is the asset management business that oversees Blackstone's affordable housing and LIHTC portfolio. April oversees a portfolio of over 85,000 affordable housing units in approximately 650 communities. April Housing seeks to preserve critical affordable housing stock while providing best in class management and high-quality housing. April is committed to being a fair, transparent, and responsible owner.

April Housing’s long-term commitment to owning affordable housing is supported by Blackstone Funds, predominantly BREIT, a non-listed REIT. This perpetual capital vehicle provides April with a patient and flexible source of capital and plays a critical role in enabling the creation and preservation of more affordable housing. In addition to managing a growing portfolio, April Housing will ensure assets in the existing portfolio remain affordable and in compliance with all rent regulations while making significant improvements and aligning the operations with April Housing's Standards of Excellence in Residential Operations.

In its pursuit of excellence, April Housing is looking for individuals who share in its mission to provide high-quality housing to affordable residents.

As a Data Analyst at April Housing, you will play a crucial role in supporting data-driven decision making by consolidating and interpreting data, developing actionable insights, and enhancing reporting across the organization. This position requires strong analytical skills, proficiency in data visualization tools, and a commitment to data quality and governance.

Responsibilities:

• Collaborate with business stakeholders to gather and document data requirements.
• Conduct technical discovery to understand available data sources and apply best practices for transforming tables that are optimized for modeling and reporting.
• Ensure adherence to best practices in data modeling, emphasizing the creation of efficient structures that maintain speed and flexibility for optimal data performance.

Prototyping Data Models For PowerBI Visualization:

• Develop and prototype dimensional models in Power BI including an advanced understanding of DAX (Data Analysis Expressions) Understand and analyze cardinality and relationships between different table structures, ensuring effective integration and interaction within data models.
• Create and design user-friendly interactive dashboards to allow stakeholders to quickly perform cross-sectional analysis for operational and portfolio key metrics.

UAT Readiness:

• Ensure data models and dashboards are ready for User Acceptance Testing (UAT). Collaborate with the QA team to identify and resolve any issues during UAT.

Technical User Support:

• Assist users with technical support related to data models and dashboards.
• Provide training and documentation to help users effectively utilize data visualization tools.

Requirements:

• Bachelor's degree in Finance, Computer Science or a related field.
• Proven experience in data analysis, data modeling, and data visualization.
• Strong knowledge of Microsoft Power Query.
• Strong knowledge of PowerBI and other data visualization tools.
• 2-4 years of experience in a related field.
• Preferred: Familiarity with Power BI Report Builder to generate PDF reports for Power BI.
• Excellent communication and interpersonal skills.
• Ability to work collaboratively with cross-functional teams.
• Strong problem-solving and analytical skills.

What We Offer:

• Base Compensation Range: $95,000.00 To $115,000.00 Annually.
• Total Direct Compensation: This job is also eligible for discretionary bonus and incentive compensation on an annual basis.
• Benefits: The Company provides a variety of benefits to employees, including health insurance coverage, retirement savings plan, paid holidays and paid time off (PTO).

April Housing is an equal opportunity employer. In accordance with applicable law, we prohibit discrimination against any applicant, employee, or other covered person based on any legally recognized basis, including, but not limited to: veteran status, uniformed servicemember status, race, color, caste, immigration status, religion, religious creed (including religious dress and grooming practices), sex, gender, gender expression, gender identity, marital status, sexual orientation, pregnancy (including childbirth, lactation or related medical conditions), age, national origin or ancestry, citizenship, physical or mental disability, genetic information (including testing and characteristics), protected leave status, domestic violence victim status, or any other consideration protected by federal, state or local law.