PythonSQLTableauVBARAIClaudeGeminiLookerBIPower BI
About this role
Role Overview
Build, Maintain, and optimize complex spreadsheets in Excel and Google Sheets using advanced formulas and pivot tables.
Write, modify, and execute SQL queries (SELECT, JOIN, WHERE, GROUP BY, etc.) to extract and manipulate data from relational databases.
Design, test, and refine prompts for AI tools to automate text generations, summarize data, and enhance data cleansing workflows.
Use AI tools and spreadsheet scripts, like App Script or VBA, to streamline repetitive data entry and reporting tasks.
Assist in auditing, cleansing, and verifying data quality across spreadsheets and database systems.
Transform raw data into clear, actionable reports and dashboards.
Requirements
Advanced proficiency in Excel and Google Sheets using functions like VLOOKUP/XLOOKUP, INDEX/MATCH, Pivot Tables.
Knowledge of relational database concepts and ability to write SQL queries.
Experience crafting, evaluation, and editing prompts for AI tools such as ChatGPT, Claude, and Gemini.
Strong analytical mindset.
Experience using Python or R for data manipulation.
Experience creating reports using tools like Power BI, Tableau, or Google Looker Studio.
Experience in K-12, higher education, or government environments is a plus.
Tech Stack
Python
SQL
Tableau
VBA
Benefits
You'll work with a great group of people in a highly collaborative team and results oriented atmosphere
You'll have the opportunity to work in a dynamic and extremely positive environment where there is always the opportunity to challenge your skills and really move the needle
You’ll work with large, sophisticated, and progressive clients throughout North America
We provide a comprehensive benefits program including: $0 Healthcare option, company contribution to Health Savings Account with enrollment in a qualifying plan, 401(k) plus company match, Professional Development funds, Flexible Time Off (FTO) plus 11 company holidays, 4 weeks Parental/Caregiver Leave, company paid family building/fertility benefits through Progyny, Dental and Vision Insurance, and company paid Life/AD&D, short term and long term disability insurance.