Data Systems, ETL Engineer I

Ensemble Performing Arts

. Write, test, and maintain SQL queries for operational domains including customers, accounts receivable, rentals, products, inventory, and payments .

Posted 9/15/2026full-timeRemote • New Jersey • United StatesJuniorMid-Level💰 $80,000 - $90,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in SQL query development, data migration, and reporting, with a strong focus on data quality and validation. Proficient in utilizing Python and PowerShell for data processing and automation within operational domains.

Highest-signal resume keywords

Relational SQL DevelopmentData MigrationPython ProgrammingETL ProcessesNetSuite Experience

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQL QueriesData ValidationData TransformationException ReportingData ProfilingControl TotalsNormalization RulesVersion ControlData Quality ChecksReconciliation Logic

Soft Skills

Problem SolvingCommunicationRemote Work Management

Tools & Technologies

Power QueryExcelNetSuiteShopifyMicrosoft SQL ServerFileMaker

Industry Keywords

ERPAccountingInventoryRentalRetailTransactional Data

Tech Stack

Tools & technologies

ERPETLJavaScriptMS SQL ServerPythonSQLTypeScript

About the role

Key responsibilities & impact

Write, test, and maintain SQL queries for operational domains including customers, accounts receivable, rentals, products, inventory, and payments
Investigate unfamiliar or poorly documented relational databases
Profile source data for completeness, duplication, referential integrity, unusual record states, and migration risk
Document extraction criteria, joins, filters, assumptions, control totals, audit fields, and known limitations
Develop and maintain operational reports, extracts, exception reports, and cross-system comparisons using SQL, Excel, Power Query, or approved reporting tools
Assist with NetSuite and Shopify saved searches, exports, and data investigations
Trace discrepancies across source systems, transformations, import files, and target records to identify root cause
Execute assigned data-conversion workstreams using approved requirements, source-to-target mappings, and acceptance criteria
Develop and maintain mappings, normalization rules, exception categories, and deduplication logic
Prepare import-ready outputs and reconcile record counts, quantities, balances, totals, duplicates, exclusions, and transformation results
Create evidence packages and support post-import verification, corrections, and documented rerun procedures
Develop Python, PowerShell, or comparable utilities for file ingestion, transformation, validation, reconciliation, exception reporting, and export generation
Convert recurring SQL and Excel processes into version-controlled, tested, maintainable scripts or scheduled workflows
Apply logging, configuration management, error handling, restartability, and safe-recovery practices
Maintain queries, scripts, mappings, runbooks, and recovery procedures; participate in review and cross-training
Support implementation testing, cutover activities, and issue investigation for assigned workstreams
Work with the Software Systems Engineer and business subject-matter experts to independently execute defined technical workstreams after onboarding

Requirements

What you’ll need

Two or more years of relevant experience in database development, data migration, reporting, ETL, application data support, or a closely related field; equivalent demonstrated capability will be considered
Strong relational SQL, including joins, CTEs, aggregations, data-quality checks, and reconciliation logic
Familiarity with window functions and query-performance basics
Working proficiency in Python, PowerShell, C#, JavaScript/TypeScript, or another language suitable for repeatable data processing
Experience transforming, validating, and documenting structured data using record counts, control totals, exception reporting, and traceable source-to-output logic
Familiarity with version control, testing, logging, error handling, and maintainable technical documentation
Experience with ERP, accounting, inventory, rental, retail, or other transactional data
Ability to investigate technical problems, communicate findings and uncertainty, incorporate review, and manage defined assignments in a fully remote environment
NetSuite, Shopify, FileMaker, or Microsoft SQL Server experience is a plus

Benefits

Comp & perks

401(k) with employer match
Health benefits
Vision benefits
Dental benefits
Paid Time-Off
Opportunities for growth and leadership
Flexible, people-first culture