Information Systems Specialist 7 – Business Intelligence Developer
| Company | Oregon State Government |
|---|---|
| Location | Salem, OR, USA |
| Salary | $6679 – $10092 |
| Type | Full-Time |
| Degrees | Bachelor’s, Master’s, Associate’s |
| Experience Level | Mid Level, Senior |
Requirements
- Six (6) years of information systems experience with PowerBI and reporting/analytical tools such as SAP BusinessObjects suite, Cognos, SSRS.
- OR An Associate’s degree in Computer Science, Information Technology, or related field, OR completion of a two (2) year accredited vocational training program in information technology or related field; AND four (4) years of information systems experience with PowerBI and reporting/analytical tools such as SAP BusinessObjects suite, Cognos, SSRS.
- OR A Bachelor’s degree in Information Technology, Computer Science, or related field AND two (2) years of information systems experience with PowerBI and reporting/analytical tools such as SAP BusinessObjects suite, Cognos, SSRS.
- OR Master’s degree in Information Technology, Computer Science, or related field may substitute for all of the above.
- Good verbal and written skills, and the ability to effectively communicate difficult technical automation concepts to end-users and managers who may have little or no automation experience.
- Knowledge of databases and automated systems, including PC-based and server-based systems and networks.
- Ability to comprehend complex details of OYA’s automated systems, JJIS, and Windows server operations.
- Experience using SQL, Oracle, SQL Server DBMS, structured programming techniques, SAP business intelligence and analytical tools, data transformation software and techniques, and data warehousing techniques and theories.
Responsibilities
- Designing, implementing, and maintaining inclusive reporting systems that promote data mining, research, program evaluation, and information dissemination.
- Collaborating with managers, information systems staff, researchers, and planners from various departments to ensure optimal reporting methods for the Juvenile Justice Information System (JJIS) Reporting database and OYA’s data warehouse.
- Analysis, planning and coordination, design, development, and maintenance of the JJIS reporting system and the Department’s data warehouse reporting system.
- Providing valuable technical assistance to Business Intelligence users.
Preferred Qualifications
- Extensive experience developing and maintain complex reports and dashboards (preferably PowerBI, Crystal Reports, Web Intelligence)
- Demonstrated ability to write complex SQL statements using T-SQL or Oracle SQL
- Experience using SAP BusinessObjects and Information Design Tool and/or other analytical tools
- Experience using quality assurance best practices and data analytic techniques to troubleshoot, identify data integrity issues, and analyze data
- Experience gathering and creating requirements; prioritizing tasks and maintaining technical documentation