SQL Report Writer/Developer

SQL Report Writer/Developer

Posted: 4/23/2021

Join our team of professionals seeking to improve the experience of justice involved individuals in the NYC Courts!

ABOUT CJA

The New York City Criminal Justice Agency (CJA) is a not-for-profit service and research organization that operates in partnership with the New York City Mayor’s Office of Criminal Justice. CJA is the City’s main pretrial services agency, combining operations, pilot projects, and research under one roof. CJA utilizes procedural justice practices to provide pretrial services to over 200,000 persons arrested annually in New York City. Information collected about these arrestees and subsequent case processing is maintained in the agency’s internal and externally shared database systems, which are used to conduct descriptive and evaluation research on arrestee characteristics, case processing and court outcomes, and on issues and potential reforms to criminal justice policy in New York City. CJA’s programs operate in the criminal courts and detention facilities 24 hours a day seven days a week within the 5 boroughs of NYC, employing over 250 employees, citywide.

­­­­­­­­­­­­­­CJA VALUES

Each employee at CJA is guided by these values in our work:

• Commitment: We are committed to being active partners in criminal justice reform through initiatives and creative problem-solving that evaluates different methods and strategies for alternatives to detention.
• Fairness: We are guided by fairness and the presumption of innocence for those who are detained and work with integrity and without bias to protect the privacy and interest of court-involved people and their families.
• Innovation: We value curiosity as a driving force to lead the way in pretrial services. We use innovative techniques in research, pilot programs, and engaging justice-involved communities to execute our mission of reducing unnecessary pretrial detention.

PROGRAM SUMMARY

We are creating a team of IT professionals with curiosity to learn, strong focus on customer needs and an ability to address current business requirements with an eye toward future possibilities. The SQL Report Writer is responsible for leveraging your skills to provide timely and accurate reports and data to the various business functions throughout the Agency. This position is currently remote, but eventually will be based in our main office in Manhattan, NYC.

PRIMARY RESPONSIBILITIES

IT Skills

• Design build, and maintain reports
• Maintain Authorization and access to reports.
• Help track and discover issues with data quality.
• Ability write report clean well formatted SQL for reports and adhoc queries.
• Understand agile software development and identify ways to improve our design and development processes
• Effectively analyze source code to validate business and technical requirements and support application improvements
• Contribute to implementation efforts (UAT, environment setup, and end user support)

Collaboration and Innovation

• Support production applications through proactive troubleshooting and timely resolution of issues
• Review business requirements and propose technology solutions
• Communicate and partners with business owners to develop reporting specifications
• Appropriately prioritize work and provide status updates to ensure that work completes according to schedule and meets customer expectations
• Adhere to best practices & standards, as well as security and data protection measures

REQUIRED QUALIFICATIONS

• Minimum 1 years’ experience using PowerBI, and SQL Server Management Studio (SSMS)
• Working knowledge of SQL query programming and stored procedures required
• Familiarity with SSMS and SQL Profiler
• Understanding visual report design, to ensure reports are clear and easy to consume
• Experience using code versioning tools such as Git and GitHub
• Experience with SQL Server Integration Services (SSIS)
• Bachelors in a technology related discipline or equivalent experience.
• Excellent team player with a keen desire to learn
• Strong problem solving, design, programming, and testing skills as well as a desire to learn new languages and technology
• Excellent written communication skills and the ability to translate business requirements into clear technical specifications.
• Able to participate in an on-call rotation
• Desire to learn more about data presentation and data warehousing.

SALARY: $55,000 - $95,000, dependent upon experience

BENEFITS: CJA offers a very generous benefit plan including health, dental and vision insurance, a comprehensive mental health and wellness (EAP) plan, four weeks’ vacation, paid holidays and a retirement plan with employer matching contributions. CJA is also strongly committed to professional learning and development for its staff members and offers staff varied opportunities for learning and development through partnerships and vendor services for web based, in-person professional development training, as well as in-house job training and development.

Note: Due to the nationwide pandemic CJA has implemented remote working for most staff until March 2021. While it is uncertain where NYC will be with respect to resuming direct client work at the time of hire, the successful hire must be willing to assume responsibilities that are both remote and on-site; this includes access to your own personal computer, laptop or tablet, and internet, until company devices can be issued.

Only those candidates being considered will be contacted.

The New York City Criminal Justice Agency is an Equal Opportunity Employer

CJA is committed to creating a diverse work environment and is proud to be an equal opportunity employer. We do not discriminate on the basis of race, color, national origin, sex, gender identity, religion, sexual orientation, age, disability, parental status, veteran status, or any other protected status under applicable laws. We encourage individuals of all backgrounds to apply.