FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Database Analyst 2
NOVALINK SOLUTIONS LLC. Provide technical support for statewide judicial applications, database systems, data integrations, and reporting initiatives .
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in SQL and relational database systems, with a strong focus on data extraction, transformation, and validation. Proficient in developing and optimizing complex SQL queries and supporting data migration and integration efforts within judicial applications.
Highest-signal resume keywords
SQL ServerT-SQLData MigrationData ValidationPower BI
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
SQLRelational Database SystemsData ExtractionData TransformationData ReconciliationStored ProceduresQuery OptimizationData MappingData QualityDatabase Security
Soft Skills
Clear CommunicationIndependent WorkCollaborationPriority Management
Tools & Technologies
Microsoft SQL ServerSQL Server Integration Services (SSIS)Power BIReporting Tools
Industry Keywords
Judicial SystemsCriminal JusticeGovernment Information SystemsData Governance
Tech Stack
Tools & technologiesMS SQL ServerSQLSSIS
About the role
Key responsibilities & impact- Provide technical support for statewide judicial applications, database systems, data integrations, and reporting initiatives
- Analyze, extract, validate, and troubleshoot data across multiple systems
- Support system modernization, including data migration, integration testing, and reporting for the statewide case management system
- Develop, maintain, and optimize complex SQL queries, stored procedures, views, and scripts
- Analyze relational database structures and relationships among tables and data elements
- Extract, transform, and validate data; troubleshoot discrepancies and database-related application issues
- Assist with database documentation, data mapping, and technical specifications
- Support data conversion and migration between legacy and modernized case management systems
- Identify, correct, and validate data discrepancies before and after migration
- Reconcile converted data and investigate data exchanged through external interfaces
- Coordinate with application analysts, vendors, and technical teams to resolve data-related defects
- Develop SQL queries and datasets for operational reports and business intelligence
- Prepare data for Power BI and other reporting tools and validate results against source systems
- Translate stakeholder reporting requirements into accurate data outputs
- Investigate database-related issues affecting application functionality and data accuracy
- Document queries, data structures, troubleshooting procedures, and solutions
- Recommend data-quality and performance improvements while following information security, privacy, and access-control requirements
Requirements
What you’ll need- Three or more years of professional experience with SQL and relational database systems
- Strong proficiency in Microsoft SQL Server and T-SQL, including complex joins, stored procedures, views, and data manipulation scripts
- Experience with large datasets, data extraction, transformation, validation, and reconciliation
- Understanding of relational database design, indexing, and query optimization
- Ability to interpret technical documentation and translate business requirements into SQL solutions
- Ability to communicate findings clearly
- Ability to work independently, manage competing priorities, and collaborate with technical and nontechnical stakeholders
- Preferred: Experience with enterprise case management systems or large transactional applications
- Preferred: Data migration or legacy system modernization experience
- Preferred: Experience with SQL Server Integration Services (SSIS), Power BI, data warehousing, or reporting solutions
- Preferred: Experience troubleshooting application integrations and data interfaces and working with software vendors
- Preferred: Familiarity with judicial, criminal justice, or government information systems and handling sensitive data
- Preferred: Knowledge of data governance, data quality, and database security best practices
Benefits
Comp & perks- Remote position
- Remote/hybrid options to be determined
- Contract duration currently through June 30, 2027