ETL/SQL Software Developer

Company: Leadsonline
Location: Plano
Posted on: April 23, 2024

Job Description:

Reporting to the Director of Technical Integration, the SQL/ETL Software Engineer will design, develop, and implement front-end user interfaces, and develop back-end systems. This role interacts with external customers with a service mindset, diligence, energy, and confidence.

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

In 2022, LeadsOnline acquired Hawk Analytics, provider of CellHawk, the leader in mapping and analysis of Call Detail Records and other location-based digital evidence. CellHawk is instrumental in extracting rapid answers from messy digital evidence to connect suspects to crimes. We're thrilled at the good we're already doing together.

In 2023, LeadsOnline acquired Forensic Technology, the pioneer of automated ballistic identification and the creator of IBIS (Integrated Ballistic Identification System) technology. Their network of solutions, including hardware, software, and 3-D microscopy, is used in more than 80 countries to search for links between gun-related crimes. We're thrilled at the good we're already doing together.

Together, we are building the future of criminal investigations, and need people who are mission-driven, love technology, and who won't settle for less than excellence to join our team.

Role and responsibilities:

Design, develop, and implement front-end user interfaces using frameworks like React, ensuring a seamless, intuitive user experience. Also, develop and maintain back-end systems using languages such as .NET and Java.

Develop and maintain intricate T-SQL queries and stored procedures in Microsoft SQL Server to extract and transform data from client systems.

Conduct thorough data quality assurance checks, identifying anomalies and implementing corrective measures to ensure the accuracy and reliability of exported data.

Troubleshoot, resolve and Debug data-related issues promptly, providing support to end-users and addressing any discrepancies in exported data.

Ongoing communication and collaboration with development teams to understand data requirements and translate business needs into code for extraction and transformation. Must be able to contribute code into our existing product suites.

Implement data security measures during the extraction and export processes to protect sensitive information.

Who 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 but takes the lead in a team environment. You are an active problem solver and know how to find solutions. You take extreme ownership in all aspects of your work and share credit when credit is due. You can manage competing priorities and execute on agreed upon timelines. You have strong analytical and problem-solving skills and care deeply about the quality of excellence in our products, and for our clients, and will work hard to make sure they are taken care of. You're a proactive thinker that is always looking for ways to enhance the current processes.

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

This might be you if you have SOME of the following:

--- 3-5 years experience as a Software Developer

--- Strong Proficiency in back-end language; (C# and .Net) and front-end technologies such as (HTML, CSS, JavaScript.

--- Proficiency in writing complex T-SQL queries and generating CSV exports and other data formats using SQL Server tools or custom scripts, ensuring compatibility with downstream applications and systems.

--- Knowledge of version control systems (e.g., Git) to manage and track changes in SQL scripts and ETL packages.

What you can expect from us:

We serve with energy, diligence, and persistence. We deeply believe the work we do makes a difference in the lives of our users, the communities they protect, and the victims they serve. We won't stop pushing to make our products do more and to make each other better. You will have access to technical and soft skill training through sites like Pluralsight and RightNow Media to grow your skills. If we don't have it and you think you should learn it, just ask. Further, we take our work seriously. Ourselves, not as much. You'll have fun here.

Compensation:

--- $100,000 - $120,000

--- Bonus Target 10%

Employer Paid Benefits:

--- Medical insurance.

--- Vision insurance.

--- Dental insurance.

Safe Harbor 401(k) Matching.

--- Paid maternity leave.

--- Paid paternity leave.

--- Disability insurance.

--- Flex schedule.

--- Robust PTO package.

$100,000 - $120,000 a year

Keywords: Leadsonline, Frisco , ETL/SQL Software Developer, IT / Software / Systems , Plano, Texas