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.

Skills

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:

• 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.
• 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.
• 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.
• 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.
• Server Administration:
• Experience administering Linux and/or Windows Servers in an enterprise environment.
• 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.
• Project Management / Agile Proficiency
• Experience in managing and executing technical projects. Agile project experience is highly beneficial. CSM/PMO certifications are beneficial.
• 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.