Short Description:
Senior Business Analyst with specific government application experience.
Complete Description:
The SRIB (securities and regulated industries bureau) of the Iowa Insurance Division (IID) is seeking a business consultant to create technical specifications for a new ACCESS database for the SRIB. This will include designing new functionality for e–filing, data analysis and reports. After obtaining necessary internal approvals, the SRIB will then hire a software programmer to build the system. The business consultant will act as the IID’s project manager and monitor the work of the programmer.
The Regulated Industries Unit (the RIU) regulates (among other things): funeral homes that operate perpetual care cemeteries; the agents that sell contracts for perpetual care on behalf of the funeral homes; and the sellers of pre-need funeral contracts (collectively, “pre-need services”). The RIU has a process for issuance and renewal of licenses for the entities. The RIU requires the entities to file certain annual reports. Insurance companies and financial institutions also submit annual reports to the RIU regarding the activities of the entities. RIU staff compare the reports as part of the IID’s review of the operations of the entities. This is currently a manual process. The RIU conducts audits of the entities and wants to attach audit reports and related correspondence to the licensing record.
The RIU has several other license types it administers and the new system must also accommodate those other licenses.
Skills:
Skill
Required / Desired
Amount
of Experience
Ability to gather business requirements
Required
8
Years
Ability to work with a developer to translate business requirements into technical specs
Required
8
Years
Ability to map out process flows, identifying various inputs and needed reports
Required
8
Years
Experience with Access 2007
Required
5
Years
Experience with Access 2013
Highly desired
Experience with E-filing applications and e-payment
Required
5
Years
Designing functionality for routine accounting and monitoring reports
Required
5
Years
Flexibility in system design generation of special reports
Required
5
Years
Government data security protocols for internet transactions
Required
5
Years
Experience migrating data to Access Database
Highly desired
5
Years