The Data Conversion Engineer designs and executes end‑to‑end data migration projects—extracting complex data sets from legacy relational and non‑relational systems, transforming and validating them against new application schemas, and loading them reliably at scale. You will own the technical strategy and hands‑on implementation of conversion pipelines that enable our customers to transition cleanly onto SoundThinking’s SaaS platforms.
Essential Duties/Responsibilities
- Discovery & Profiling – Reverse‑engineer legacy database schemas (SQL Server, MySQL, proprietary) to understand table relationships, data quality issues, and hidden business rules.
- Mapping & Design – Create detailed source‑to‑target mapping documents and entity‑relationship diagrams; identify required transformations, default values, and data enrichments.
- Pipeline Development – Build ETL/ELT pipelines using Python, SQL (CTE, window functions, bulk operations), and modern orchestration frameworks (Airflow, dbt, AWS Step Functions).
- Conversion Execution – Manage full migration cycles including dry runs, delta loads, and cut‑over by optimizing the process and minimizing downtime.
- Validation & Reconciliation – Implement automated row‑level and aggregate‑level validation tests; generate audit reports that prove completeness, accuracy, and referential integrity of converted data.
- Optimization & Automation – Tune queries for multi‑hundred‑GB datasets (PostgreSQL, Aurora, Redshift); leverage parallelism, partitioning, and streaming to hit aggressive timelines.
- Documentation & Handoff – Produce precise technical run‑books, rollback plans, and post‑migration support guides; mentor junior engineers and client analysts on best practices.
Minimum Qualifications
- 8+ years working on data conversion or large‑scale ETL projects in production environments.
- Advanced SQL expertise—able to write and optimize complex joins, window functions, and bulk‑load operations.
- Proficient in Python for data transformation, automation scripts, and orchestration.
- Proven experience with schema mapping, data quality assessment, and reconciliation techniques.
- Hands‑on with at least one major cloud platform preferably AWS (S3, DMS, Glue, RDS/Aurora)
Travel: 10%
Hybrid Workplace
SoundThinking follows a hybrid schedule for employees who live equal to or less than 50 miles from one of our office locations, which include Fremont, CA, Tucson, AZ, Washington, D.C., or Iselin, NJ. Employees are expected to work onsite 3 days per week – the specific days are dependent on the office location.
SoundThinking provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, SoundThinking complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.
SoundThinking expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of SoundThinking’s employees to perform their job duties may result in discipline up to and including discharge. If you are an individual with a disability and require a reasonable accommodation to complete any part of the application process, or are limited in the ability or unable to access or use this online application process and need an alternative method for applying, you may contact SoundThinking at careers@soundthinking.com for assistance.
The above salary range is based on a good faith estimate made at the time of publication and may be modified in the future. The pay offered to a candidate may vary within this range depending on factors such as education, experience, and geographic location
Note: The Company reserves exclusive right in its sole discretion to modify, adjust, delete, add or otherwise change the above at any time.
#LI-SSD