Business Intelligence Analyst (Real Estate)

Colonial Group; United States; Remote; USD 90,000 - 130,000; Full time

Benefits offered by this job

Tuition reimbursement

Paid holidays

Flexible Time Off

Remote work environment

401k plan

Job summary

Career Certified is seeking a Business Intelligence Analyst to join our FP&A team, focusing on querying the data lake, turning data into clean, trustworthy reports and dashboards, and delivering actionable insights that help leaders across the organization make better decisions.

This is a remote, full-time role built for someone early in their analytics career, with opportunities to grow into broader analytics or finance paths.

Qualifications

• Bachelor's degree or equivalent practical experience in a quantitative, business, or related field.
• 3–5 years of experience in a data, analytics, BI, or FP&A support role; internships or academic projects count.

Responsibilities

• Query data from our data lake using SQL and AI-assisted tooling to answer business questions and produce inputs for recurring reporting.
• Build and maintain recurring reports and dashboards, KPI trackers, and operational metrics in the BI platform.
• Develop Excel-based models and translate ad-hoc analysis into scalable reporting.
• Embed AI into reporting processes using tools to automate data preparation and enhance outputs.
• Own data integrity across reporting; reconcile figures to source systems and resolve discrepancies.

Skills

SQL

BI Reporting

Excel

AI Tools

Communication

Education

Bachelor's degree

Tools

Git

dbt

Python

Cloud Data Warehouse

Job description

Job Description – Business Intelligence Analyst (Real Estate)

Division / Department: Business Operations / FP&A (Biz Ops / RevOps)
Reports to (position): Manager, Financial Planning & Analysis (Biz Ops / RevOps)
Level / Grade: Analyst
Location: Remote (US)
Employment Type: Full Time, Exempt
Work Conditions: Remote Office Environment
Travel: Minimal
Telecommute: Yes
Minimum Educational Req: Bachelor's degree in a quantitative, business, or related field, or equivalent practical experience.
Years of Experience: 3–5 years of experience in a data, analytics, BI, or FP&A support role; strong internships or academic projects count.

Position Summary

The Business Intelligence Analyst sits on the FP&A team but serves the entire organization. You will query data from our data lake, turn it into clean and trustworthy reports and dashboards, and deliver insight that helps leaders across the business make better decisions. This is a hands-on, data-focused role built for someone early in their career who is fluent with modern tools, including AI, and eager to grow into a broader analytics or finance career.

This is a high-visibility seat: your work will inform decisions made by department leaders, the executive team, and our board and investors. You will not be expected to know everything on day one, but you will be expected to be curious, precise, and quick to learn.

Essential Duties and Responsibilities

• Query our cloud data lake using SQL and AI-assisted tooling to answer business questions and produce the inputs behind recurring reporting.
• Build and maintain recurring reports and dashboards, KPI trackers, operational metrics, and finance and business performance views, in the company's business intelligence platform.
• Develop Excel-based models and reports, and help translate ad-hoc spreadsheet analysis into scalable, repeatable reporting.
• Embed AI into our reporting processes, using tools such as Claude and Copilot to automate data preparation, accelerate analysis, and build AI-assisted outputs into how reports are produced and delivered.
• Own data integrity across your reporting: reconcile figures to source systems, validate them against defined business rules, and proactively surface and resolve discrepancies before anything reaches a stakeholder.
• Deliver business insight and data clarity, translating stakeholder questions across departments into well-scoped analysis, and presenting results in a way that makes the story in the data clear and actionable.
• Establish and maintain documentation for data definitions, report logic, and reporting processes, ensuring consistency, transparency, and continuity across the analytics function.
• Help build a scalable reporting and data infrastructure, standardizing datasets, automating manual steps, and extending the company's unified data layer so reporting can grow without adding headcount.
• Partner with leaders across the business to understand their reporting needs and turn them into dashboards and reports they use.
• Collaborate with data engineering on schema changes, new data sources, and pipeline issues that affect downstream reporting.

Knowledge, Skills & Abilities

• Rigor: Strong commitment to data integrity, careful, detail-oriented, and skeptical of your own numbers until they tie out to source.
• Communication: Able to explain findings clearly to non-technical stakeholders (ELT and Board level) in writing and in conversation.
• Curiosity & Ownership: Digs into why a number looks off instead of taking it at face value, and proactively flags or fixes reporting gaps, inefficiencies, and stale processes rather than waiting to be asked.
• Adaptability: Picks up new tools quickly without getting attached to a specific platform, juggles multiple stakeholder requests at once, and favors the simplest report that answers the question over the most complex one.

Required Technical Skills

• Reporting: Hands-on experience building and maintaining recurring reports or dashboards in a modern business intelligence platform. We are tool-agnostic; transferable skills matter more than any specific product.
• SQL: Working proficiency in SQL, including joins, aggregations, and filtering across multiple tables; comfortable querying a cloud data warehouse or data lake.
• Excel: Strong Excel skills, including pivot tables, lookups, and clean, well-structured workbooks.
• AI: Practical experience using AI tools in a data or reporting context, and the ability to apply them to automate and improve analytics work.

Preferred Qualifications

• Familiarity with Python or R for data manipulation.
• Understanding of finance or FP&A concepts (budgets, actuals, variance, KPIs).
• Experience with version control (Git) or dbt / data-transformation tooling.
• Exposure to a B2C and/or B2B subscription or e-commerce business.
• Data visualization or design sense, with an eye for building dashboards that are clean and readable, not just functional.
• Direct experience working directly in a cloud data warehouse or data lake environment.

Supervisory Responsibility

This position does not supervise the work of others.

Internal and External Interaction

This position interacts regularly with FP&A, Business Operations, Data Engineering, and leaders across the organization. Reporting and analysis produced by this role may also support the executive team, Board, and investors.

Physical Requirements

The physical demands of this position are representative of those that must be met by an employee to successfully perform essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

What Success Looks Like

• Recurring reports and dashboards are accurate, reliable, and delivered on time.
• Data consistently reconciles to source systems, with discrepancies identified and resolved before reaching stakeholders.
• Leaders across the business have clear, actionable reporting that helps them make better decisions.
• Manual reporting processes become more scalable and repeatable through automation and standardization.
• Reporting definitions, logic, and processes are clearly documented and consistently applied.
• AI tools are effectively incorporated into reporting and analytics processes to improve efficiency and accelerate analysis.
• Business questions are translated into clear, well-scoped analysis that communicates the story behind the data.
• Reporting gaps, inefficiencies, and data issues are proactively identified and addressed.
• Strong partnerships are built with FP&A, Data Engineering, and leaders across the business.
• The role continues to develop broader analytics, business intelligence, and finance capabilities over time.

nternal and external interaction:

This position interacts with peers both in and out of the department and their immediate manager on a regular basis. They may interact with customers and vendors directly in escalation or support situations in a large geographical area. They will interact with managers in other departments

What We Offer:

Employment benefits granted upon hire date:

• Tuition reimbursement, subject to approval
• Paid company holidays (9 days off per year)
• Flexible Time Off (FTO), as described in the employee handbook
• Remote and collaborative work environment

Employment benefits granted the first of the month following 30 days of employment include:

• Voluntary participation in Career Certified’s medical, dental, and vision plans, as well as supplemental insurance options
• Voluntary participation in Career Certified’s 401k plan

Career Certified is an Equal Opportunity Employer and is committed to fostering a diverse, inclusive, and respectful workplace where employees can thrive and contribute to organizational success.