Job Description :
DirectClient: State of Oklahoma Office of Management and Enterprise Services (OMES)
Title: Senior SSIS/SSRS Developer
Location: Oklahoma City, OK
Duration: 1 Year contract with possible 4 years extension
Last date for submission: 04/01/2020
Project Scope Summary:
The Office of Management Enterprise Services Information Services Division (OMES-IS) with the State of Oklahoma is seeking one qualified Microsoft SSIS/SSRS Developer for staff augmentation. This position will be responsible for performing daily data analytics and report generation duties and tasks as assigned under the guidance of the OMES-IS Data Driven Services Managers and partner agency management.
General Requirements:
The SSIS/SSRS Developer designs, develops, implements and actively manage SQL server business intelligence solutions using SSIS and SSRS solutions. Some responsibilities include:
Works with users to document requirements and identify solutions.
Translates business requirements into systems, applications and process designs.
Provides team with business and technical support.
Creates and modifies stored procedures and other database objects using T-SQL.
Assists in database design and development.
Creates standard application documentation.
Analyzes and resolves SQL performance issues.
Includes the design, development, maintenance, security administration, performance monitoring and tuning, and troubleshooting of reporting deliverables to ensure the availability, integrity, confidentiality and security of information.
Example duties:
Design and implement on-line data sets and jobs;
Create queries, stored procedures, functions and other database objects.
Document and demonstrate solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments.
Confer with technical support, user and vendor representatives concerning reporting requirements, system performance, and data security requirements.
Review report specifications for compliance with departmental, division and database administration standards.
Requires a bachelor''s degree in Computer Science or related field, or equivalent work experience of three years in an information technology field. Data analytics/reporting preferred.
Knowledge/Skills/Abilities:
Knowledge of the creation, maintenance of databases and database objects.
Knowledge of repository/data dictionary systems, data security systems and database maintenance utilities.
Knowledge of ETL design practices.
Basic problem solving skills, basic critical thinking skills, and attention to detail.
Ability to listen, learn, and adapt to change.
Ability to work both independently and in a team-oriented environment.
Ability to work in a deadline oriented environment under general or direct supervision.
Ability to produce an accurate, timely, and quality work product.
Ability to establish and maintain effective working relationships with others.
Ability to provide excellent customer service to both internal and external clients.
Knowledge and understanding of regulatory compliance requirements.
Strong analytical and problem solving skills.