Data Analyst

Job Title: Data Analyst Location-Type: Remote (flexible to timezones, preferably not PST) Start Date Is: ASAP Duration: Permanent Compensation Range: $70,000–$95,000 annually

Job Description: Support data migration, validation, and analysis efforts for the client's justice software implementation projects while helping ensure accurate, reliable outcomes for customer data conversions.

Day-to-Day Responsibilities

• Gather, clean, validate, and analyze data from multiple sources
• Modify, convert, and load data using SQL, Excel, and internal tools
• Identify data issues, root causes, and downstream workflow impacts
• Create dashboards, reports, and summaries to communicate findings
• Write Jira tickets to document defects and required development work
• Partner with implementation, support, and account management teams to resolve customer data issues
• Make recommendations to software engineering teams for long-term data fixes
• Support customer-facing conversations related to data issues as needed
• Contribute to continuous improvement of data quality and migration processes

Requirements

• Must-Haves:
• Strong SQL skills, including writing queries and scripts
• Experience working with relational database/table structures
• Ability to investigate messy customer data, identify root issues, and resolve them
• Prior data migration and software implementation experience
• Experience with justice software implementation, including court, attorney, and jury case management systems
• Advanced Excel skills, including pivot tables, VLOOKUPs, and macros
• Experience with data validation, cleansing, and maintaining data integrity
• Strong written and verbal communication skills
• Customer-facing experience and ability to handle challenging situations professionally
• Ability to work independently in a remote environment
• USC or Green Card work authorization
• Nice-to-Haves:
• Java experience
• T-SQL or MySQL experience
• PowerShell or similar scripting experience
• Knowledge of court or case management systems beyond core implementation work