Sr Business Analyst

FirstKey Homes, LLC; Atlanta, Northern (GA, KY); Hybrid; USD 95,000 - 130,000; Full time

Job summary

FirstKey Homes, LLC is seeking a Sr. Business Analyst to become the analytics partner across departments, building KPI reporting, executive dashboards, and ESG reporting.

You will collaborate with senior leaders to inform decisions and influence strategy, modeling data and supporting budgeting alongside FP&A. The role requires strong SQL, Power BI, Python, and Excel skills, plus experience handling large datasets in a fast-paced, high-growth environment.

Qualifications

• Bachelor’s degree or equivalent work experience in Business, Finance, Data Analytics, or Computer Science.
• Minimum 2 years in an analytically driven role or advanced technical education with applicable experience.
• Advanced PowerPoint, Power BI, and Excel skills with focus on executive messaging.
• Advanced SQL proficiency.
• Detail-oriented with a commitment to operational excellence and quality.
• Experience with large datasets, recommending actions and synthesizing insights.
• Proven ability to manage data and extract exceptions for targeted performance management.
• Strong communication skills and ability to influence staff at all levels.
• Experience working within a multi-disciplined, cross-functional technical organization.
• Exceptional verbal and written communication skills with proven ability to effectively influence staff at all levels.

Responsibilities

• Assist in collecting and documenting reporting requirements for KPI reporting.
• Build customized Power BI dashboards and reports for metrics, scoreboards, and ad hoc reporting.
• Maintain documents mapping source systems to reporting data.
• Provide forward-looking analyses and presentations to senior leadership.
• Apply SQL to build datasets from data warehouse for Power BI dashboards.
• Learn and use Python and advanced Excel for data modeling.

Skills

Critical Thinking

Complex Problem Solving

Mathematics

Active Listening

Active Learning

Systems Evaluation

Monitoring

Speaking

Writing

Leadership

Education

Bachelor's degree in Business, Finance, Data Analytics, or Computer Science

Tools

Power BI

Excel

SQL

Python

Azure Data Factory / Fabric

Job description

The Sr. Business Analyst possesses a strong technical skillset balanced with curiosity and business aptitude to develop a strong understanding of FirstKey Homes operations while fostering relationships with the business leaders they support. They will act as the assigned analytics partner to department leaders, building and maintaining critical reporting related to Key Performance Indicators (KPIs) across the business, executive/ board-level reporting, external reporting (e.g., ESG) and ad-hoc analyses. They will collaborate with senior leaders and cross-functional partners to inform and influence key business processes, executive decision-making, and strategy development for FirstKey Homes. The role will partner with business leaders to advise trends, model data, and design dashboards to increase effectiveness of managing departmental responsibilities, and partner with FP&A on planning, forecasting, and reporting to assist with the budgeting process. The desired candidate must exhibit strong prior experience and knowledge to navigate internal systems to compile and analyze data, interpret results, and assist with implementation of technical solutions. The candidate should be comfortable working in a fast-paced, high-growth company that requires adaptability, collaboration and responding with a sense of urgency. The ability to develop and foster strong business partnering relationships across the company, as well as strong communication and presentation skills is critical to achieve success in this role.

ESSENTIAL DUTIES

• Assist in the collection and documentation of business leader’s reporting requirements and estimates of effort level to support the design, development, and enhancement of existing KPI reporting.
• Build customized Power BI dashboards and reports to include key metrics, scoreboards, and ad hoc reporting.
• Maintain technical documents relating to database mapping and processes to sufficiently explain how source system data is represented in reporting.
• Produce forward-looking, insightful, and actionable performance analyses. Provide insightful business analyses and presentations (standard and ad-hoc) to and for senior leadership, which contribute to their effectiveness in managing and communicating operational performance, opportunities and issues within their functional area.
• Apply advanced SQL knowledge to build required datasets using existing Enterprise Data Warehouse data for use in Microsoft Power BI dashboards.
• Learn and use Python code and advanced Microsoft Excel to support ad-hoc data modeling.
• Learn about P&L statements and how operational KPIs impact P&L results.
• Partner and counsel with stakeholders (FP&A, Operations, Accounting) as analytics business partner to support critical companywide deliverables including annual planning, monthly operating reviews, quarterly reforecasting, and ongoing reporting.
• Lead and support special projects, ad-hoc analysis, and recommendations to advance FirstKey Homes strategic growth agenda, decision making and performance delivery.
• Identify opportunities and partner with stakeholders to develop business cases, including sensitivity modeling, for department-specific or company-wide initiatives to evaluate the viability and associated risks of business cases.
• Serve as thought leader for key business intelligence initiatives. Assist in conceptualizing and defining strategies as well as leading and coordinating efforts to operationalize concepts throughout the business.

This brief summary is not an all-inclusive description of job duties. Other job duties and responsibilities may also be assigned by the incumbent’s manager at any time based upon Company need.

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

REQUIRED EDUCATION AND EXPERIENCE

• Bachelor’s degree in Business, Finance, Data Analytics, or Computer Science with equivalent work experience and/or education.
• Minimum 2 years’ experience in an analytically driven role, or advanced technical education with applicable experience.
• Advanced PowerPoint, Power BI, and Excel skills with focus on executive messaging.
• Advanced SQL proficiency.
• Detail-oriented with a commitment to operational excellence and quality.
• Experience with large datasets, recommending actions and synthetizing insights.
• Proven ability to manage data and extract exceptions for targeted performance management.
• Highly process oriented with passion to investigate root causes, driving process improvement, and enabling change management.
• Experience working within a multi-disciplined, cross-functional technical organization.
• Exceptional verbal and written communication skills with proven ability to effectively influence staff at all levels.

REQUIRED SKILLS

• Critical Thinking — Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.
• Complex Problem Solving — Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.
• Mathematics — Using mathematics to solve problems.
• Active Listening — Giving full attention to what other people are saying, taking time to understand the points being made, asking questions as appropriate, and not interrupting at inappropriate times.
• Active Learning — Understanding the implications of new information for both current and future problem-solving and decision-making.
• Systems Evaluation — Identifying measures or indicators of system performance and the actions needed to improve or correct performance, relative to the goals of the system.
• Monitoring — Monitoring/Assessing performance of yourself, other individuals, or organizations to make improvements or take corrective action.
• Speaking — Talking to others to convey information effectively.
• Writing — Communicating effectively in writing as appropriate for the needs of the audience.

PREFERRED EDUCATION AND EXPERIENCE

• Experience working in property management, real estate or similar industry Experience working in a fast pace, high growth company.
• Familiar with Azure services such as Microsoft Data Factory / Fabric, Data Lakes, or similar ETL.
• Comfort reviewing financial statements (P&L) and ability to tie operational KPIs to P&L outcomes.
• Experience with Python for data modeling.

WORK STYLES & BEHAVIORS

• Leadership — Job requires a willingness to lead, take charge, and offer opinions and direction.

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.