CO - P0783 - Database and Analytics Manager

Title: CO - P0783 - Database and Analytics Manager

State Role Title: IT Manager I

Hiring Range: $110,000 - $130,000

Pay Band: 6

Agency: Dept of Environmental Quality

Location: Central Office

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

Recruitment Type: General Public - G

Job Duties

The Virginia Department of Environmental Quality, Office of Information Systems is seeking a qualified Database and Analytics Manager. This leadership role is responsible for overseeing and managing a team of highly technical Oracle and SQL Server DBAs, GIS, and analytics (R/Tableau) administrators and technical specialists. In this position, you will collaborate with agency business and data owners, develop, and execute project and operations plans, monitor team progress, and ensure the successful delivery of agency projects and IT operations.

Proactively planning for system upgrades, migrations, and managing technical debt will be essential. Additionally, the Database and Analytics Manager will actively participate in the Office of Information Services (OIS) management team’s planning and leadership activities. The position will work closely and report to the IT Strategic Operations Manager and will work in close collaboration with the OIS Application Development Team to support ongoing development projects and operational work.

Minimum Qualifications

Considerable experience in database administration, maintenance, and integration, systems analysis, and design; project management; business process improvement; and team building and leadership.

In addition to technical team leadership, coordination and management skills, the Database and Analytics Manager should possess strong technical acumen. Key essential technical skills for this role include:

1. Database Proficiency:
-RDBMS Enterprise Databases: A solid understanding of SQL Server and/or Oracle is crucial. This includes knowledge of data modeling, query optimization, and database administration.
-Data Warehousing: Familiarity with data warehousing concepts and practices is essential. Understanding how to design and manage data warehouses efficiently.

2. Data Integration:
-ETL (Extract, Transform, Load): Proficiency in ETL processes and tools is necessary for managing data flow across various systems. Experience and proficiency with SSIS and/or Node.
-API Integration: Knowledge of integrating data via APIs is important. This includes understanding RESTful APIs, SOAP services, and other integration methods.

3. Programming and Scripting:
-SQL (PSQL/TSQL) proficiency is required.

4. GIS & Analytics:
-Familiarity with Esri’s GIS Enterprise and ArcGIS Online stack.

5. Server Administration:
- Experience administering Linux and/or Windows Servers in an enterprise environment.

6. Data Governance and Compliance:
-Understanding data privacy laws, DEQ/state agency regulatory requirements, and ensuring compliance within the organization is critical. Experience managing data within Virginia State agencies is beneficial.
- Working understanding of IT security requirements under VITA ITRM Standard SEC530.

7. Project Management / Agile Proficiency
- Experience in managing and executing technical projects.

Additional Considerations

Experience with and preferred certification in Oracle Cloud Infrastructure.
Oracle Integration Cloud proficiency is highly beneficial.
Python: Proficiency in Python is highly beneficial.
R: Familiarity with statistical programming languages like R is beneficial.
Familiarity with Tableau Server and Tableau Cloud offerings is beneficial.
Familiarity with Posit Connect Server is beneficial.
Agile methodology proficiency is highly beneficial.
CSM, PMO, or other relevant project management experience is highly beneficial.

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:

*This is a re-advertisement - previous applicants need not re-apply.*

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: Anisha Trice

Phone: 804-929-3923

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.