What are the responsibilities and job description for the Business Intelligence/Data Integration Specialist position at Virginia Department of Environmental Quality?
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
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.
- Knowledge of Restful APIs using JSON
- Experience analyzing C# applications Oracle/SQL Server environment
Salary : $70,000 - $105,000
