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
Click
here to apply!
|