Business Analyst - Data Warehouse & AI

Business Analyst to lead the transformation of our data warehouse into an AI-ready infrastructure. This role will involve working closely with software engineers, data engineers, and business intelligence teams to uplift the current data warehouse, ensuring it is optimized for advanced analytics, forecasting, and AI-driven use cases. You will play a pivotal role in defining the roadmap, identifying gaps, and delivering actionable insights that drive business outcomes.

Key Responsibilities:

Data Warehouse Uplift & AI Readiness:

• Collaborate with software engineers and data engineers to understand the existing data warehouse architecture and define the roadmap for its transformation into an AI-ready platform.
• Analyze current data pipelines and workflows to identify inefficiencies and areas for improvement.
• Design and implement segmented layers on top of the data warehouse to support advanced analytics, forecasting, campaign optimization, and media recommendations.

Business Intelligence & Reporting:

• Partner with stakeholders across finance, marketing, and operations to gather requirements for reporting needs and data analysis.
• Define key metrics, dashboards, and reporting schemas using tools like Power BI or Tableau.
• Ensure self-service reporting capabilities are intuitive and empower users to uncover actionable insights independently.

Ad-Hoc Initiatives & AI Use Cases:

• Support ad-hoc initiatives related to generative AI applications by creating tools that leverage clean and structured data from the warehouse.
• Work on agentic AI use cases such as predictive modeling, recommendation engines, and automated decision-making systems.

Data Governance & Quality Assurance:

• Champion data governance practices by ensuring the accuracy, consistency, and cleanliness of data within the warehouse.
• Define processes for cleaning up existing datasets and maintaining high-quality standards for future integrations.

Cross-Functional Collaboration:

• Act as a bridge between technical teams (data engineers/software developers) and business teams (finance, marketing) to ensure alignment on deliverables.
• Facilitate workshops to elicit requirements from stakeholders and translate them into technical specifications for implementation.

Qualifications & Skills:

Essential Qualifications:

• 4–6+ years of experience as a Business Analyst in data warehousing, business intelligence, or analytics environments.
• Strong understanding of cloud-based data platforms (e.g., Google Cloud Platform - BigQuery).
• Hands-on experience with business intelligence tools such as Power BI or Tableau for dashboard creation and reporting.
• Proven ability to map "As-Is" workflows and design "To-Be" solutions for complex data architectures.
• Experience working with segmented layers in a data warehouse to support advanced analytics use cases.

Technical Skills:

• Proficiency in SQL for querying large datasets and analyzing schemas.
• Familiarity with ETL/ELT processes for transforming raw data into usable formats.
• Knowledge of AI/ML concepts and their application in business contexts (e.g., forecasting models, recommendation engines).

Soft Skills:

• Exceptional communication skills with the ability to translate technical concepts into business-friendly language.
• Strong problem-solving abilities with a proactive attitude toward identifying opportunities for improvement.
• Collaborative mindset with experience working across cross-functional teams in fast-paced environments.

Desirable Qualifications:

• Prior experience in media or advertising industries is a plus but not mandatory.
• Familiarity with financial forecasting models or campaign optimization strategies is advantageous.

Aboriginal and Torres Strait Islander Peoples are encouraged to apply.
To apply please click apply or call Eshita Majithia on 02 8289 3208 for a confidential discussion.