What are the responsibilities and job description for the Data Engineer position at Neumo?
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
Required:
The noise level in the work environment is usually moderate as the employee works in an office setting, at an individual work station, using telephone and computer.
Physical Demands
With the backing of four decades of public sector expertise and corporate capability, Neumo has successfully supported government services. Neumo was honored and recognized for four (4) consecutive years as a GovTech 100 Company representing the top 100 companies focused on making a difference in and selling to state and local government agencies across the United States.
Neumo is committed to helping communities thrive and brings a wealth of experience combined with innovation. Today, Neumo offers more administrative and financial support to government officials than any other organization. And with a responsive, client-focused approach, we foster partnerships that give our customers the certainty they need to accomplish more.
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.
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 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
- 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
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
- 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
The noise level in the work environment is usually moderate as the employee works in an office setting, at an individual work station, using telephone and computer.
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
With the backing of four decades of public sector expertise and corporate capability, Neumo has successfully supported government services. Neumo was honored and recognized for four (4) consecutive years as a GovTech 100 Company representing the top 100 companies focused on making a difference in and selling to state and local government agencies across the United States.
Neumo is committed to helping communities thrive and brings a wealth of experience combined with innovation. Today, Neumo offers more administrative and financial support to government officials than any other organization. And with a responsive, client-focused approach, we foster partnerships that give our customers the certainty they need to accomplish more.
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.