Data Production Analyst (QA) (Information Technology Analyst 3)

New Jersey Courts; Trenton (NJ); Hybrid; USD 95,000 - 133,000; Full time

Benefits offered by this job

Remote work option

Job summary

New Jersey Judiciary is seeking an IT Analyst (ITA3) with a focus on Data Lakehouse and AWS-based testing. The role also drives business analysis, data analysis, and first-line production support to ensure data pipeline integrity and performance.

Hybrid work option with potential remote days; requires a bachelor’s degree in a related field and several years of IT experience. Strong collaboration with engineering and application teams is essential.

Qualifications

• Bachelor’s degree in a computer science, information technology or related field and three years of professional IT experience.
• Experience with data lakehouse architectures and data warehouse testing.
• Proficiency in SQL and validating large-scale data pipelines.

Responsibilities

• Design, develop, and execute test plans, scenarios, and automated scripts for data lakehouse, ETL, and DW testing.
• Perform end-to-end testing for AI data solutions and verify data accuracy and traceability.
• Oversee FRDs to guide data modelers and ETL/lakehouse developers.
• Perform data profiling and validation for legacy data systems and ensure data integration quality.
• Provide first-line production support to maintain pipeline stability.
• Collaborate with cross-functional teams to ensure data quality procedures.

Skills

Data Lakehouse testing

QA testing

Business Analysis

Data Analysis

SQL

AWS

Data Warehouse testing

Education

Bachelor’s degree in CS/IT or related field

Tools

AWS

DataStage

Redshift

DB2 Aurora

Job description

If another position becomes available within five months of this recruitment’s closing date, the applicant pool from this posting may be used to fill additional vacancies.

When you come to work for New Jersey Judiciary you will join an 8500-member strong TEAM that operates with the highest standards of independence, integrity, fairness and quality service. You will be engaged with work that has purpose, meaning and makes a difference in lives of the public we serve. We work hard every day to build the public’s trust and confidence in our court system, which includes issues such as bail reform, marijuana decriminalization and recovery court. Whether it be in a courtroom, an administrative office, a courthouse training room, an IT office or in the field, our Judiciary workforce is improving the lives of countless individuals and families every day. We honor the dignity and individualism of each member of our organization while fostering professionalism and continuous improvement in our work.

SALARY:

The salary range for this position is $94,668.29 to $133,073.24 for Schedule A, and $94,668.29 to $126,419.57 for Schedule B. For newly hired individuals, the starting salary will normally be at the minimum of the salary range. For current Judiciary employees, salary upon promotion or advancement will be an increase of 5% of base salary, not to exceed the maximum of the range, or the minimum salary of the band/level, whichever is greater. Judiciary employees hired prior to June 3, 2014, are considered Schedule A. Newly hired individuals, and Judiciary employees hired on or after June 3, 2014, are considered Schedule B.

The Judiciary offers a strong opportunity for growth.

The NJ Courts is seeking a dynamic Information Technology Analysts (ITA3) with a primary focus on Data Lakehouse (AWS data lake, Data Warehouse testing and AI ODS Pipeline Testing), while also actively driving Business Analysis (BA), Data Analysis (DA), and First-Line Production Support. This role ensures the accuracy, integrity, and performance of complex data pipelines, multi-layered storage, and analytical solutions within the AWS infrastructure with ETL Processes.

REMOTE WORK:

The Judiciary currently offers a hybrid work schedule, and this position may qualify for up to 3 days of remote work outside of Judiciary buildings. To participate in this program, in addition to installing a multifactor authentication app on your phone or tablet, you will be required to have high speed home internet access.

• Data Product Analytics and AI data Pipeline Testing & Quality Assurance (Primary Focus): Design, develop, and execute comprehensive test plans, scenarios, and automated scripts specifically tailored for modern data Lakehouse architectures, data ingestion, transformation layers, and unified storage across AWS. Validates enterprise ETL pipelines, Data Warehouse models, and reporting KPIs alongside Data Analysts, collaborating with Engineering teams to resolve release bottlenecks.
• AI Data Solution and DW Testing: Conducts end-to-end testing for emerging AI solutions, verifying data retrieval, output accuracy, and traceability against authoritative source data prior to UAT and Production deployment.
• Business Analysis (BA): Oversee and manage the creation of Functional Requirement Documents (FRDs) to guide data modelers and ETL/Lakehouse developers, ensuring technical solutions align with business objectives. Collaborated with Application team SMEs, Business SMEs on translating the Data Requirement.
• Data Analysis (DA): Perform data profiling on Legacy data systems and ongoing and perform validation for seamless data integration across the business environment.
• First-Line Production Support: Maintain the stability and reliability of the analytical pipeline by serving as the first line of production support through clear communication.
• Cross-Functional Collaboration: Work closely with the Automated Trial Court Services Unit and application development teams to establish and maintain rigorous data quality procedures.

Qualifications & Requirements

• Proven experience in Data Lakehouse/Data Warehouse testing, Quality Assurance, Business Analysis, and data analysis.
• Strong understanding of data modeling, ETL like DataStage processes, and AWS infrastructure.
• Proficiency in writing complex SQL queries and validating large-scale data pipelines across databases like Redshift and DB2 Aurora.
• Demonstrated ability to manage complex projects and collaborate within a multidisciplinary team environment

Regular and predictable physical presence at the worksite is an essential function of this position.

Graduation from an accredited college or university with a bachelor’s degree in a field related to computer science, information technology or the area to which the applicant is applying, such as information systems, human-computer interaction, interactive media, software engineering, computer networking, business analytics, data analytics and/or cybersecurity and three years of professional experience in: analyzing, designing, programming, troubleshooting, resolving technical problems, testing, defining business requirements, training and/or installing computer systems applications OR planning, acquiring, installing and implementing telecommunications facilities and services, wide area networks, or local area networks OR generating and maintaining system software ORbusiness analysis which may include defining and gathering business and functional requirements, analyzing and validating data and/or documenting test plans OR business analyticsOR data analytics.

Substitution:

Applicants who do not possess the required education may substitute additional paraprofessional and/or professional IT technical experience or experience related to the area to which the applicant is applying on a year for year basis with one year of such experience being equal to 30 semester hour credits.

A bachelor’s degree in any field from an accredited college or university and one year of additional paraprofessional and/or professional IT technical experience or experience related to the area to which the applicant is applying may be substituted for the required education.

An associate degree from an accredited college or university, in a field related to computer science, information technology or the area to which the applicant is applying, such as information systems, human-computer interaction, interactive media, software engineering, computer networking, business analytics, data analytics and/or cybersecurity and two years of additional paraprofessional and/or professional IT technical experience or experience related to the area to which the applicant is applying may be substituted for the required education.

An associate degree in any field from an accredited college or university and three years of additional paraprofessional and/or professional IT technical experience or experience related to the area to which the applicant is applying may be substituted for the required education.

A master’s degree from an accredited college or university in a field related to computer science, information technology or the area to which the applicant is applying, such as information systems, human-computer interaction, interactive media, software engineering, computer networking, business analytics, data analytics and/or cybersecurity may be substituted for the required education OR one year of experience.

Individuals who have successfully completed internships within the Central Office Information Technology Office; ATCSU; Data Analytics, Research and Statistics Office; and/or the Information Security Unit may substitute their experience as interns for the required professional experience with one such year of intern experience being equivalent to six months of professional experience.

Education Note:Degrees conferred outside of the United States must be evaluated by a recognized evaluation service. (See https://naces.org/members/)

Physical Ability:

For some positions, applicants must have the ability to perform work which requires climbing and prolonged standing, stretching, bending and reaching. The selected candidate must be able to frequently lift and carry supplies weighing from 30 to 50 pounds and, occasionally, materials weighing up to 75 pounds.

Driver's License:

Appointees will be required to possess a driver’s license valid in New Jersey only if the operation of a vehicle, rather than employee mobility, is necessary to perform essential duties of the position.

Authorization to Work:

US citizenship is not required. Selected candidate must be authorized to work in the US according to Department of Homeland Security, US Citizenship and Immigration Services regulations.

Special Note:

Newly hired employees must agree to a thorough background check that will include fingerprinting. All data received will be kept in strict confidence except to inform the individual of the findings and what action will be taken as a result of this information.

Residency Law:

In accordance with N.J.S.A. 52:14-7 (L. 2011, Chapter 70), the "New Jersey First Act," all persons newly hired by the Judiciary within one year must establish, and then maintain, principal residence in the State of New Jersey. Any person may request an exemption from that requirement from the Employee Residency Review Committee in the Department of Labor & Workforce Development on the basis of either hardship or employer critical need.

Equal Opportunity

The Judiciary of New Jersey is an Equal Opportunity/Affirmative Action Employer Committed to Ensuring an Open Door to Justice.

NeoGovapplicant supportat 1-877-204-4442 (toll free call)

Monday through Friday, 6:00 AM to 6:00 PM Mountain Time (MT)