Business Intelligence Reporting Analyst – Marketing Reporting (REMOTE)

Job Description
American Homes 4 Rent
As one of the country’s fastest-growing property management companies of single-family rental homes, American Homes 4 Rent has an exhilarating and fluid start-up culture and permanency of a well-founded corporation, rich with diversity.

As pioneers in the industry, solidified by our place on Wall Street, American Homes 4 Rent (AMH:NYSE) is currently looking for qualified candidates.

With a culture of unprecedented growth, quality and innovative collaboration, we are seeking personalities to complement our attributes.
The Business Intelligence Reporting Analyst (BIRA) codifies business logic using SQL and produces visually appealing business intelligence for end users to consume.

The Business Intelligence Reporting Analyst works with business stakeholders to identify reporting requirements necessary to improve visibility into their performance and areas of improvement.

The Business Intelligence Reporting Analyst will interact regularly with internal business customers to capture and understand reporting and data service requests, they will help define and clarify requirements, propose, define, and develop appropriate solutions, and provide feedback to the reporting team.

They will perform quality review of developed solutions and ensure proper user acceptance.

This essential position provides the necessary feedback to grow our business and gain efficiencies.
The Business Intelligence Reporting Analyst
– Marketing Reporting position will focus on providing customer and market information to drive marketing strategy and product development.

This position requires the candidate to be skilled in measurement and analysis of marketing campaigns, A/B testing and customer behaviors.

The candidate needs to have experience in analyzing large datasets and have the ability to leverage data to spot patterns, trends and communicate findings clearly with stakeholders.
Provide marketing insights to achieve key performance indicators and provide insights and analysis to the Marketing Team to evolve the business model to meet the needs of the changing market.

Support the delivery of Business Intelligence data and reports through cross-functional team coordination and recommend innovative solutions to meet business intelligence needs.
This candidate will work in a highly data-driven environment and needs to be extremely proactive with a focus on delivering actionable insights.
Responsibilities:

Utilizes Tableau and other business intelligence tools to develop analytical content including reports, dashboards, and ad-hoc analyses and data sets.

Supports end-user adoption of Tableau through trainings and creation of documentation.
Codifies business logic in SQL to meet reporting requirements for all areas of operations.
Collaborates with business unit owners to constantly improve work product, debug erroneous logic, and create new features in existing report packages.
Utilizes relational database and data warehouse design skills to create an effective
data model for efficient and robust historical and real-time reporting.
Elicits requirements when necessary, using interviews and data analysis; defines requirements for and performs user-acceptance testing of new data in the data warehouse.

Logs, tracks, and manages issues and requests in JIRA.

Requirements:

High School Diploma / GED required.
Bachelors degree in Mathematics, Finance, Accounting, Computer Science, Physics, Engineering, Economics, Statistics, Business Management, Information Systems and/or related preferred.
Minimum 3 years experience working with Business Intelligence, Analytics, Financial Reporting Data Warehousing technologies, and/or related required.
Minimum 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 developing and maintaining relational databases (SQL Server preferred) required.
Advanced Microsoft Excel experience required:
Writing and using advanced functions and formulas (e.g., lookup & reference, nested logical expressions, aggregation, etc.)
Advanced Excel features (e.g., conditional formatting, data validation, pivot tables, external data connections)
Working knowledge of Microsoft Office (Outlook, Word) and JIRA required.
Working knowledge of Tableau highly preferred.
Excellent verbal and written communication and problem-solving skills.
Strong business/financial analysis skills and technical aptitude.
Must be able to multi-task.
This position is considered light work
– exerting up to 20 pounds of force occasionally, and/or up to 10 pounds of force frequently, and/or a negligible amount of force constantly to move objects.

If the use of arm and/or leg controls requires exertion of forces greater than that for sedentary work and the employee sits most of the time, the job is rated for light work.
Required to have close visual acuity to perform an activity such as: preparing and analyzing data and figures; transcribing; viewing a computer screen and extensive reading.
May work evenings and/or weekends.

Work where you feel right at home:
If you are a versatile professional who values culture, a constructive environment and the potential for exponential growth, we want to work with you!Apply now and someone from our Talent Acquisition team will reach out to you soon!
For positions that are permitted or required to work remotely, employees may conduct work only within the United States and only in states where the Company is already conducting business, unless for brief periods, consistent with Company policy.
For employees in Colorado the anticipated pay range is $60,325 to $86,268.
The Company also may provide benefits with this position including but not limited to: medical, dental, and vision insurance; Flexible Spending Accounts (FSUs) and/or Health Savings Accounts (HSAs); Dependent Savings Accounts; 401(k) plan with employer matching; employee stock purchase plan; and potential for bonuses.

The above wage range is the Company’s current good faith expectation for this position.

The actual amount paid and/or offered may be less or more than this range and will be based on factors including geographic location, education, training, or experience related to the work, seniority, merit, quantity and or quality of the work.
Information regarding AH4R’s collection and use of your personal information can be found at https://www.ah4r.com/employeeprivacy
Related keywords:
Business intelligence reporting analyst, business intelligence, BI, IT, information technology, management information systems, business analysis, computer science, property management, full time, databases, mathematics, physics, engineering, economics, statistics, real estate, data warehousing, #remote