Apply on Employer Site

SoundThinking · 5 months ago

Data Conversion and Migration Engineer

Fremont, CA

Full-time

Hybrid

Senior Level

7+ years exp

SoundThinking is 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, designing scalable ETL workflows, and collaborating with cross-functional teams to ensure successful data transitions from legacy systems to modern cloud-based solutions.

Public Safety

H1B Sponsor Likely

Responsibilities

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

Qualification

PythonJavaETL processesData migrationDatabase analysisCloud technologiesData validationTechnical supportGenerative AIProblem-solvingCommunicationCollaboration

Required

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)

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

Must be able to pass CJIS clearance

Preferred

Familiarity with law enforcement data systems and regulatory standards (e.g., CJIS compliance) is highly preferred

Previous experience in law enforcement, government, or public sector data projects preferred

Experience with Generative AI is highly desired

Company

SoundThinking

SoundThinking, Inc.

Founded in 1996

Fremont, California, US

201-500 employees

http://www.soundthinking.com

H1B Sponsorship

SoundThinking has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (7)