Data Engineer - Center for Justice Innovation : Job Details

THE ORGANIZATION The Center for Justice Innovation is a community justice organization that centers safety and racial justice. Since our founding in 1996, the Center has partnered with community members, courts, and the people most impacted to create stronger, healthier, more just communities. Our decades of experience in courts and communities, coupled with our field-leading research and practitioner expertise, help us drive justice nationwide in innovative, powerful, and durable ways. For more information on how and where we work, please visit www.innovatingjustice.org. The Center is a 900-employee, $100 million nonprofit that accomplishes its vision through three pillars of work: creating and scaling operating programs to test new ideas and solve problems, performing original research to determine what works (and what doesn't), and providing expert assistance and policy guidance to justice reformers around the world. Operating Programs The Center's operating programs, including the award-winning Red Hook Community Justice Center and Midtown Community Justice Center, test new ideas, solve difficult problems, and attempt to achieve systemic change within the justice system. Our projects include community-based violence prevention programs, alternatives to incarceration, reentry initiatives, and court-based initiatives that reduce the use of unnecessary incarceration and promote positive individual and family change. Through this programming, we have produced tangible results like safer streets, reduced incarceration, and improved neighborhood perceptions of justice. Research The Center's research teams are staffed with social scientists, data analysts, and lawyers who are academically-trained or have lived experience and who conduct research in the U.S. and globally on diverse criminal-legal system and justice issues. Their work includes evaluating programs and policies; conducting exploratory, community-based studies; and providing research translation and strategic planning for system actors. The Center has published studies on topics including court and jail reform, intimate partner violence, restorative justice, gun violence, reentry, sixth amendment rights, and progressive prosecution. The research teams strive to make their work meaningful and actionable to the communities they work with, policymakers, and practitioners. Policy & Expert Assistance The Center provides hands-on, planning and implementation assistance to a wide range of jurisdictions in areas of reform such as problem-solving courts (e.g., community courts, treatment courts, domestic violence courts), tribal justice, reducing incarceration and the use of fines/fees and reducing crime and violence. Our current expert assistance takes many forms, including help with analyzing data, strategic planning and consultation, policy guidance, and hosting site visits to its operating programs in the New York City area. Center Support A dedicated support team within the Center ensures the smooth functioning of operations across various domains, including finance, legal, technology, human resources, fundraising, real estate, and communications. Comprising 15% of the organization's staff, these teams provide essential infrastructure support and innovative solutions aligned with the Center's mission and values. THE OPPORTUNITY The Technology Support and Strategy Department is seeking a Data Engineer to contribute to the development of CJI's data systems that integrate information from diverse platforms and sources to support the organization's extensive data needs. As a Data Engineer, you will be responsible for developing and maintaining data pipelines and infrastructure that extract, clean, transform and send confidential information to staff/partner agencies and ensure data is available to be used by Data analysts, researchers and staff for reporting purposes. In this role, you will also collaborate with members of the Engineering team to build and deploy transformative data products and services that empower data-driven organizational decision-making. Responsibilities include but are not limited to:

• Assist with the development of data systems and warehouse infrastructure that supports the efficient storage, integration and exchange of data from a wide-ranging variety of platforms and data sources;
• Assist with the maintenance of organizational data architecture that supports data utilization and ensures data quality, availability, and reliability for the organization;
• Collaborate on the development and maintenance of configuration management documentation that details the organizational data infrastructure and pipelines;
• Assist with the development of data pipelines and automated integrations between enterprise applications such as case management systems, financial accounting and purchasing systems, HRIS solutions, and other systems;
• Build and implement processes that support the cleaning, transformation and exchange of data between these platforms;
• Assist with the development and deployment of transformational data products and reporting services that empower data-driven decision making;
• Monitor cloud database repositories, data marts, and other resources to ensure resource/service availability and utility;
• Help to modernize and simplify existing data pipelines utilizing a combination of cloud and on-premise data infrastructure solutions;
• Provide support and assistance to data-related projects and initiatives; and
• Assist with other assigned tasks as required by management.

Qualifications: The ideal candidate will have:

• Bachelor's degree in Computer Science, Engineering or a related field is required;
• 3 years of experience as a Data Engineer or similar role is required;
• Experience working with Relational Databases (Oracle and MS SQL Server) is preferred;
• Experience with ETL processes is required;
• Experience with data warehouses is required;
• Experience working with XML, JSON and other data formats is required;
• Familiarity with BI/Visualization tools like Tableau, Power BI, Visokio is a plus;
• Programming experience in Python, SQL, or any programming language is a plus;
• Data integration experience is required (including with Salesforce is a plus);
• AWS/Azure experience is preferred;
• Experience working with Relational Databases (preferably Oracle and MS SQL Server) is required;
• Experience working with version control platforms (i.e. Git/Github) is preferred;
• Knowledge of IDE platforms and Jira is preferred; and
• Looking for a self-starting problem solver with good attention to detail and excellent analytical and communication skills.

Position Type: Full-time. Position Location: Midtown, Manhttan. Compensation: The compensation range for this position is $95,000 - $125,000 and is commensurate with experience. The Center for Justice Innovation offers an excellent benefits package including comprehensive healthcare with a national network, free basic dental coverage, vision insurance, short-term and long-term disability, life insurance, and flexible spending accounts including commuter FSA. We prioritize mental health care for our staff and offer services like Talkspace and Ginger through our healthcare plans. We offer a 403(b) retirement plan with a two-to-one employer contribution up to 5%. The Center for Justice Innovation is an equal opportunity employer. We are committed to fostering an inclusive and diverse workplace, and as such, we do not discriminate on the basis of race, color, religion, gender identity, gender expression, pregnancy, national origin, age, military service eligibility, veteran status, sexual orientation, marital status, disability, or any other category protected by law. We strongly encourage and welcome applications from women, people of color, members of the lesbian, gay, bisexual, and transgender communities, as well as individuals with prior contact with the criminal justice system. Our aim is to create a supportive and respectful environment where every individual, irrespective of their background or identity, feels valued and included. As of February 10, 2023, New York City Executive Order 25 rescinded the requirement of the COVID-19 vaccination for City workers, new hires, and contracted employees. Accordingly, the Center does not require all new hires be vaccinated against the COVID-19 virus; however, the Center recommends all staff, interns, and volunteers stay up-to-date on the vaccination. In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete an employment eligibility verification document form upon hire. Kindly refer to the job posting for the relevant contact information. If the contact details are not provided, we kindly ask that you refrain from making inquiries via phone or email, as only shortlisted candidates will be contacted.