SQL ETL Developer

Who We Are:

LeadsOnline 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:

• 2 years of experience with Microsoft SQL Server and advanced SQL programming, including complex queries and stored procedures
• Demonstrated experience developing ETL solutions and data integration interfaces
• Proficiency in designing data mapping solutions and standardizing information across disparate systems
• Experience creating customized data exports in various formats (CSV, XML, JSON) that seamlessly integrate with destination systems
• Experience with data quality assurance techniques including data profiling, cleansing, and validation
• Understanding of data security and privacy best practices, especially for sensitive information
• Excellent analytical abilities with proven success diagnosing and resolving complex integration challenges

Preferred Qualifications:

• Experience with cloud-based database platforms – e.g. relational, NoSQL, and database as a service (DBSaaS)
• Knowledge of records management systems, particularly those used in law enforcement or related fields
• Experience configuring and managing secure file transfer protocols (SFTP) and related data exchange systems
• Knowledge of API integration methods
• Previous software development experience preferred
• Knowledge of version control systems (e.g., Git) for managing code and configuration
• Familiarity with Windows PowerShell scripting for automation of routine tasks
• Previous experience in a client-facing technical role
• Background in retail, pawn, or law enforcement sectors

Why Join LeadsOnline?

At LeadsOnline, we live by our core values:

• Service: We believe in providing a humble, joyful, excellent, and selfless service
• Energy: We believe in contagious optimism, a strong sense of purpose, and life and light.
• Ownership: We take full responsibility for our actions, always seeking better ways and acting decisively to ensure success for our team and clients.
• People: We prioritize people over things, fostering a supportive, collaborative environment where individual talents and teamwork are celebrated.

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.