CO - P0783 - Database and Analytics Manager

Title: CO - P0783 - Database and Analytics Manager

State Role Title: IT Manager I

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

Pay Band: 6

Agency: Dept of Environmental Quality

Location: Central Office

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

Recruitment Type: State Employee Only - E

Job Duties

The Database and Analytics Manager is a key leadership role responsible for overseeing and managing a team of highly technical Analytical System (Esri, GIS, Tableau, Posit) Administrators, as well as Oracle and SQL Server DBAs. In this position, you will collaborate with agency business, system and data owners, develop, and execute project, operations plan, and governance process and procedures, monitor team progress, and ensure the successful delivery of agency projects and IT operations.

Proactively planning for system upgrades, migrations/modernizations, and managing technical debt will be essential. Additionally, the Analytics and Database 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 and maintenance 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 leadership and management skills, the Database and Analytics Manager should possess strong technical acumen. Key essential technical skills for this role include:

1. Analytics System Administration and Leadership:
• High level of experience and proficiency with Esri GIS technology stack (Desktop, Enterprise, Online, Mobile, etc.).
• Familiarity with Tableau Server and Tableau Cloud.
• Familiarity with Posit Connect Server is beneficial.
2. 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.
• Experience with and certification in Oracle Cloud Infrastructure is beneficial.
3. Data Integrations:
• 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.
4. Programming and Scripting:
• SQL (PSQL/TSQL) proficiency is required.
• Python: Proficiency in Python is highly beneficial.
• R: Familiarity with statistical programming languages like R is beneficial.
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. Familiarity with DMBOK principles 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. Agile project experience is highly beneficial. CSM/PMO certifications are beneficial.
8. Technical Team Leadership:
• Demonstrated experience managing technical teams and enabling their success. Proven record of effective technical team management.

Additional Considerations

Considerable experience in database administration, maintenance, and integration, systems analysis, and design; project management; business process improvement; and team building and leadership.
A combination of education, experience, and training in Computer Science, Information Systems, database systems, analytics, GIS or related field demonstrating the required knowledge, skills, and abilities of the position.

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: Anisha D. 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.