Senior Business Data Analyst

Blue Orange Digital is a data engineering and AI consultancy that builds production-grade data platforms and analytics solutions. They are seeking a Senior Business Data Analyst to lead client engagements, translating business needs into structured analytical work and delivering impactful data products.

Responsibilities:

• Lead client-facing discovery sessions to elicit, document, and prioritize business requirements with operators, analysts, and executives
• Translate ambiguous business problems into structured analytical work: data models, dashboards, KPI frameworks, and decision-support tools that get adopted
• Write production-quality SQL against Snowflake, Databricks, BigQuery, or Redshift, and build trusted models in dbt or the client's modeling layer
• Build and maintain dashboards and reporting in Looker, Tableau, Power BI, Sigma, or the tool the client lives in
• Drive proactive analysis: surface trends, anomalies, and opportunities the client did not ask about but needs to see
• Apply AI tooling (LLM-based analysis, natural language to SQL, agentic data exploration, AI-assisted documentation) to compress timelines and raise the quality bar on every deliverable
• Set the cadence for client communication: status updates, demos, working sessions, and stakeholder reviews
• Mentor junior analysts on the engagement and contribute to BOD's analytics playbooks, templates, and internal tooling

Requirements:

• 5+ years of experience as a business analyst, data analyst, BI analyst, or analytics consultant, with at least 2 years in a client-facing or embedded role
• Expert SQL: window functions, CTEs, performance tuning, and the ability to sanity-check your own numbers before anyone else has to
• Strong data modeling fundamentals (dimensional modeling, star/snowflake schemas, dbt or equivalent transformation tooling)
• Hands-on experience with at least one cloud data warehouse (Snowflake, Databricks, BigQuery, Redshift) and at least one modern BI tool (Looker, Tableau, Power BI, Sigma, Mode)
• Demonstrated ability to lead client conversations: running requirements workshops, pushing back constructively, and driving alignment across stakeholders with different priorities
• Working fluency with AI tools for analytical work (Claude, ChatGPT, Copilot, AI features inside BI and SQL tools) and a clear point of view on where they speed you up vs. where they introduce risk
• Excellent written and verbal communication, with the judgment to scale your message to the audience in front of you
• Bias toward action: You would rather draft a working hypothesis and a v1 dashboard than wait for perfect requirements
• Domain experience in commercial real estate, financial services, healthcare technology, or insurance
• Python for analytical workflows (pandas, notebooks, light scripting against APIs)
• Experience scoping and pricing analytics work, or contributing to SOWs and statements of work
• Familiarity with data quality frameworks, observability tools, or governance practices
• Prior consulting or agency experience and comfort with utilization, billing, and multi-client context switching
• Experience implementing or evaluating AI-native analytics tools (text-to-SQL platforms, AI BI assistants, semantic layers)