SQL & ETL Integration Developer

Who We Are :

L eadsOnline is a powerful digital platform that helps law enforcement investigators and analysts advance criminal cases through the most current data on people and property across the U.S. and helps businesses reduce the hassles of reporting. Law enforcement agencies of every size and mandate use LeadsOnline to find suspects, stolen items, and patterns of individual and organized criminal activity. Businesses, including pawn shops, secondhand stores, scrap metal recyclers, and online marketplaces trust LeadsOnline more than any other system to freely, frictionlessly, and safely report transaction information to law enforcement.

Who You Are

You are driven, detail-oriented, and highly organized. You work well under pressure and are not afraid of doing hard things. You are a strong individual contributor who takes the lead in a team environment. You are an active problem solver who knows how to find solutions. You take extreme ownership in all aspects of your work and share credit when credit is due.

You have excellent written and verbal communication skills and can effectively communicate professionally with clients, their IT teams, and other team members. You want a tenured, meaningful career with LeadsOnline that lets you dig deep and plant roots. You are energized by the fact that we are a fast-growing, mission-driven, innovative team - looking for other bright minds to make us and themselves better along the way.

Role Overview :

We are seeking a skilled SQL Integration Developer who will design and implement robust interfaces between various records management systems and the LeadsOnline platform. This role is critical in ensuring seamless data flow from diverse law enforcement and business systems into our central database, enabling investigators to access comprehensive, real-time information for solving cases.

Key Responsibilities

• Design and develop robust interfaces between various records management systems and the LeadsOnline platform
• Create sophisticated data mapping solutions to standardize information from diverse source systems
• Develop and maintain complex SQL Server procedures and queries for efficient data extraction and transformation
• Configure and manage secure file transfer (SFTP) systems for reliable data exchange with external partners
• Implement automated validation routines to ensure data integrity throughout the integration pipeline
• Diagnose and resolve integration issues promptly, providing exceptional technical support to stakeholders
• Partner with cross-functional teams to translate business requirements into effective integration solutions
• Produce comprehensive documentation of integration architectures and data flows
• Establish and enforce security protocols to safeguard sensitive information during data transfers
• Continuously monitor and enhance the performance of integration processes

Required Qualifications :

Preferred Qualifications :

Why Join LeadsOnline?

At LeadsOnline, we live by our core values :

Be part of a mission-driven organization where your leadership makes a direct impact on law enforcement agencies, the communities they serve, and the people they protect.

LeadsOnline is an Equal Opportunity Employer and does not discriminate against applicants based on race, religion, color, disability, medical condition, legally protected genetic information, national origin, gender, sexual orientation, marital status, gender identity or expression, sex (including pregnancy, childbirth or related medical conditions), age, veteran status or other legally protected characteristics.