Business Intelligence Analyst

Summary

Career Certified is hiring a Business Intelligence Analyst to support its FP&A and broader business operations. The role queries cloud data, builds trustworthy reports and dashboards, embeds AI into reporting processes, validates data integrity, and delivers actionable insights to organizational leaders while collaborating with data engineering and business stakeholders.

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

Skills

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

Qualifications

Must Haves

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

Nice to Haves

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

Benefits

• 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
• Voluntary participation in Career Certified’s medical, dental, and vision plans, as well as supplemental insurance options, granted the first of the month following 30 days of employment
• Voluntary participation in Career Certified’s 401k plan, granted the first of the month following 30 days of employment