Legislative Research Analyst
Listed on 2026-06-23
-
IT/Tech
Data Analyst, Database Administrator, Data Engineering
Category: BUREAU OF LEGISLATIVE RESEARCH
Anticipated Starting Salary: $58,700-$115,632
POSITION: Legislative Research Analyst, Policy Analysis and Research Section
GRADE: SPC
01
SUMMARY OF POSITION: The Legislative Research Analyst is a mid-level position that works under direct supervision of the Policy Analysis and Research Administrator and is responsible for providing accurate and clear policy research and analysis for members of the General Assembly and legislative committees.
Job Classification and Salary Commensurate Upon Experience and Education. The grade range is SPC
01-SPC
04, and the salary range is $58,700-$115,632.
This position is responsible for the modeling, management, and analysis of education finance data used for the Educational Adequacy Study and various ad hoc reports. This role involves the full life‑cycle management of expenditure and statistical data for over 250 school districts and 1000+ schools, utilizing specialized business intelligence and database tools. The position demands strong analytical skills and a deep understanding of data collection and preparation processes.
The ideal candidate is curious, data driven, with a strong orientation for problem‑solving.
- Data Management and ETL
- Load expenditure data and statistical/demographic data from the ARKANSAS PUBLIC SCHOOL COMPUTER NETWORK (APSCN) State Data Warehouse into the BLR SQL Server database.
- Load data from other external sources as required.
- Utilize Microsoft SQL Server Integration Services (SSIS) / Visual Studio Designer to perform ETL tasks, including establishing data flows between input files (typically comma‑separated delimited files) and database tables.
- Execute SQL statements for data updates and computations within the Visual Studio environment.
- Business Intelligence and Reporting
- Serve as the primary user of the COGNOS suite of software.
- Develop data models using IBM COGNOS FRAMEWORK MANAGER, create database and/or other views, and publish packages for use in other COGNOS tools.
- Design, build, and publish dimensional data structures (CUBES) for analytical and reporting purposes using IBM COGNOS TRANSFORMER SERVICES, incorporating various demographic dimensions.
- Ensure access to structured, modeled, and high‑quality data.
- Support reporting requests of Legislative members and Bureau staff.
- Utilize Excel and other data tools to prepare and communicate data.
- Documentation and Process Management
- Document analytical processes, data sources, and report logic to ensure transparency and reproducibility.
- Collaborate with IT staff and vendors regarding software installation, deployment, operation, maintenance, and backup of the database and dedicated server.
- Monitor changes to coding and reporting requirements.
- Stay current with industry trends and best practices in development and reporting, proactively implementing improvements to enhance operational efficiency.
- Experience demonstrated through application of knowledge, skills, abilities, and technologies towards work products required (i.e., data collection, data loading, data transformation, querying, report development, statistical stratification/grouping).
- Experience with data management, including collecting, cleaning, and preparing data for analysis is required.
- Experience organizing large volumes of current and historical data for efficient querying, analysis and reporting.
- Experience with IBM COGNOS ANALYTICS or equivalent program for reporting and administration.
- Experience with Microsoft SQL Server Management Studio and SQL sufficient to create, update and maintain database tables and execute queries and procedures.
- Proficiency with Microsoft SQL Server Integration Services (SSIS) / Visual Studio sufficient for ETL package creation and maintenance.
- Strong working knowledge of IBM COGNOS FRAMEWORK MANAGER or equivalent software for data modeling and package publication.
- Strong working knowledge of IBM COGNOS TRANSFORMER SERVICES or equivalent software for creating dimensional data cubes.
- Ability to create and execute SQL stored procedures.
- Demonstrated ability to perform detailed demographic and financial…
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).