What are the responsibilities and job description for the Senior Enterprise Data Analyst position at AMH?
Since 2012, we've grown to become one of the leading single-family rental companies and homebuilders in the country, recently recognized as a top employer by Fortune and Great Place To Work®. At AMH, our goal is to simplify the experience of leasing a home through professional management and maintenance support, so our residents can focus on what really matters to them, wherever they are in life.
The Senior Enterprise Data Analyst is responsible as the subject matter expert for analyzing and reporting on data from data warehouses. Activities include analyzing and interpreting collected data; spotting trends; creating reports, dashboards, scorecards, and tailored datasets for self-service reporting; engaging with and making recommendations to stakeholders; leveraging data to answer important business questions and inform business decisions; data modeling. Responsibilities may include pipeline analysis, forecasting, ROI analysis, renewal and retention rates, utilization, and predictive modeling of different business strategies and outcomes. Interact regularly with internal stakeholders to translate high-level business requirements into well-documented, technical solutions. Works cross-functionally to understand, develop and track KPIs. Use technical expertise to perform quality review of developed solutions and ensure proper user acceptance. Partners with data QA and data clean-up as needed. Oversees the work processes of the Data and Enterprise Analytics Team and provides recommendations on strategic pathways for BI software and initiatives to management.
Responsibilities
The anticipated pay range/scale for this position is $105,322.00 to $131,652.00 Annually. Actual starting base pay within this range will depend on factors including geographic location, education, training, skills, and relevant experience.
Additional Compensation
This position is eligible to receive a discretionary annual bonus.
Perks and Benefits
Employees have the opportunity to participate in 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; and a tuition reimbursement program. The Company provides 9 paid holidays per year, and, upon hire, new employees will accrue paid time off (PTO) at a rate of 0.0577 hours of PTO per hour worked, up to a maximum of 120 hours per year.
CA Privacy Notice: To learn more about what information we collect when you apply for a job, and how we use that information, please see our CA Job Applicant Privacy Notice found at https://www.amh.com/ca-privacy-notice.
The Senior Enterprise Data Analyst is responsible as the subject matter expert for analyzing and reporting on data from data warehouses. Activities include analyzing and interpreting collected data; spotting trends; creating reports, dashboards, scorecards, and tailored datasets for self-service reporting; engaging with and making recommendations to stakeholders; leveraging data to answer important business questions and inform business decisions; data modeling. Responsibilities may include pipeline analysis, forecasting, ROI analysis, renewal and retention rates, utilization, and predictive modeling of different business strategies and outcomes. Interact regularly with internal stakeholders to translate high-level business requirements into well-documented, technical solutions. Works cross-functionally to understand, develop and track KPIs. Use technical expertise to perform quality review of developed solutions and ensure proper user acceptance. Partners with data QA and data clean-up as needed. Oversees the work processes of the Data and Enterprise Analytics Team and provides recommendations on strategic pathways for BI software and initiatives to management.
Responsibilities
- Utilizes business intelligence tools (Power BI, Tableau, SQL, DataBricks, etc.) to develop analytical content including reports, dashboards, semantic models, and data sets. Supports end-user adoption of reporting and creation of documentation as needed.
- Utilizes relational database and data warehouse design skills to codify business logic in SQL to meet reporting requirements for all areas of operation.
- Collaborates with business unit owners to elicit requirements using interviews and data analysis, develop and/or improve work product, and create new features in existing report packages.
- Works to proactively identify data quality issues, debug erroneous logic and perform QA validations.
- High school diploma or GED required.
- Bachelor’s degree in computer science, mathematics, finance, accounting, economics, statistics, business management, information systems and/or related preferred.
- Minimum three (3) years’ experience working with Business Intelligence, Analytics, Financial Reporting Data Warehousing technologies, and/or related required.
- Minimum three (3) years’ experience utilizing proven requirements gathering and business analysis techniques required; must have a complete understanding of the business intelligence development life cycle including the ability to conduct interviews and gather the needs for desired outcomes for the BI solutions being built.
- Intermediate experience querying relational databases and data warehouses (such as SQL Server, Databricks, Snowflake, etc.) required.
- Intermediate Microsoft Excel experience required including writing and using advanced functions and formulas (e.g., lookup & 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 (Outlook, Word) required.
- Working knowledge of Tableau or Power BI highly preferred.
- Excellent verbal and written communication and problem-solving skills.
- Strong business analysis skills and technical aptitude.
The anticipated pay range/scale for this position is $105,322.00 to $131,652.00 Annually. Actual starting base pay within this range will depend on factors including geographic location, education, training, skills, and relevant experience.
Additional Compensation
This position is eligible to receive a discretionary annual bonus.
Perks and Benefits
Employees have the opportunity to participate in 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; and a tuition reimbursement program. The Company provides 9 paid holidays per year, and, upon hire, new employees will accrue paid time off (PTO) at a rate of 0.0577 hours of PTO per hour worked, up to a maximum of 120 hours per year.
CA Privacy Notice: To learn more about what information we collect when you apply for a job, and how we use that information, please see our CA Job Applicant Privacy Notice found at https://www.amh.com/ca-privacy-notice.
Salary : $105,322 - $131,652