Sr. Data Conversion/ ETL Engineer

SoundThinking is seeking an experienced 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 (primary language), 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 modules / classes primarily 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.
Utilize Python for data extraction, transformation, and loading tasks, ensuring reusable and efficient code that optimizes ETL workflows.
Familiarity with Object Relational Mapping, build tools, and validation libraries (hatch, pydantic, sqlalchemy)
Experience with TDD (Test Driven Development)
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, utilizing Python-based validation checks.
Document procedures and provide technical guidance to other teams as needed, including Python code examples and best practices.
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).
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

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.

#LI-SSD

Apply for this job

First name

Last name

Email address

Location

Phone number

Resume

Attach resume

Attach another file

Attach file

Are you authorized to work in the United States?

What is your earliest start date?

What is the highest level of education you’ve obtained?

How did you learn about this job?

Referred by?

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.