Data Engineer
Avenu Insights & Analytics, LLC
- El Paso, Texas, United States
- El Paso, Texas, United States
Über
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
Sprachkenntnisse
- English
Hinweis für Nutzer
Dieses Stellenangebot stammt von einer Partnerplattform von TieTalent. Klick auf „Jetzt Bewerben”, um deine Bewerbung direkt auf deren Website einzureichen.