Business Intelligence Analyst

ccertified; United States; Remote; USD 80,000 - 110,000; Full time

Benefits offered by this job

Tuition reimbursement

Paid holidays

Flexible PTO

Remote work environment

401k plan

Job summary

Career Certified is seeking a Business Intelligence Analyst to join the FP&A team. You will query data from our data lake, build dashboards, and deliver insights that inform leaders and investors.

This is a hands-on role requiring fluency with modern BI tools, including AI capabilities, and a willingness to grow into broader analytics or finance activities. The position is remote (US) with minimal travel, full-time exempt, reporting to the Manager, FP&A.

Qualifications

• Bachelor's degree in a quantitative, business, or related field, or equivalent practical experience.
• 2-4 years of experience in a data, analytics, BI, or FP&A support role; strong internships or academic projects count.
• Hands-on experience building and maintaining recurring reports or dashboards in a modern BI platform.
• SQL proficiency across joins, aggregations, and filtering in cloud data warehouses or data lakes.

Responsibilities

• Query data from cloud 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/finance views in BI platform.
• Embed AI into reporting processes to automate data preparation and accelerate analysis.
• Ensure data integrity by reconciling figures to source systems and validating against business rules.

Skills

Analytical thinking

Communication

Curiosity & ownership

Adaptability

Education

Bachelor's degree

Tools

SQL

Excel

AI tools

Job description

Job Description – Business Intelligence Analyst (Financial Services/AEC)

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: 2-4 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, analyze the data and deliver insight that helps leaders across the business make better decisions. This is a hands‑on, data‑focused/FP&A role built for someone 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.
• 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:

• 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.