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

New Jersey Courts • Trenton, NJ

3d • Hybrid

About The Position

The New Jersey Judiciary is seeking an Information Technology Analyst 3 focused primarily on Data Lakehouse and Data Warehouse quality assurance, including AWS data lake testing and AI operational data store pipeline testing. The role also performs business analysis, data analysis, and first-line production support to ensure the accuracy, integrity, and performance of complex data pipelines, multi-layered storage, and analytical solutions in an AWS environment with ETL processes.

The position designs and executes test plans and automated scripts for data lakehouse architectures, ingestion and transformation layers, and unified AWS storage. It validates ETL pipelines, data warehouse models, reporting KPIs, and AI data solutions, including checking data retrieval, output accuracy, and traceability against authoritative source data before user acceptance testing and production deployment. The analyst manages functional requirements, profiles and validates data, supports analytical pipelines, and works with application, business, engineering, and court-services teams to maintain data quality.

The Judiciary currently offers a hybrid work schedule, and this position may qualify for up to three remote-work days outside Judiciary buildings. Participation requires a multifactor authentication app on a phone or tablet and high-speed home internet. Regular and predictable physical presence at the worksite is an essential function of the position.

The salary range is $94,668.29–$133,073.24 for Schedule A and $94,668.29–$126,419.57 for Schedule B. Newly hired individuals normally start at the minimum of the salary range. The position requires a bachelor’s degree in a related field and three years of qualifying professional experience, subject to the education and experience substitutions described in the posting. Applicants must be authorized to work in the United States. Newly hired employees must complete a background check, including fingerprinting, and generally establish and maintain a principal residence in New Jersey within one year of hire, subject to possible exemptions.

Requirements

• Bachelor’s degree from an accredited college or university in a field related to computer science, information technology, or the area of application, and three years of qualifying professional experience.
• Qualifying experience may include analyzing, designing, programming, troubleshooting, resolving technical problems, testing, defining business requirements, training, or installing computer systems applications; telecommunications or network planning and implementation; system software maintenance; business analysis; business analytics; or data analytics.
• Proven experience in Data Lakehouse or Data Warehouse testing, quality assurance, business analysis, and data analysis.
• Strong understanding of data modeling, ETL processes such as DataStage, and AWS infrastructure.
• Proficiency writing complex SQL queries and validating large-scale data pipelines across databases such as Redshift and DB2 Aurora.
• Ability to manage complex projects and collaborate in a multidisciplinary team environment.
• Regular and predictable physical presence at the worksite.
• Applicants without the required education may substitute additional paraprofessional or professional IT technical experience, or related experience, on a year-for-year basis, with one year of experience equivalent to 30 semester-hour credits.
• A bachelor’s degree in any field plus one year of additional qualifying experience may substitute for the required education.
• An associate degree in a related field plus two years of additional qualifying experience, or an associate degree in any field plus three years of additional qualifying experience, may substitute for the required education.
• A related master’s degree may substitute for the required education or one year of experience.
• Successful internships in specified Judiciary IT, court-services, data analytics, research and statistics, or information security units may substitute for professional experience; one year of intern experience equals six months of professional experience.
• Degrees earned outside the United States must be evaluated by a recognized evaluation service.
• The selected candidate must be authorized to work in the United States under applicable Department of Homeland Security and USCIS regulations.
• Newly hired employees must agree to a thorough background check, including fingerprinting.
• New hires generally must establish and maintain a principal residence in New Jersey within one year, subject to hardship or employer-critical-need exemptions.

Responsibilities

• Design, develop, and execute test plans, test scenarios, and automated scripts for data lakehouse architectures, data ingestion and transformation layers, and unified AWS storage.
• Validate enterprise ETL pipelines, data warehouse models, and reporting KPIs in collaboration with data analysts and engineering teams; help resolve release bottlenecks.
• Conduct end-to-end testing of AI data solutions, verifying data retrieval, output accuracy, and traceability to authoritative source data before user acceptance testing and production deployment.
• Oversee and manage Functional Requirement Documents for data modelers and ETL/lakehouse developers, ensuring technical solutions align with business objectives.
• Collaborate with application-team and business subject-matter experts to translate data requirements.
• Profile data in legacy systems and validate data to support seamless integration across the business environment.
• Provide first-line production support to maintain the stability and reliability of analytical pipelines through clear communication.
• Work with the Automated Trial Court Services Unit and application development teams to establish and maintain rigorous data quality procedures.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level