Salary
💰 $80,000 - $100,000 per year
Tech Stack
BigQueryCloudETLGoogle Cloud PlatformPythonSQLTableau
About the role
- Hybrid role splitting time: 50% AI Solution Development and 50% Data Engineering & Analytics Support
- Build custom AI agents and copilots using Microsoft 365 Copilot Studio, Agent Builder, and Power Platform
- Create and deploy custom GPTs and AI assistants tailored to departmental needs
- Develop automated workflows integrating AI capabilities into existing business processes
- Design and refine prompts; document prompt patterns and best practices
- Configure and customize pre-built AI models for document processing and content generation
- Write and optimize SQL queries in BigQuery to support analyst requests and reporting needs
- Maintain and troubleshoot data pipelines between BigQuery and Domo
- Create and update Domo datasets, dataflows, and ETL processes
- Assist analysts with complex query development and performance optimization
- Document data transformations and maintain data dictionary for key tables
- Monitor data quality and implement basic data validation checks
- Schedule and automate recurring data refreshes and report generation
- Partner with business analysts to translate data requirements into technical solutions
- Provide hands-on support and training for AI tools and data platform users
- Identify opportunities to enhance analytics workflows with AI capabilities
- Create documentation bridging AI solutions with underlying data infrastructure
Requirements
- Bachelor's degree in any field with demonstrated interest in technology, data, or AI
- 2-4 years of experience in data analysis, IT, or technical role
- Proficiency in SQL with experience writing complex queries (joins, CTEs, window functions)
- Hands-on experience with at least one AI platform (ChatGPT, Claude, Copilot, Gemini)
- Experience with business intelligence tools (Domo, Tableau, Power BI, or similar)
- Strong problem-solving skills and ability to translate business needs into technical solutions
- Excellent written and verbal communication skills for working with non-technical stakeholders
- Direct experience with BigQuery and Google Cloud Platform (preferred)
- Experience with Domo administration, Magic ETL, or Domo Workflows (preferred)
- Microsoft Power Platform experience (Power Apps, Power Automate, Power BI) (preferred)
- Familiarity with Copilot Studio or similar no-code AI development platforms (preferred)
- Basic Python knowledge for data manipulation and API integrations (preferred)
- Understanding of data warehouse concepts (dimensional modeling, slowly changing dimensions) (preferred)
- Experience with prompt engineering techniques and LLM behavior (preferred)
- Ability to context-switch effectively between AI development and data engineering tasks
- Self-starter who can manage competing priorities from multiple stakeholders
- Patience for supporting users with varying technical backgrounds
- We are not able to offer sponsorship for this role now or in the future.