Data Engineer

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%.