Data Conversion and Migration Engineer

We are seeking a skilled and detail-oriented Data Conversion & Migration Engineer to lead the end-to-end process of data migration, transformation, and validation. This role involves hands-on development using Python and Java, the design and optimization of scalable ETL workflows, and active collaboration with cross-functional teams to ensure successful data transitions from legacy systems to modern cloud-based solutions.

Essential Responsibilities/Duties

Lead the complete data conversion lifecycle, including planning, execution, validation, and troubleshooting.
Design, develop, and maintain data migration modules and classes using Python and Java.
Build and optimize ETL (Extract, Transform, Load) processes to ensure efficient and accurate data flow between systems.
Write Python scripts for complex data transformation logic and reusability.
Perform field-level data conversion, ensuring consistency and mapping accuracy.
Generate structured JSON outputs and integrate with REST APIs for data delivery and ingestion.
Execute one-time and ad-hoc data conversions as needed by business or technical teams.
Leverage Python to perform robust data extraction, transformation, and loading tasks with a focus on reusability and efficiency.
Apply Test-Driven Development (TDD) principles to ensure code reliability and maintainability.
Analyze and interpret database schemas from MS SQL Server, PostgreSQL, and Oracle DB to support seamless data migration.
Perform data cleansing and validation to maintain accuracy, consistency, and quality.
Develop and maintain scalable data ingestion and processing systems.
Design and implement scalable data architectures tailored to business requirements.
Partner with clients to extract, transform, and load data into cloud-based SaaS platforms.
Collaborate across teams to resolve data-related issues and improve data management practices.
Provide technical support for data architecture and migration challenges.
Ensure end-to-end data integrity and security, employing rigorous validation methods.
Document technical processes and deliver guidance and best practices to internal teams.
Communicate progress and complex technical issues to both technical and non-technical stakeholders.
Stay current with industry trends and best practices in data architecture, migration, and validation.

Minimum Qualifications

Bachelor’s degree in Computer Science, Information Systems, or a related field (or equivalent work experience).
7+ years of experience in data migration, data conversion, or data engineering roles.
Strong programming experience with Python (primary) and Java.
Expertise in analyzing database schemas in relational databases, such as SQL, PostgreSQL, and Oracle DB.
Experience using Github Copilot and/or other AI Coding Assistants.
Experience with SaaS platforms and cloud technologies.
Proven experience in developing and optimizing ETL processes.
Understanding of database structures, data modeling concepts, and data storage solutions (e.g., databases, data lakes).
Familiarity with law enforcement data systems and regulatory standards (e.g., CJIS compliance) is highly preferred.
Strong problem-solving and analytical skills, with an ability to troubleshoot and debug Python scripts.
Excellent communication and collaboration abilities, with the ability to work across departments and communicate with both technical and non-technical stakeholders.
Previous experience in law enforcement, government, or public sector data projects preferred.
Must be able to pass CJIS clearance.
Experience with Generative AI is highly desired

Travel: 15%

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.

The above salary 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

#LI-SSD

Apply for this job

First name

Last name

Email address

Location

Phone number

Resume

Attach resume

Attach another file

Attach file

How did you learn about this job?

Referred by?

Are you legally authorized to work in the United States? Please answer yes or no.

Will you now or in the future require sponsorship for employment visa status? (H-1B. F-1B, CPT, OPT, etc.). Please answer yes or no

We invite you to complete the optional self-identification questions below used for compliance with government regulations and record-keeping guidelines. Any self-identification information provided will not be considered in the selection process.

GENDER

VETERAN STATUS Learn more about veteran statuses

If you believe you belong to any of the categories of protected veterans listed below, please indicate by selecting the appropriate category(ies). The hiring employer is subject to the Vietnam Era Veterans' Readjustment Assistance Act of 1974, as amended by the Jobs for Veterans Act of 2002, 38 U.S.C. 4212 (VEVRAA) and requests this information in order to measure the effectiveness of the outreach and positive recruitment efforts it undertakes pursuant to VEVRAA.

DISABILITY STATUS Learn more about disability statuses

We are required by law to provide equal employment opportunity to qualified people with disabilities. We are also required to measure our progress toward having at least 7% of our workforce be individuals with disabilities. To do this, we must ask applicants and employees if they have a disability or have ever had a disability. Because a person may become disabled at any time, we ask all of our employees to update their information at least every five years.

Identifying yourself as an individual with a disability is voluntary, and we hope that you will choose to do so. Your answer will be maintained confidentially and not be seen by selecting officials or anyone else involved in making personnel decisions. Completing the form will not negatively impact you in any way, regardless of whether you have self-identified in the past. For more information about this form or the equal employment obligations of federal contractors under Section 503 of the Rehabilitation Act, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.