Job Description :
Role: Programmer /Developer lead - SQL/SAS Report Developer
Work Location: Phoenix, AZ
Duration : 6+ Months


JOB DESCRIPTION:
Job description :

Designing, developing, implementing and tuning complex enterprise level reporting database systems for reporting purposes
Responding to user requests for new tables, procedures, views and reports that support the reconciliation of the applications and other internal systems
Providing support for production systems, including rotational on-call support, when required.
In this role, you will design, code, test, debug, document, deploy, and support solutions. This includes the timely handling of all CMS/Compliance and SLA reporting requirements.
Functional testing support and resolution, troubleshooting of SAS issues during testing and production support periods.
Support SAS scripting and stored processes to support required functionality.
Conversion of SAS reporting to SQL SSIS/SSRS solutions.


Essential experience:
1. Proficiency with writing Sequel queries, stored procedures, functions and views for ad-hoc, recurring standard reports or file builds
2. Experience with SSIS/SSAS/SSRS is essential
3. Proficient experience with SQL 2008R2/2014 versions is required.
4. Proficient in SAS / Teradata / VBScript. (3 to 4 years of SAS experience)
5. Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server
6. Capability of writing SQL queries, stored procedures, functions and views for ad-hoc, recurring standard reports or file builds
             

Similar Jobs you may be interested in ..