Senior Data Services Analyst in New York at Jobgether

NewJob Function: Information Technology
Jobgether
New York, 10455, United States
Posted on
New job! Apply early to increase your chances of getting hired.

Job Description

Senior Data Services Analyst

This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Senior Data Services Analyst based in the United States.

The Senior Data Services Analyst will lead the technical transformation of customer data into accurate, production-ready environments, ensuring a smooth and efficient onboarding experience. This hands-on role combines data engineering, automation, migration strategy, and customer-facing technical expertise. You will build and maintain Python and SQL solutions that replace repetitive manual processes with reliable, monitored, and reusable pipelines. Leveraging AI-assisted tools, you will improve data quality, accelerate migrations, and introduce smarter workflows while maintaining rigorous human oversight. As the technical lead for Data Services, you will also mentor colleagues, establish best practices, and help shape the team's future as it grows. Your work will directly influence customer satisfaction, operational efficiency, and the reliability of critical business data.

Accountabilities:

You will own the technical processes and tools that support customer data onboarding, from initial assessment and preparation through migration, validation, and production go-live. You will combine engineering excellence with proactive customer support to deliver secure, repeatable, and high-quality data services.

  • Data Engineering and Automation

    • Design, develop, and maintain production-grade Python pipelines, scheduled data deliveries, and API-based integrations, including S3 reports and ERP exports.

    • Build automated workflows with logging, testing, monitoring, alerting, and Git version control to replace repetitive manual data tasks.

    • Maintain scripts, tools, and database restoration processes in shared repositories and cloud environments such as Git and AWS, ensuring solutions are not dependent on local machines.

    • Evaluate, pilot, and implement automation tools and AI-assisted technologies to improve efficiency and reliability.

    • Develop reusable libraries, templates, and self-service tools that allow standard data imports to run with minimal manual intervention.

    • Measure automation outcomes, including hours saved and errors prevented, and systematically retire the manual processes replaced by new solutions.

  • AI-Assisted Data Processing

    • Use AI and large language model (LLM) tools to profile and clean complex source data, suggest field mappings and crosswalks, identify anomalies, and prepare data readiness findings.

    • Design human-in-the-loop workflows with appropriate testing, review, and validation checkpoints before any AI-generated output reaches production.

    • Review and verify AI-generated code, mappings, and recommendations to ensure accuracy, security, and compliance with internal guidelines.

    • Follow established policies governing the use of AI tools with customer information.

  • Data Migration and Quality Assurance

    • Plan and execute production migrations and cutovers for multi-location and multi-entity customers.

    • Manage migration schedules, freeze windows, delta loads, validation gates, go/no-go criteria, and rollback plans.

    • Create and maintain detailed data mapping and crosswalk specifications covering users, roles, shops, tax locations, part locations, customers, units, and vendors.

    • Obtain customer approval of mapping specifications before loading data into production.

    • Build dry-run, comparison, and pre-load snapshot tools to preview changes, verify results, and support reversals where possible.

    • Reconcile migrated information against source systems, including record counts, inventory quantities and values, adjustments, and average cost carryover.

    • Run automated data quality checks for every migration, supported by targeted manual inspection and discrepancy resolution.

    • Provide customers with pre-load previews, validation reports, and data quality scorecards before go-live.

  • Customer Engagement and Project Delivery

    • Lead data readiness sessions and provide expert guidance to help customers identify and resolve data issues before migration.

    • Document customer decisions regarding lookback periods, filters, merge rules, and other migration requirements.

    • Manage data import escalations throughout the onboarding and go-live process.

    • Explain technical requirements, risks, and tradeoffs in clear, accessible language.

    • Manage scope expectations and document work performed to support accurate project planning and change-order decisions.

    • Write complex SQL queries and develop data extraction solutions for customer and internal reporting.

    • Identify trends across systems, document findings in shared repositories, and recommend improvements based on data analysis.

    • Maintain and troubleshoot data in Salesforce, as well as track effort and rework against each customer statement of work.

  • Documentation and Technical Leadership

    • Document every stage of data processing, including extraction, mapping, transformation, loading, validation, and cutover.

    • Maintain a version-controlled inventory of scripts, standard operating procedures, and technical runbooks for each type of data engagement.

    • Establish consistent documentation practices so that essential process knowledge is accessible across the team.

    • Serve as the technical lead for Data Services, mentoring colleagues in Python, SQL, data quality standards, and AI-assisted development.

    • Review scripts, data imports, and AI-generated code before execution in production environments.

    • Help develop the team's technical capabilities and contribute to its evolution as the organization scales.

    • Perform additional duties as assigned while complying with confidentiality, security, and regulatory requirements.

Requirements:

The ideal candidate is a technically strong data professional with practical experience building automated data workflows, managing production migrations, and solving complex data quality challenges. You should be comfortable writing reliable Python and SQL, applying AI tools responsibly, and communicating directly with customers. Strong ownership, attention to detail, and the ability to manage several projects under fixed deadlines are essential.

  • Bachelor's degree in Computer Science, Information Systems, Data Science, Business, or a related field, or equivalent relevant professional experience.

  • At least 3 years of experience in data migration, ETL, data engineering, or analytics, including hands-on production Python scripting and SQL development.

  • Practical experience using AI tools, such as LLM assistants or AI coding platforms, to accelerate real-world data or engineering work.

  • Strong Python skills, including pandas, for repeatable and testable data loads and transformations.

  • Experience with Git version control, shared code repositories, and code review practices.

  • Advanced SQL knowledge, including joins, unions, aggregations, inserts, and updates.

  • Ability to interpret database schemas, understand table relationships, optimize queries, and restore database backups within shared, automated environments.

  • Experience reconciling source and migrated data, resolving discrepancies in large datasets, and implementing validation checks, snapshots, dry runs, and rollback strategies.

  • Familiarity with REST APIs, cloud storage platforms such as AWS S3, and scheduled data feeds with monitoring and alerting.

  • Advanced Excel and CSV handling skills, including formulas, lookups, quoting, encoding, and preserving leading zeros.

  • Strong automation mindset, with the ability to identify repetitive tasks and replace them with scripts, templates, or orchestrated workflows.

  • Ability to build human-reviewed AI workflows with clear checkpoints, test data, and measurable accuracy standards.

  • Understanding of data privacy and security practices when using AI tools with customer information.

  • Strong customer-facing communication skills and a service-oriented mindset, including the ability to lead data readiness sessions, explain technical tradeoffs, document decisions, and anticipate customer concerns.

  • Ability to work independently, prioritize multiple concurrent projects, and remain composed during fixed deadlines and production cutover windows.

  • Excellent documentation skills, including the ability to create clear SOPs and runbooks that enable teammates to execute processes consistently.

  • Experience migrating customer data between business systems, such as shop management, ERP, or accounting platforms, is preferred.

  • Experience building or managing production workflow automation and orchestration tools is preferred.

  • Previous mentoring or technical team leadership experience is an advantage.

  • Familiarity with heavy-duty repair and fleet management data is preferred, including work orders, vehicles or units, preventive maintenance schedules, VMRS codes, parts and inventory, stock locations, adjustments, average cost, labor rates, and tax rates.

Benefits:

  • Annual compensation ranging from $86,601.00 to $106,086.22.

  • Opportunity to work in an AI-first environment where automation and emerging technologies are central to operational improvement.

  • Hands-on ownership of production data engineering, migration tooling, and customer onboarding processes.

  • Opportunity to serve as a technical lead and help shape the future growth of the Data Services team.

  • Exposure to complex customer data environments, cloud technologies, and large-scale automation initiatives.

How Jobgether works:
We use an AI-powered matching process to ensure your application is reviewed quickly, objectively, and fairly against the role's core requirements. Our system identifies the top-fitting candidates, and this shortlist is then shared directly with the hiring company. The final decision and next steps (interviews, assessments) are managed by their internal team.
We appreciate your interest and wish you the best!
Data Privacy Notice: By submitting your application, you acknowledge that Jobgether will process your personal data to evaluate your candidacy and share relevant information with the hiring employer. This processing is based on legitimate interest and pre-contractual measures under applicable data protection laws (including GDPR). You may exercise your rights (access, rectification, erasure, objection) at any time.
#LI-CL1

Explore Related Opportunities

Job Location

New York, 10455, United States

Frequently asked questions about this position

Apply For This Position

Apply Now