Job Description

JOB SUMMARY:

Luminosity is seeking a Data Engineer or Data Scientist proficient in SQL code to work on our portfolio of projects to:

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

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

3.      Generate pretrial justice system related RPO measures;

4.      Create and deploy scripting for use in various data pipeline solutions (e.g., SSIS, SnapLogic, Apache Airflow); and      

5.      Apply appropriate fuzzy logic matching algorithms (e.g., Levenshtein distance, Double Metaphone) to join siloed data sets.

We’re 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 research team

§  Adapts scripting for use on multiple database platforms (e.g., Microsoft SQL, PostgreSQL, Amazon Redshift)

§  Reviews existing code and identifies 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:

§  Master’s degree in computer science, information systems, data science, analytics, statistics, or a closely related field

§  All levels of experience will be considered

TECHNICAL KNOWLEDGE OR SKILLS:

§  Proficiency in reading and writing SQL code

§  Proficiency with statistical data analysis using Python, R, SQL, SAS, SPSS or Stata is required; ability to work in more than one is preferred

§  Deep expertise in at least one of the following skillsets required, with basic capability in at least one other

• Data Extraction, Transformation, and Loading (ETL) skillsets: Writing complex SQL queries that join multiple tables/databases. Given a business problem, independently explore databases/tables to identify best data sources.

• Data Visualization: Create data visualizations using Tableau, Microsoft Power BI, Sisense, Plotly, Seaborn, D3, ggplot2 or similar

• Statistics & Statistical Modeling: Create and use advanced machine learning algorithms and statistics such as regression, simulation, risk modeling, hypothesis testing, clustering, and various classification algorithms (e.g., random forests, logistic regression, decision trees)

TO APPLY: Please submit a resume, unofficial transcripts, and three references to Marie VanNostrand, Director of Data Analytics, results@luminosity-solutions.com   

 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.

Company Description

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 scientists, data architects, and data engineers. Our team is the leading authority on linking and integrating siloed data from independent justice system agencies to create 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.