[Hiring] AI Data Engineer @Rockstar

Role Description

This role is seeking an AI Data Engineer who can serve as the critical bridge between the data warehouse, AI-driven analytics capabilities, and the operational workflows that power the business. This role is part data engineer, part data scientist, part prompt engineer, and part automation architect.

• Understand where and how to pull data from the database to answer specific business questions.
• Train and configure AI tools (Claude, Gemini) to automate analysis at scale.
• Build AI agents that eliminate repetitive operational work across the organization.
• Identify processes that can be automated and translate them into working solutions.

Key Responsibilities

• Query, extract, and transform data from the data warehouse (BigQuery) to answer complex, multi-dimensional business questions spanning inventory, organic sales, traffic, sponsored ads, and DSP.
• Understand the full schema of the data warehouse — which tables hold what data, how they relate to each other, and what joins are required for accurate cross-domain analysis.
• Partner with internal teams to identify the most common and highest-value analytical questions clients and team members need answered.
• Design and build automated data pipelines and queries that feed AI tools with clean, structured, and contextually appropriate data.
• Develop and refine Claude Skills and Gemini Gems that enable conversational AI to conduct reliable eCommerce data analysis.
• Collaborate with prompt engineers to document best practices for data analysis (statistical methods, benchmarking approaches, trend identification).
• Continuously improve and validate AI-generated outputs against manual analysis to ensure accuracy and trustworthiness.
• Help automate recurring analytical workflows into chatbot-style interfaces that the broader team can use without SQL knowledge.
• Identify operational bottlenecks and repetitive tasks across the business, then design and deploy AI agents to automate them.
• Build, test, and maintain AI agents using Claude and Gemini, ensuring they perform reliably and are adopted by the team.

Qualifications

• Strong proficiency in SQL — complex queries, multi-table joins, window functions, CTEs.
• Working proficiency in Python for data manipulation and analysis (Pandas, NumPy, or similar).
• Familiarity with JavaScript and JSON file structures.
• Hands-on experience with Google BigQuery.
• Experience working with or developing for large language models — specifically Gemini and/or Claude.
• Hands-on experience building and managing AI agents that automate business processes and routine tasks.
• Strong understanding of data warehousing concepts: schema design, table relationships, data modeling.
• Ability to translate business questions into precise, efficient queries and then into AI-readable instructions.
• Enough business acumen and operational awareness to independently identify automation opportunities.
• Familiarity with digital commerce or eCommerce data (sales, advertising, inventory, traffic metrics).

Nice-to-Have

• Experience with Amazon Ads API data, DSP reporting, or marketplace analytics platforms.
• Background in data science — statistical analysis, regression, forecasting, segmentation.
• Experience building internal tools, dashboards, or chatbot interfaces.
• Prompt engineering experience with structured outputs (JSON mode, tool use, system prompts).
• Experience with MCP (Model Context Protocol) servers, API integrations, or connecting AI tools to external data sources.

Working Conditions & Expectations

• Must have significant overlap with EST business hours.
• Must be available via Slack, WhatsApp, and email during working hours.
• This is a full-time role — no secondary employment during the engagement.
• The team is looking for a long-term team member.
• A professional reference that can be contacted is required.
• Success in this role leads to increased responsibility, bonuses, and potential conversion to a full-time employee with benefits.

Reports To

Technology / Data Leadership

Employment Type

Full-Time Contractor (long-term).