AI Automations & Data Specialist

The System
United States
about 1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
3 years minimum
Compensation
$60,000.0
Working hours
Regular working hours

Tech stack

Microsoft Excel Artificial Intelligence Cron Data Validation Data Governance Database Design Python (Programming Language) Lookup Table Pivot Tables Power BI SQL Databases Time Tracking Software
+4 more
Scripting Zapier GPT Data Pipelines

Job description

  • Own and maintain our Power BI dashboards, critical for daily management. You handle all aspects of the underlying complicated system we have today - data pipelines, Python scripts, SQL cron jobs, gateway refreshes, etc. You handle maintenance and constantly improve
  • Own our monthly margin and quarterly profit share process, the most complex data processes we have. This means coordinating snapshots across time tracking, financials, and payroll; cleaning messy data across multiple sources; and validating DAX calculations against raw exports before results impact critical payouts to team
  • Build and maintain automations across the entire company. You’ll work across the team to build solutions that remove friction and improve everyone’s job. This may be a new Hubspot to Karbon integration for sales, an agent for our HR team to help with policy questions, or a better invoicing bot for a client, each handled with Claude and other apps
  • Documentation and support for others. You’re not just building in a corner. You document your work thoroughly and support teammates in understanding solutions you’ve built.

Requirements

  • A builder’s mentality: you don’t just identify problems and test technology - you build solutions, and take deep pride in building things people are excited to adopt and use
  • Excellent communicator: you can translate technical constraints into plain language and you know how to say “that won’t work - but here’s what will”
  • A genuine collaborator: you work effectively with team members across different levels of technical fluency. You understand natural pushback to what you build and know how to work with team to make it better
  • Relentless attention to detail: you obsess over the smallest of details, understanding the importance of 100% accuracy for data oriented work. You take great pride in accuracy
  • Endless curiosity: you ask why, don’t get deterred, and love edge cases. Always seeking better
  • Resourcefulness: as an excellent independent problem solver who can still ask for help
  • Humility: an openness to coaching and critiques; always seeking to improve
  • Joy: A pleasure to work with; energetic and warm and enthusiastic about your work

Professional Skills

  • 3+ years of hands-on experience with AI automations and data inside a B2B business
  • Power BI or equivalent expertise: you have built, maintained and optimized dashboards and the live production systems behind them - data pipelines, Python scripts, SQL cron jobs, gateway refresh chains. You understand database design, row-level security, have strong DAX fluency with nested multi-table logic, and are comfortable with Python and SQL. You’ve maintained pipelines, not just built dashboards on top of them and obsess over documentation
  • Proven workflow automation with AI and low-code tools: you have automated processes with tools like Claude, Zapier and Make that save material time. Maybe you haven’t built agents yet, but you’ve proven you can learn and build way beyond editing emails with ChatGPT
  • Advanced Excel: structured tables, XLOOKUP/VLOOKUP, named ranges, data validation, pivot tables, and strict file/path discipline in a connected data ecosystem
  • Strong data governance skills: you understand that a client renamed in one system, a new GL account added in another, or a mismatched ID can deeply corrupt work, dashboards, or payouts
  • Nice to have - basic accounting literacy: you don’t need to be a CPA, but you need to understand a chart of accounts, GL structure and the basics of accounting

Benefits & conditions

Be an Early Applicant Remote Hiring Remotely in United States 60K-60K Annually Mid level Remote Hiring Remotely in United States 60K-60K Annually Mid level Build, maintain, and improve AI-driven automations and data systems. Own Power BI dashboards and underlying pipelines (Python, SQL, DAX), manage complex margin/profit-share processes, create low-code AI automations (Claude, Zapier, Make), ensure data governance, and document/support solutions for company-wide use. The summary above was generated by AI, * Growth opportunities. We are a steadily growing company on a multi-decade journey of evolution. We relish promoting from within, and will support your efforts to grow with System Six

  • A joyful work environment where employees and culture are paramount. We deliver balance to our teams and want every employee to feel Elevated and Empowered at System Six
  • A 100% remote environment. We’ve been remote for 10+ years and are set up for you to succeed remotely while working with flexibility during daytime professional hours
  • Strong pay. This full-time role offers competitive compensation up to $5,000 USD / month and is based on experience
  • Competitive benefits. We will work to provide competitive benefits based on your country of origin, including PTO and Paid Holidays, 38K-88K Annually Mid level 38K-88K Annually Mid level Machine Learning * Payments * Security * Software * Financial Services Provide first-line remote and on-site technology support for employees and contractors, troubleshoot hardware/software issues, use help-desk tools, escalate to higher-level teams, and ensure customer-focused resolution following PNC policies. Wipfli

Transaction Advisory Services Manager

2 Hours Ago Remote or Hybrid United States 117K-158K Annually Senior level 117K-158K Annually Senior level Cloud * Fintech * Software * Business Intelligence * Consulting * Financial Services Lead transaction advisory engagements by performing financial analysis and modeling, evaluating deal structures and valuations, managing multiple projects, liaising with clients and cross-functional teams, preparing clear reports and presentations, and reviewing junior team members’ work to ensure accuracy and high-quality deliverables. Top Skills: ExcelFinancial Databases Wipfli

Senior, Transaction Advisory Services

2 Hours Ago Remote or Hybrid United States 88K-118K Annually Senior level 88K-118K Annually Senior level Cloud * Fintech * Software * Business Intelligence * Consulting * Financial Services Lead buy- and sell-side Quality of Earnings engagements: analyze financials, assess earnings quality, working capital, and net debt; prepare diligence reports and presentations; manage VDRs; mentor junior staff; support valuation, deal structuring, integration planning, and business development. Top Skills: ExcelFinancial DatabasesVirtual Data Rooms

What you need to know about the Colorado Tech Scene

With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.

Key Facts About Colorado Tech

  • Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
  • Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
  • Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
  • Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
  • Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute

About the company

At System Six, we’re building the best place to work in cloud-accounting - a place where our team members are the most important part of our business and where they consistently experience joy, flexibility and growth. We are a 65 person, growing, modern, 100% remote team delivering full-cycle accounting, tax, and other professional services to hundreds of U.S. clients.

We are actively seeking an AI Automations & Data Specialist, a joyful, technically sharp, and deeply curious builder who will support and build all things automation and data at System Six. You’ll step into what we have today - across tools like GPT/Claude, Make, Zapier, Supabase, PowerBI and various SaaS products. This includes modern app-connections via API, and complex internal PowerBI dashboards pulling data from a variety of sources with custom buildout via Python, SQL and DAX . You’ll learn and improve all we have today and also build things entirely anew. It is an incredibly exciting time to be in a growth-minded accounting firm - the opportunities to streamline and improve experiences - for our team and our clients - are nearly limitless. You’ll spend every day building the accounting firm of the future.

This is a fantastic full time global position for someone who loves to build, reporting directly to leadership. System Six has grown 3x+ over the last five years and plans to continue its growth for decades to come - in a sustainable, joyful manner. This is not your traditional accounting firm. Our talented team loves System Six and we can’t wait to show you how that energy permeates throughout our organization. So what are we looking for in an ideal candidate?

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on systemsix.applytojob.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

4:29 min

Implementing AI assistants for workplace productivity

Markus Hacker Markus Hacker +1 · WWC 2025

1:20 min

Drawing inspiration from Zapier for programmatic SEO

Dino Lozina · WWC 2022

1:02 min

Scheduling recurring automated operations through standard periodic cron jobs

Aurélie Vache Aurélie Vache · WWC Europe 2026

40 sec

Generative pre-trained transformer models powering code completions

lgonta lgonta +1 · WWC 2024

5:36 min

Connecting workflows with spreadsheets and API integrations

José Kadlec José Kadlec · WWC 2025

2:07 min

Designing for sustainable scheduling and utilization

Ricardo Sueiras Sueiras · LIVE

Videos

See all

Related articles

See all