Data Analyst – Integrity Data Hub Job Position
Background on NASWA
The National Association of State Workforce Agencies (NASWA) is the national organization representing all 50 state workforce agencies, D.C. and U.S. territories. These agencies deliver training, employment, career, and business services, in addition to administering the unemployment insurance (UI), veteran reemployment, and labor market information programs. NASWA provides policy expertise, shares promising state practices, and promotes state innovation and leadership in workforce development.
One of the projects managed by the NASWA UI Integrity Center is the operation and continued development of the UI Integrity Data Hub (IDH). The IDH allows participating states to submit UI claims data for cross-matching, alerting, and analysis. The IDH project team is seeking a Data Analyst to provide support for the development of ongoing reporting functions and analysis of UI claims data. This role is expected perform analysis of UI claims data and other related data, development of reports and dashboards, and project KPIs. The role will also work with the project team and stakeholders to address data quality issues and communicate anomalies indicating potential UI fraud.
Background on CESER
The Center for Employment Security Education and Research (CESER) is the leading education, research and information technology center focused on workforce development and unemployment insurance issues offering services to a diverse group of stakeholders, most notably state workforce agencies and their federal partners.
Overview of Position
The Data Analyst will work alongside the IDH Project Manager to provide data related support, data analysis, research, data management, and data reporting along with developing KPI metrics. The Data Analyst role will troubleshoot and investigate data anomalies and issues along with working directly with the data engineers to resolve any issues. The Data Analyst will support NASWA software developers, solution architects, and data/program analysts on data analysis and reporting initiatives. The Data Analyst will also work closely with State UI representatives to review data analysis results and resolve data quality issues.
Roles and Responsibilities
- Work independently and with team members to understand database structure and IDH business processes.
- Perform extensive ad-hoc analysis, data validation, and quality assurance within large datasets using SQL tools.
- Organize and lead meetings with business and operational data owners.
- Coordinate and communicate between business users and the IDH project team, balancing requirements and resources to solve business problems.
- Design and development of tabular and/or visualization reports, dashboards for key project KPIs, data quality, and identification of potential fraud.
- Understand stakeholder data quality while recommending data validation automation strategies to pro-actively catch data integrity issues.
- Identify opportunities to improve data and business processes utilizing Python or R.
- Strong ability to proactively track, troubleshoot, and resolve data issues with State UI representatives.
Required Competencies
- Bachelor’s degree from an accredited institution.
- 5 years of experience in an analytical role with a heavy focus on querying data, analyzing and clearly presenting analyses to stakeholders across the organization.
- 3-5 years of experience in developing complex SQL queries.
- Experience designing reports and dashboards in Tableau, or equivalent BI product.
- Ability to clearly explain findings from complex analyses in case studies and presentations.
- Previous experience on a data team in an agile environment.
- Strong presentation and communication skills.
- Experience supporting and working with cross-functional teams in a dynamic environment.
- Candidates must have a consistently respectful and professional demeanor toward colleagues, members of the Association, visitors, guests, callers, stakeholders, and vendors. They also must have the ability to develop collaborative partnerships with Project Managers, IT professionals, and stakeholders.
- Candidates must have effective time and task management skills, paying close attention to detail and keeping errors to a minimum. They must be punctual, reliable, responsible, composed, honest, ethical, tolerant of differences, and flexible.
- Candidate must also be comfortable working on a virtual team.
Desired Competencies
- Experience with BI tools such as Tableau, Looker, or equivalent.
- Experience working with databases such as MySQL, PostgreSQL, AWS Redshift, or equivalent.
- Experience in the fraud or investigative domain utilizing detection techniques such as link analysis or visualization of graph databases.
- Ability to translate between technical metrics and business KPIs and act as a bridge between technical and non-technical internal stakeholders.
- Experience with R or Python is highly desirable.
Relevant Experience Required
- 5+ years of data analysis and reporting.
- Excellent client-facing and internal communication skills.
- Excellent written and verbal communication skills.
- Solid organizational skills including attention to detail and multi-tasking skills.
- Strong working knowledge of Microsoft Office.
Education
Bachelor’s degree in Computer Science, Statistics, Informatics, Information Systems or another quantitative field required. Data analysis certifications.
Job Details
Location: The position is a remote/telework position within the United States
Title: Data Analyst – Integrity Data Hub
Report To: Data Analyst Lead
Term: Full Time
Salary Range: $75,000 - $90,000K per year commensurate on skills, experience
Benefits: NASWA offers competitive benefits including a great health care package, 401(k), educational assistance, generous time off, and other options.
Travel Requirements: There is no travel at this time due to the pandemic. Once it is deemed safe to travel, quarterly travel (approximately 10%) around the United States (and possibly US territories) for working sessions.
