Data Engineer
Neumo Holdings LLC•Salem, VA
•Onsite
About The Position
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.
Requirements
- 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
Nice To Haves
- 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
- 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
- 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
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 Agile/SCRUM ceremonies, including planning, estimation, and retrospectives
- 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
Benefits
- competitive benefits and compensation package
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
