Senior Data Services Analyst

Posted 4 Hours Ago
Be an Early Applicant
Hiring Remotely in Phoenix, AZ, USA
In-Office or Remote
Senior level
Automotive • Software • Transportation
The Role
Build and maintain Python and SQL data migration pipelines, API feeds, validation tooling, monitoring, and automation for customer onboarding. Lead production migrations and cutovers, design mappings and reconciliation processes, apply AI-assisted data profiling, and ensure data quality through testing, previews, and rollback planning. Manage customer readiness sessions, documentation, reporting, Salesforce data, and escalation handling. Serve as technical lead by mentoring teammates, reviewing code, and establishing standardized data services practices.
Summary Generated by Built In

Senior Data Services Analyst                                

At Fullbay, our mission is simple — to create safer roads for our families and yours. As leaders in the heavy-duty repair industry, we power shops with technology that helps them run smarter and more efficiently. As an AI-First company, we invite artificial intelligence to eliminate friction, spark innovation, and drive efficiencies in every conversation— for our teams and our customers.

The Senior Data Services Analyst owns how Fullbay turns a new customer's data set into a fast, accurate, white-glove onboarding. This role builds and runs the automation, validation, and migration tooling that takes a customer from signed contract to live production, using Python, SQL, and AI-assisted automation to replace manual data loading with repeatable, monitored pipelines. Every hour of manual effort removed is time the team can spend on the high-touch moments that make onboarding feel white glove.

This is a hands-on technical role, not a data-entry or file-upload role. The Senior Data Services Analyst writes production-grade Python and SQL, refines and optimizes current internal tooling, designs pipelines with testing and monitoring, and acts as the trusted expert customers rely on during their most important transition. The role also serves as technical lead for Data Services, with a path to leading the team as it scales.

The Right Wrench for the Job

In a heavy-duty shop, a great technician doesn't just replace the part that failed. They find out why it failed, fix the cause, and make sure the truck leaves the bay ready for the road. That's the mindset this role demands. When you see a repeated manual task, your first move is to script it, and you check every output, whether it came from a person or an AI tool, before it touches a customer's production data.

You're the right fit if you write clean, tested Python and SQL, explain a data tradeoff to a shop owner in plain language, and stay composed during a fixed cutover window. You treat every migration as a reputation moment, you anticipate problems before the customer sees them, and you enjoy teaching teammates what works. This isn't the role for someone who wants a queue of file uploads to work through. If you'd rather build the tool that retires the manual step and help our customers go live with confidence, we'd like to talk.

Primary Duties & Responsibilities:

  • Design, build, and maintain Python pipelines, scheduled data deliveries, and API-based feeds (such as S3 reports and ERP exports) that replace manual data work, with logging, automated tests, monitoring, alerting, and Git version control; host all scripts, tooling, and database restores in shared repositories and cloud environments (such as Git and AWS) rather than on a local computer, so everything is version controlled, maintained, and able to run automatically
  • Apply AI and LLM-assisted techniques to profile and clean messy source data, propose field mappings and crosswalks, flag anomalies, and draft data readiness findings, with human review and validation before any output touches production
  • Evaluate, pilot, and adopt automation and AI tooling, and build reusable libraries, templates, and self-service tools so standard imports run with minimal hands-on effort; measure hours saved and errors avoided, and retire the manual steps they replace
  • Plan and execute production data migrations and cutovers for multi-shop and multi-entity customers, including freeze windows, delta loads, validation gates, go/no-go criteria, and rollback plans
  • Design and maintain data mapping and crosswalk specifications (users, roles, shops, tax locations, part locations, customers, units, vendors) and obtain customer sign-off before loading
  • Run data readiness sessions with customers, give proactive expert advice to head off data problems early, and document customer decisions such as lookback periods, filters, and merge rules
  • Give customers pre-load previews, automated validation reports, and data quality scorecards before go-live, and own data import escalations through go-live
  • Build dry-run, diff, and pre-load snapshot tooling so changes to production data can be previewed, verified, and reversed where possible
  • Reconcile loaded data against source systems (record counts, inventory quantities and value, adjustments, and average cost carryover) and run automated data quality checks on every load, backed by targeted manual inspection
  • Write complex queries and extraction solutions for customer and internal reporting, and identify, document, and record trends across systems in a shared location, then recommend process improvements based on them
  • Maintain and troubleshoot data in Salesforce, keep a version-controlled script inventory and SOPs for each data work type, and log effort and rework against each customer statement of work so scope and change-order decisions rest on evidence
  • Document every stage of every data process (extraction, mapping, transformation, load, validation, and cutover) in a shared location, and lead Data Services toward consistent documentation so process knowledge no longer lives with individuals
  • Serve as technical lead for Data Services: mentor team members on Python, SQL, data quality standards, and AI-assisted development, review scripts, imports, and AI-generated code before anything runs in production, and grow toward leading the team as it scales

Additional Duties & Responsibilities:

  • Follow company guardrails on which AI tools may be used with customer data and how
  • Adhere to all confidentiality and compliance regulations
  • Perform other duties as assigned

Minimum Education & Work Experience:

  • Bachelor's degree in computer science, information systems, data science, business, or a related field, or equivalent related experience
  • 3+ years of experience in data migration, ETL, or data engineering and analytics, including production Python scripting and SQL
  • Hands-on experience using AI tools (such as LLM assistants or AI coding tools) to speed up real data or engineering work, with sound judgment about when to trust the output and when to verify it
  • Preferred: experience migrating customer data between business systems (shop management, ERP, or accounting), building or running workflow automation or orchestration tools in production, and mentoring or leading technical team members

Key Skills and Qualifications:

  • Python (including pandas) for repeatable, testable, logged data loads and transformations, with Git version control, code hosted in shared repositories rather than on local machines, and code review habits
  • SQL (joins, unions, aggregation, inserts, and updates), including reading table schemas, restoring database backups in the shared, automated environment rather than on a local machine, and reasoning about table relationships and query performance
  • Data reconciliation and safe handling of production data: comparing source and loaded data, resolving discrepancies in large datasets, and using dry runs, snapshots, validation checks, and rollback planning
  • REST APIs and cloud storage (such as AWS S3), including scheduled feeds with monitoring and alerting
  • Advanced Excel and CSV handling for data preparation and review (formulas, lookups, quoting, encoding, leading zeros)
  • A builder's instinct: when you see a repeated manual task, your first move is to script, template, or orchestrate it, and you use AI tools to profile messy data, draft mappings, and generate and review code
  • Ability to design human-in-the-loop workflows with clear checkpoints, test data, and measurable accuracy, and awareness of data privacy and security practices when using AI tools with customer information
  • Customer-facing communication with a white-glove mindset: runs data readiness sessions, explains requirements and tradeoffs in plain language, documents customer decisions, holds scope boundaries, and anticipates problems before customers see them
  • Works independently, prioritizes across concurrent projects, stays composed under fixed deadlines and cutover windows, and documents every stage of the work in clear SOPs and runbooks that teammates can follow without you in the room
  • Preferred: heavy-duty repair and fleet data knowledge, including work orders, units, PM schedules, VMRS codes, parts and inventory (locations, adjustments, average cost), and labor and tax rates

Physical Demands and Work Environment:

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

  • Regularly required to sit at a desk in front of a computer and use hands to finger, handle, or feel objects, tools, or controls (including a computer keyboard and operating a telephone), lift and/or move up to 10 pounds
  • Frequently requires the use of hands and arms for reaching, as well as the ability to walk and communicate effectively through speaking and listening
  • Specific vision abilities required by this position include close vision, color vision, and the ability to adjust focus
  • Noise level in the work environment is usually moderate
  • Type on a computer keyboard and look at a computer monitor, and operate a cell phone or a computer-based phone

Skills Required

  • Bachelor's degree in computer science, information systems, data science, business, a related field, or equivalent related experience
  • 3+ years of experience in data migration, ETL, or data engineering and analytics
  • Production Python scripting and SQL experience
  • Hands-on experience using AI tools, such as LLM assistants or AI coding tools, in real data or engineering work
  • Ability to judge when AI-generated output must be verified before use
  • Python and pandas for repeatable, testable, logged data transformations and loads
  • Git version control, shared repositories, and code review practices
  • SQL proficiency including joins, unions, aggregation, inserts, updates, schema reading, database backups, table relationships, and query performance
  • Experience with data reconciliation and safe handling of production data
  • Experience with dry runs, snapshots, validation checks, and rollback planning
  • REST APIs and cloud storage such as AWS S3
  • Advanced Excel and CSV handling, including formulas, lookups, quoting, encoding, and leading zeros
  • Ability to design human-in-the-loop workflows with checkpoints, test data, measurable accuracy, and data privacy awareness
  • Customer-facing communication skills and ability to explain technical requirements and tradeoffs plainly
  • Ability to work independently across concurrent projects and fixed cutover deadlines
  • Ability to document processes in SOPs and runbooks
  • Experience migrating customer data between business systems, shop management, ERP, or accounting systems
  • Experience building or operating production workflow automation or orchestration tools
  • Experience mentoring or leading technical team members
  • Heavy-duty repair and fleet data knowledge, including work orders, units, inventory, VMRS codes, labor, and tax rates
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Phoenix, AZ
115 Employees

What We Do

Fullbay is cloud-based shop management software built specifically for heavy duty repair shops. We are changing the industry so shop owners and their technicians can get more done in less time and have a life outside the shop. For career opportunities, please visit fullbay.com/careers.

Similar Jobs

BILL Logo BILL

Data Analyst

Fintech • Software
Remote
United States
2753 Employees
127K-152K Annually

The Aerospace Corporation Logo The Aerospace Corporation

Development Engineer

Aerospace • Artificial Intelligence • Cloud • Machine Learning • Software • Cybersecurity • Defense
Remote or Hybrid
Phoenix, AZ, USA
4600 Employees

The Aerospace Corporation Logo The Aerospace Corporation

Senior Supplier Quality Engineer - Data Analytics

Aerospace • Artificial Intelligence • Cloud • Machine Learning • Software • Cybersecurity • Defense
Remote or Hybrid
2 Locations
4600 Employees
97K-146K Annually

Rubrik Logo Rubrik

Field Marketing Manager

Artificial Intelligence • Big Data • Cloud • Information Technology • Software • Cybersecurity • Data Privacy
Remote
United States
3000 Employees
144K-217K Annually

Similar Companies Hiring

Revel Thumbnail
Aerospace • Hardware • Robotics • Software
Marina Del Rey, California
70 Employees
Blee Thumbnail
Artificial Intelligence • Marketing Tech • Software
New York, New York
33 Employees
Vega Thumbnail
Artificial Intelligence • Automotive • Insurance • Transportation
US
65 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account