Data Analyst & AI Automation Specialist
Role details
Job location
Tech stack
Job description
We are seeking a highly autonomous Data Analyst & AI Automation Specialist. In this role, you will support all lines of business by transforming manual financial processes into streamlined, automated data solutions. This is not a traditional engineering position; it is an operational data role embedded within a non-technical business team. You will act as a strategic partner-listening to high-level business logic and requirements from non-technical stakeholders and independently figuring out how to build, automate, and maintain the underlying technical pipelines. The ideal candidate is a proactive self-starter who looks at manual data bottlenecks and leverages scripting, cloud data structures, and generative AI tools to eliminate them. Key Responsibilities: Automation & Pipeline Engineering
- Proactive Process Automation: Identify manual workflows (e.g., weekly data exports and snapshots) and proactively leverage tools like Python, SQL, and AI prompting to build background scripts that automate execution and data storage.
- Data Refresh & Infrastructure Integration: Build and deploy custom automation solutions that seamlessly pull data from multiple sources (Snowflake), process it, and automatically push refreshes to front-end visualization tools.
- Version Control & Maintenance: Manage code, analytical assets, and automation scripts using basic GitHub repository management practices (commits, branches, pull requests).
- Data Entry & Optimization: Perform necessary data cleanups, optimization, and data entry tasks to ensure reporting accuracy and system integrity.
Financial Insights & Dashboarding
- Dashboard Maintenance & Troubleshooting: Own the day-to-day maintenance, running, and troubleshooting of the team's pre-built Tableau dashboards.
- Custom Analysis Generation: Gather user feedback and business requirements from finance partners to spin up new, dynamic dashboards, internal reporting tools, or comparative analytics.
- Variance & Trend Reporting: Build automated slicing-and-dicing models to analyze month-over-month financial forecasts, instantly surfacing and presenting core variance drivers to leadership.
Generative AI & Agent Deployment
- AI Tool Implementation: Design, develop, and maintain AI-enabled workflows using generative AI interfaces (e.g., Claude, ChatGPT, or internal wrappers) to maximize team throughput.
- Agent & Prompt Engineering: Build and deploy lightweight AI agents, reusable prompt libraries, and automated assistance features tailored for financial data tasks.
- Team Enablement: Document automated AI workflows and create simple instructions to guide non-technical team members on how to responsibly and effectively utilize these tools.
Requirements
- Experience: 5+ years of experience in a tools/applications implementation role, with a proven track record of managing data pipelines and business process automation.
- The Core Stack (Required): Advanced programming proficiency in SQL and Python (including packages such as Pandas, NumPy, and Jupyter Notebooks).
- Data Ecosystems (Required): Hands-on experience working with Snowflake (or similar Data Lake systems) and Tableau.
- AI Tooling & Prompting: Foundational comfort with Large Language Models (specifically Claude or ChatGPT) and experience writing prompts or scripts to automate routine, manual tasks.
- Communication & Autonomy: Outstanding ability to work independently with minimal technical supervision. Must be able to distill complex data logic into simple, clear business terms for non-technical stakeholders.
- Data Integrity & Confidentiality: Proven experience handling highly sensitive, classified financial data and unreleased business insights with the utmost discretion.
- BA/BS degree preferred, or equivalent practical data automation experience.
Preferred Qualifications
- Financial Data Literacy: Prior exposure to core corporate financial processes-including end-to-end purchase orders (POs), invoices, forecasting, accruals, and P&L analysis-is highly preferred to aid in data self-review.
- Advanced AI Frameworks: Direct familiarity with AI agent frameworks (e.g., LangChain, LlamaIndex) or building custom AI skills.
- Advanced Automation: Familiarity with GitHub Actions, CI/CD workflows, or automated repository pipeline deployment.
Please note this is a hybrid role in Culver City, CA. You must be able to work 3 days onsite (Tuesday, Wednesday, Thursday) and 2 days remote (Monday and Friday).