CO - P4538 - Business Intelligence/Data Integration Specialist

\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: General Public - G

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

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:

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. 

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 rac