Sr. Data Integration Engineer

SoundThinking, Inc.; Woodbridge Township (NJ); Hybrid; USD 100,000 - 160,000; Full time

Job summary

Join a leading company as a Sr. Data Integration Engineer where you'll design, build, and test integration software for clients in a hybrid work environment. This role requires expertise in data integration, including database analysis and ETL processes. The ideal candidate has a degree in engineering, extensive experience with Relational Databases, and strong skills in Python and Scala.

Qualifications

• Minimum of 5 years of experience with languages used in Apache Spark (Python/Scala/SQL).
• Excellent documentation skill is a must.
• Self-motivated, detail-oriented, and team player.

Responsibilities

• Analyze/reverse-engineer client database structures/schemas.
• Build ETL/ELT connectors from clients’ data.
• Verify quality of converted data using automated test suites.

Skills

Relational Database

SQL

Python

Scala

Education

Bachelor’s degree in engineering

Job description

Join to apply for the Sr. Data Integration Engineer role at SoundThinking (formerly ShotSpotter)

Join to apply for the Sr. Data Integration Engineer role at SoundThinking (formerly ShotSpotter)

The Sr. Data Integration Engineer will design, build, test and deploy integration software to our clients. The Engineer will utilize in-house and industry-standard technologies to perform duties related to data analysis, conversion, consolidation and synchronization.

Essential Duties/Responsibilities

• Analyze/reverse-engineer client database structures/schemas.
• Document database structures, schemas.
• Build ETL/ELT connectors from our clients’ data to our solution.
• Build transformations around the data.
• Verify quality of converted data using automated test suites and ad hoc testing.
• Step through and debug ETL processes.
• Conduct validation sessions with client agencies.
• Establish ongoing synchronization between database
• Learn new technologies as our company grows.
  
  

Travel, 10%

Minimum Qualification

• Bachelor’s degree in engineering, a must
• Relational Database experience (Microsoft SQL Server preferred).
• Minimum of 5 years of experience with languages used in Apache Spark (Python/Scala/SQL).
• Exposure to data modelling notations such as ERD, Instance Diagramming, and/or UML.
• Excellent documentation skill is a must.
• Must be self-motivated, detail-oriented while multi-tasking and a team player .
  
  

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 [e-mail] 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.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Public Safety

Referrals increase your chances of interviewing at SoundThinking (formerly ShotSpotter) by 2x

Get notified about new Senior Data Engineer jobs in Iselin, NJ.

New York, NY $100,000.00-$200,000.00 3 months ago

New York, NY $153,000.00-$210,000.00 5 months ago

Senior Data Architect/Engineer - Leading Systematic Hedge Fund - New York

Senior Data Analyst cum Business Analyst

Data Engineer/Solutions Architect – Reinsurance - Hybrid

Fairfield, NJ $160,000.00-$195,000.00 2 weeks ago

Senior Data Solutions Developer - Private Markets (VP)

Senior Data Analyst-Mt Sinai Hospital - Transplantation Services

New York, NY $65,885.00-$110,500.00 16 hours ago

Senior Data Analyst-Mt Sinai Hospital - Transplantation Services

New York, NY $65,885.00-$110,500.00 20 hours ago

Healthcare Data Architect / Sr. Data Engineer

Senior Data Analyst – Middle Office & Investment Systems

Senior Software Engineer - Partner Experience Team, Bloomberg Connects

New York, NY $160,000.00-$240,000.00 1 week ago

Data Engineer Manager with Big Data Experience

New York, NY $150,000.00-$200,000.00 3 weeks ago

Azure Cloud Data Architect - Purchase NY, Morristown NJ, Charlotte NC (Hybrid)

New York City Metropolitan Area $200,000.00-$350,000.00 1 week ago

Senior Software Engineer - BLAW Contracts Drafting

New York, NY $160,000.00-$240,000.00 1 week ago

Senior Data Analyst – Middle Office & Investment Systems

Senior Engineer Identity & Access Management

Parsippany, NJ $115,000.00-$155,000.00 1 week ago

Jersey City, NJ $150,000.00-$200,000.00 3 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.