Job description

Job Title: Data Engineer - SQL Programming Expert

Location: St. Petersburg, Florida; residing in the Tampa Bay area prior to beginning work is required

Note: We are unable to sponsor H1-B Visa’s at this time due to our immediate need and the timeframe required for the sponsorship process

About Luminosity:
Luminosity, Inc. is a nationally recognized and highly regarded small, women-owned business whose mission is to advance pretrial justice in America. For nearly two decades, we have leveraged data analytics and implementation science to improve public safety, fairness, and cost effectiveness in communities across the country.

Luminosity’s Data Analytics team consists of expert business analysts, data architects, data engineers, and data scientists. Our team is the leading authority on linking and integrating siloed data from independent justice system agencies and creating usable, accessible, interpretable, and actionable data.

Luminosity’s pretrial justice data analytics, research, and implementation projects have been presented at prestigious national events, cited in numerous high-profile media outlets, and published in top tiered academic journals. Our Transforming Siloed Data Into Justice System Insights initiative is underway in cities and states across the US.

Luminosity team members are committed to creating a highly collaborative and effective work environment that is open and welcoming to individuals of all backgrounds and life experiences. We prioritize developing a workforce that is as diverse as the communities in which we work.

Job Summary:
Luminosity is seeking a Data Engineer with expertise in SQL to work on our portfolio of projects to:

1. Assess, modify, and standardize siloed justice system data for integration and interoperability;

2. Identify candidate elements and apply appropriate fuzzy logic matching algorithms (e.g., Levenshtein distance, Double Metaphone) to join siloed data sets;

3. Assist in the creation and application of business logic for generating research, performance, and outcome (RPO) measures;

4. Generate research, performance, and outcome measures;

5. Create and deploy scripting for use in various data pipeline solutions (e.g., SQL Server Integration Services, SnapLogic, Airflow).

We are seeking a smart, motivated, and detail-oriented person who is qualified to work on all aspects of a project. This position offers the opportunity to work directly with leading policy-makers on projects with immediate real-world impact.

Responsibilities:

• Contributes to the design and implementation of an efficient and reproducible data processing pipeline
• Works with the team to standardize, transform, and link data across siloed justice software systems
• Cleans, transforms, merges, and matches between large and complex datasets
• Troubleshoots complex SQL queries written by others with little guidance
• Writes complex SQL queries that join multiple tables/databases
• Given a business problem, independently explores databases/tables to identify best data sources
• Analyzes existing data structures, procedures, and queries to identify and suggest improvements and optimizations
• Quickly generates ad hoc reports for analysis by the analytics team
• Adapts scripting for use on multiple database platforms (e.g., Microsoft SQL, PostgreSQL, Amazon Redshift)
• Reviews existing code identifying opportunities for optimizations
• Develops new and tests, debugs, troubleshoots existing scripts, views, functions, and stored procedures

Competencies:

• Advanced ability to apply logic to complex issues
• Strong initiative and a resourceful approach to problem-solving and learning
• Ability to work independently and as part of a team in a fast-paced environment
• Sound critical thinking skills
• Strong attention to detail with superb analytical and organizational skills
• Strong interpersonal skills
• Excellent written and verbal communication skills, with the ability to present data in a simple and straightforward way for non-technical audiences

Education, Experience, and Certifications:

• Minimum of Bachelor’s degree in computer science, information systems, systems engineer, or a closely related field
• Minimum of 2 years of experience or a related Master’s degree

Technical Knowledge or Skills:

• Proficiency in SQL with an emphasis on the syntax of MS SQL is required
• Ability to work in PostgreSQL, MySQL, and/or Amazon Redshift is strongly preferred
• Familiarity with other common programming languages including Python, R, and Java
• Deep expertise in Data Extraction, Transformation, and Loading (ETL) processes
• Familiarity with data analytics tools, including PowerBI, Tableau, and Python
• Experience using cloud-native services on one or more Cloud Platforms (Azure, AWS, and/or GCP)

To Apply: Please submit a resume, unofficial transcripts, and three references

Luminosity is an Equal Opportunity Employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national or ethnic origin, age, status as an individual with a disability, protected veteran status, genetic information, or other protected classes under the law.

Job Type: Full-time

Pay: $75,000.00 - $90,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Health insurance
• Paid time off
• Relocation assistance

Schedule:

• Monday to Friday

Ability to commute/relocate:

• Saint Petersburg, FL 33701: Reliably commute or planning to relocate before starting work (Required)

Application Question(s):

• Will you now, or in the future, require sponsorship for employment visa status (e.g. H-1B visa status)?

Education:

• Bachelor's (Required)

Experience:

• Python: 1 year (Preferred)
• SQL: 2 years (Required)
• Microsoft SQL Server: 2 years (Required)
• ETL: 2 years (Required)

Work Location: Hybrid remote in Saint Petersburg, FL 33701

offroadmanagementgroup.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, offroadmanagementgroup.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, offroadmanagementgroup.com is the ideal place to find your next job.