Data Engineer

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process. Full Time AL, US Job Summary The SQL Data Engineer is responsible for data investigation, remediation, migration, and quality assurance across Neumo's Revenue Compliance product line. Reporting to the Development Manager, this role works within a cross-functional product team to ensure the integrity, accuracy, and reliability of production data supporting tax filing and revenue collection systems. This position focuses on SQL-driven data operations — investigation, validation, migration, and controlled remediation of production data — rather than greenfield application development. Immediate priorities include supporting an active data remediation effort and executing a data migration to a new platform. Duties and Responsibilities Investigate and diagnose data integrity issues across multi-million-row production databases Write and execute complex SQL queries spanning dozens of related tables (returns, schedules, sub-schedules, audit logs, payment records) Build and maintain data validation scripts that identify affected records and categorize them by scenario Develop safe, testable bulk data correction scripts with dry-run capability, transaction isolation, and rollback support Plan and execute data migrations between platforms, including schema mapping, transformation logic, data validation, and cutover planning Produce structured reports on data quality — affected record counts by jurisdiction, return type, and scenario Troubleshoot, debug, and optimize database components and query performance Collaborate with Product Owners, QA, DevOps, and application engineers to understand data flow from UI through business logic to database Participate in code review for any scripts or tools that modify production data Document changes, migration procedures, and implementation details where appropriate Support production systems and assist with issue resolution and root-cause analysis Perform other duties as assigned Education and Experience Bachelor's degree in Computer Science, Software Engineering, Information Systems, or a related technical field required. Equivalent combination of education and relevant professional experience may be considered in lieu of a degree. Minimum of 5 years of professional experience working with relational databases in enterprise or SaaS environments Expert-level SQL Server skills — complex multi-table queries, query plan analysis, safe bulk update scripts, and deep understanding of relational integrity Proven experience with data migrations — schema mapping between source and target systems, transformation logic, data validation, and cutover execution Experience supporting applications in production environments and troubleshooting performance or data integrity issues Experience working in Agile/Scrum development environments Experience with cloud platforms (Azure preferred) and CI/CD pipelines is preferred Experience working with government, tax, licensing, financial systems, or other regulated industries is a plus Knowledge, Skills and Abilities Required: Expert-level SQL Server skills — complex multi-table JOINs, CTEs, window functions, query plan analysis, indexing strategy Experience writing safe bulk UPDATE/INSERT/DELETE scripts against production databases Strong understanding of relational integrity — foreign keys, referential constraints, cascade behavior Experience with data migration patterns, ETL processes, and data quality validation Experience with SQL Server Reporting Services (SSRS) or equivalent reporting tools Comfort navigating a large, unfamiliar schema independently Strong troubleshooting and problem-solving skills Detail-oriented and methodical — the kind of person who double-checks row counts before committing Ability to analyze requirements and deliver production-ready solutions Preferred: Experience parsing and shredding XML data into relational tables (OPENXML, XQuery, FOR XML) Familiarity with Azure SQL Managed Instance or SQL Server on Azure Experience with .NET applications (VB.NET, C#) — understanding how the application writes data Familiarity with audit log analysis and forensic data investigation Experience with Dapper, Entity Framework, or ADO.NET Experience supporting tax, revenue, or regulated systems Understanding of security, reliability, and maintainability considerations in production systems Experience with SaaS or hosted application environments Physical Demands Must be able to remain in a stationary position for most of the day Constantly operates a computer and other office productivity machinery, such as a printer/copy machine This position needs to occasionally move about inside the office to attend daily SCRUM and other team meetings Neumo offers a competitive benefits and compensation package and is looking for team members who will thrive in our dynamic environment. Neumo is an Equal Opportunity Employer. Selection for a position will be made without regard to race, religion, national origin, sex, political affiliation, marital status, non-disqualifying physical handicap, and age. #J-18808-Ljbffr