Position Overview

SoundThinking is seeking a skilled Data Conversion/ETL Engineer to join our team in converting data from third-party legacy applications to our cloud-based SaaS solutions.

This role requires a strong background in Python, Java, and SQL/PostgreSQL, with an emphasis on data migration, conversion, and scalable data architectures. Experience in SaaS environments is essential, and familiarity with law enforcement data is highly preferred.

The ideal candidate will work closely with cross-functional teams, including product, engineering, and customer success, to ensure the seamless migration of data from legacy systems to modern cloud-based solutions. The role will involve designing and implementing data architectures, optimizing ETL processes, and ensuring the quality and integrity of data.

Essential Duties/ Responsibilities

Lead end-to-end data conversion processes, including planning, execution, and validation.
Design, develop, and maintain scripts in Python and Java to facilitate data migration and transformation.
Develop and optimize ETL (Extract, Transform, Load) processes, ensuring data is efficiently migrated and transformed across systems.
Analyze and evaluate database schemas in various relational database systems, including MS SQL Server, PostgreSQL, and Oracle DB, to ensure seamless data conversion and migration.
Ensure data consistency and accuracy through robust data validation and cleansing techniques.
Develop and maintain data ingestion and processing systems, ensuring smooth data flow from multiple sources.
Create and implement scalable data architectures to meet business needs and optimize performance.
Work with clients to extract, transform, and load (ETL) data from legacy systems to cloud-based SaaS solutions.
Collaborate with cross-functional teams to identify and resolve data-related issues, enhancing overall data management practices.
Provide technical support and troubleshooting for data migration and architecture-related issues.
Ensure data integrity, consistency, and security throughout the conversion process.
Document procedures and provide technical guidance to other teams as needed.
Communicate progress and address issues with both technical and non-technical stakeholders.
Stay updated on industry standards and best practices related to data migration, architecture, and conversion.

Minimum Qualifications

Bachelor’s degree in Computer Science, Information Systems, or a related field (or equivalent work experience).
5+ years of experience in data migration, data conversion, or data engineering roles.
Strong programming experience with Python 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.
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.

Location: Fremont, CA; Iselin, NJ; Tucson, AZ.

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 maintains a drug-free workplace policy.

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 +1.510.794.3183 or careers@soundthinking.com for assistance.

The above salary is based on a good faith estimate made at 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.