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