\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

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.

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.