Title: CO - P4538 - Business Intelligence/Data Integration Specialist
State Role Title: Information Technology Specialist II
Hiring Range: $70,000 - $105,000
Pay Band: 5
Agency: Dept of Environmental Quality
Location: Dept of Environmental Quality
Agency Website: DEQ.Virginia.gov
Recruitment Type: State Employee Only - E
Job Duties
The Virginia Department of Environmental Quality is seeking a qualified candidate who will responsible for the development and maintenance of agency application software systems and data sources.
Minimum Qualifications
• Knowledge of System Development Life Cycle.
• Knowledge of Systems Analysis Methods and Techniques.
• Knowledge of data architecture, logical database design, physical database design, ER models, database schemas, and management of metadata.
• Knowledge of analysis, design and development for both near real time system integrations and data warehouses
• Knowledge of the following data architecture and reporting tools: SQL Server, MDS, SSIS, SSRS, DTS, Analysis Services, LogiXml, Tableau, Business Objects 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..
• Knowledge of Restful APIs uning JSON
• Knowledge of Metadata Management
• Ability to communicate effectively verbally and in writing in English with developers, data base administrators, information security, business analysts, project managers and with different business users
• Ability to translate business needs into solutions
• Ability to work effectively independently and as a member of a team;
• Ability to serve as a liaison between the business stakeholders, technical staff, and vendors for support and development.
Additional Considerations
• Knowledge of Restful APIs using JSON
• Experience analyzing C# applications Oracle/SQL Server environment
Special Instructions
Please note this position follows a hybrid working schedule to include both in-office and telework. Candidates must be able to work from the Central Office of DEQ located in Richmond, VA.
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.