Title: Business Intelligence Developer (Oracle BI Publisher) #00971

Hiring Range: $75,000 - $99,750 plus $5,000 sign-on bonus for new to state service with tenure agreement

Pay Band: 5

Agency: Agriculture & Consumer Svcs

Location: VDACS CENTRAL HEADQUARTERS

Agency Website: https://www.vdacs.virginia.gov/

Recruitment Type: General Public - G

Job Duties

Business Intelligence Developer (Oracle BI Publisher) #00971
(Information Technology Specialist II, Pay Band 5)

The Virginia Department of Agriculture and Consumer Services is seeking an experienced Business Intelligence Developer to support the ongoing development and deployment of data reporting and analysis solutions. The successful candidate will provide the production and support of business data, analyses, and reports using Oracle BI Publisher. Candidate will conduct data analysis of complex agency business data to document user requirements and design functional data structures, data extraction transform and load processes, dashboards, and reports. Reports will be designed to support data usage, decision making, and business processes. Candidate will research off-the-shelf reporting and data analysis applications and make recommendations for architectural changes. Successful candidate will design, develop, implement, and maintain data marts, data interaction solutions, and report solutions to satisfy the business needs. Candidate will also train users in the usage of the data interaction and reporting tools. Once onboarded, this position may be eligible for telework opportunities; availability, hours, and duration of telework shall be approved as outlined in the Commonwealth’s telework policy.

Minimum Qualifications

QUALIFICATIONS: Proficiency in utilizing Oracle BI Publisher to create reports is essential, as well as a comprehensive understanding of relational databases, data analysis, data security, and project management methods. Familiarity with working in an agile development setting, specifically with Scrum methodology, is also required. Advanced skills using modern data warehousing techniques to develop and populate data marts, reporting structures, and application interfaces using Oracle PL/SQL and other data integration tools such as Oracle Data Integrator (ODI), SQL Server Integration Services (SSIS), or similar tools. Ability to analyze, design, implement, and maintain IT database structures. Ability to communicate effectively both verbally and in writing; and to organize, monitor and prioritize work and projects. Demonstrated ability to work in a team environment and individually, provide exceptional customer service. H.S. Diploma/GED required.

Preferred Qualifications:

Graduate of college or university with major studies in computer science, information technology, or other related degree is preferred along with considerable IT experience comprising of progressively responsible positions. Experience in report development using Oracle BI Publisher. Substantial experience in developing data-driven reports to meet a variety of business needs. Experience developing data marts, data warehouses, or reporting databases. An equivalent combination of training and experience indicating possession of the preceding knowledge, skills and abilities may substitute for this education and experience. An equivalent combination of training and experience indicating possession of the preceding knowledge, skills and abilities may substitute for this education and experience.

Hiring Salary Range: $75,000 - $99,750 annually. $5,000 Sign-On Bonus for those new to state service is being offered to the selected candidate. A one-year tenure agreement will be required for sign-on bonus. Excellent State Benefits.

Special Instructions:

You will be provided a confirmation of receipt when your application and/or résumé is submitted successfully. Please refer to “Your Application” in your account to check the status of your application for this position.

Final candidate must successfully complete a fingerprint-based criminal background check.

If you have been affected by DHRM Policy 1.30 Layoff, and possess a valid Interagency Placement Screening Form (Yellow Card) or a Preferential Hiring Form (Blue Card), you must submit the card before the closing date for this position. The Card may be submitted with the state application as an attachment.

Contact Information:

Name: Human Resources

Phone: 804-371-8577

Email: hr.vdacs@vdacs.virginia.gov

In support of the Commonwealth’s commitment to inclusion, we are encouraging individuals with disabilities to apply through the Commonwealth Alternative Hiring Process. To be considered for this opportunity, applicants will need to provide their Certificate of Disability (COD) provided by a Vocational Rehabilitation Counselor within the Department for Aging & Rehabilitative Services (DARS), or the Department for the Blind & Vision Impaired (DBVI). Veterans are encouraged to answer Veteran status questions and submit their disability documentation, if applicable, to DARS/DBVI to get their Certificate of Disability. If you need to get a Certificate of Disability, use this link: Career Pathways for Individuals with Disabilities, or call DARS at 800-552-5019, or DBVI at 800-622-2155.