Title: CO - P4592 - Business Intelligence/Data Integration Specialist

State Role Title: Information Technology Specialist II

Hiring Range: $55,000 - $100,000

Pay Band: 5

Agency: Dept of Environmental Quality

Location:Central Office

Agency Website:www.deq.virginia.gov

Recruitment Type: General Public - G

Job Duties

The Virginia Department of Environmental Quality is seeking a detail-oriented self-starter to serve as a data analyst/integration specialist to assist the agency in maximizing the value of its data in accomplishing our mission. The primary role for this position will be to assist in establishing and maintaining a data quality program focused on data that we share with external entities, such as the U.S. Environmental Protection Agency and other entities. This person will identify issues and implement fixes as necessary to ensure data deliverables are met. This individual will also assist in developing data models and objects needed to support the agency's business functions.

Minimum Qualifications

•Knowledge of System Development Life Cycle and Systems Analysis Methods and Techniques;
•Knowledge of analysis, design and development for both near real time system integrations and data warehouses and architecture and reporting tools: SQL Server, MDS, SSIS, SSRS, DTS, Analysis Services, Tableau, Business R, Python, SAS or others;
•Knowledge of data warehousing, analytic technology, management of large data repositories and relational databases;
•Skills in developing, tuning, and maintaining PL/SQL and T-SQL for both SQL Server and Oracle databases, with an emphasis on ETL logic, staging database structures, exception handling, mass data loading for both relational as well as multidimensional design;
•Ability to communicate effectively orally and in writing in English with developers, data base administrators, information security, business analysts, project managers and with different business users; and,
•Ability to work effectively independently and as a member of a team.

Additional Considerations

None

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.

Please Read Carefully:

The Commonwealth of Virginia welcomes all applicants authorized to work in the United States. Sponsorship is not provided; therefore, applicants must be a citizen or national of the U.S., a Lawful Permanent Resident, or an alien authorized to work.

Excluding current DEQ Employees, selected candidates for employment MUST pass a criminal background check. A valid driver's license is required of all DEQ employees in order to operate a state-owned or leased vehicle.

The Application Process: Individuals desiring to be considered for this position must submit a completed employment application or you may attach a resume before the position's closing date. Applications received after the closing date will not be considered. Applicants are encouraged to be specific regarding job-related knowledge, skills, and abilities. Applications submitted via postal mail, email, or fax will not be considered.

DEQ Values Veterans: DEQ is a proud member of the Commonwealth of Virginia Values Veterans (V3) Program, authorized under the Code of Virginia (§2.2-2001.2). We are committed to recruiting, hiring, and retaining qualified Veterans and their spouses. Veterans who are hired into state positions may be eligible for additional leave accruals based on their total years of service in the military, National Guard or Reserve. For more information please visit: https://www.dhrm.virginia.gov/employeebenefits

Our Commitment: DEQ is an equal opportunity employer by both policy and practice. We are committed to building a diverse and inclusive work environment with employees who reflect our communities and enthusiastically serve them. All applicants are considered for employment without regard to race, sex, color, national origin, religion, sexual orientation, gender identity or expression, age, veteran status, political affiliation, genetic information, or against otherwise qualified persons with disabilities. It is DEQ's intent that its employment and personnel policies and practices conform to all applicable federal, state, and local laws and regulations regarding nondiscrimination. DEQ will provide if requested, reasonable accommodation to applicants in need of accommodation in order to provide access to the application and/or interview process. If any assistance is needed, please contact DEQ Human Resources Office at 804-698-4000.

Contact Information

Name: Brittany Saleeby

Phone: 804-659-2676

Email: HROCommunications@deq.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 AHP Letter (formerly COD) provided by the Department for Aging & Rehabilitative Services (DARS), or the Department for the Blind & Vision Impaired (DBVI). Service-Connected Veterans are encouraged to answer Veteran status questions and submit their disability documentation, if applicable, to DARS/DBVI to get their AHP Letter. Requesting an AHP Letter can be found at AHP Letter or by calling DARS at 800-552-5019.

Note: Applicants who received a Certificate of Disability from DARS or DBVI dated between April 1, 2022- February 29, 2024, can still use that COD as applicable documentation for the Alternative Hiring Process.