Enterprise Data Analyst

American Homes 4 Rent • Calabasas, CA

1d

About The Position

Since 2012, AMH has grown to become one of the leading single-family rental companies and homebuilders in the country, recognized as a top employer by Fortune and Great Place To Work®. AMH's goal is to simplify the experience of leasing a home through professional management and maintenance support, so residents can focus on what really matters to them, wherever they are in life. The Enterprise Data Analyst is responsible for analyzing and interpreting collected data, identifying trends, creating reports, dashboards, scorecards, and tailored datasets for self-service reporting. This role collaborates with internal stakeholders to provide recommendations by leveraging data modeling to support informed business decisions. The analyst works cross-functionally with internal teams (e.g., finance and engineering) to support data and reporting needs, and to identify and address data gaps. The role leverages company AI tools to model and forecast data to establish consistent business language definitions and metrics.

Requirements

• High school diploma or GED required.
• Minimum three (3) years of experience working in business intelligence, analytics, financial reporting, and/or a related field required.
• Minimum three (3) years of experience in requirements gathering and business analysis techniques required, including a strong understanding of the business intelligence (BI) development life cycle, conducting stakeholder interviews, and translating business needs into BI solutions.
• Intermediate experience querying relational databases and data warehouses (e.g., SQL Server, Databricks, Snowflake, etc.) required.
• Intermediate Microsoft Excel experience required, including writing and using advanced functions and formulas (e.g., lookup and reference, nested logical expressions, aggregation, etc.) as well as advanced Excel features (e.g., conditional formatting, data validation, pivot tables, external data connections).
• Working knowledge of Microsoft Office (Excel, Outlook, Word) required.
• Excellent verbal and written communication and problem-solving skills.
• Strong business analysis skills and technical aptitude.
• Strong understanding of finance concepts.

Nice To Haves

• Bachelor’s degree in mathematics, finance, accounting, economics, statistics, business management, business analytics, data science and/or a related field preferred.
• Experience in financial modeling preferred.
• Working knowledge of Tableau or Power BI is highly preferred.

Responsibilities

• Develops analytical content to include reports, dashboards, semantic models, and datasets by utilizing business intelligence tools (e.g., Power BI, Tableau, SQL, Databricks, etc.).
• Supports end-user adoption of reporting through documentation and guidance.
• Writes SQL-based solutions and leverages AI tools to support the company’s reporting requirements by utilizing the company data platform.
• Collaborates with the Finance team to conduct data analysis, fulfill data requests, and provide insights on company performance to enhance and refine processes and deliverables.
• Creates new features into existing report packages to improve deliverables.
• Ensures data accuracy by identifying issues, correcting metric definitions, and validating results before reporting.

Benefits

• medical, dental and vision insurance
• flexible spending accounts and/or health savings accounts
• dependent savings accounts
• 401(k) with company matching contributions
• employee stock purchase plan
• tuition reimbursement program
• 9 paid holidays per year
• paid time off (PTO)

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: High school or GED