Database Programmer - SSRS Report Writer (concord / pleasant hill / martinez)
Responsible for data mining, data validation, data cleansing, report design, SQL scripting and stored procedure creation. Provide assistance in supporting daily operations including report generation, executing data feeds and troubleshooting and fixing data related system issues.
PRINCIPAL DUTIES AND RESPONSIBILITIES
Incumbent must have the skills, ability and judgment to perform the following essential job duties and responsibilities with or without reasonable accommodation:
Write SQL queries and stored procedures in MS SQL and Access
Create reports and dashboards using SQL Server Reporting Services (SSRS) and Visual Studio
Create Electronic Data Interface (EDI) files
Provide data cleanup support using manual data entry or semi-automated methods
Create scripts to automate data imports
Troubleshoot anomalies in data and correct issues identified
Automate, Schedule and Run daily, weekly and monthly reports
Troubleshoot database related issues such as latency and record blocking
Analyze performance of programs and take actions to correct deficiencies based on consultations with users and approval of supervisor
ESSENTIAL JOB REQUIREMENTS
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
o Minimum three years experience in coding MS SQL
o Minimum two years experience in creating SSRS reports or reports using similar tools
o Experience with Visual Studio
o Ability to continue to develop and hone SQL querying skills to perform more complex data manipulation, modification, extraction and cleansing
o Minimum 6 years work experience in corporate environment
o Strong analytical and quantitative skills
o Highly developed verbal, interpersonal and written communication skills
o Bachelors degree preferred, high school diploma required
o Workers Compensation Insurance experience a plus
o Must possess exceptional project management skills and be extremely sensitive to meeting or exceeding defined deadlines.
o Ability to assess problems and situations, possesses analytic ability and good judgment
o Must understand the importance of providing data in user friendly easy to utilize formats.
o High level of initiative and works well in a team environment