Production Support Data Analyst - Data Analyst

CCCi has a large utility customer who needs a production support data analyst for a long term contract.

• Work with application teams to design and build databases and database objects.
• Develop and implement SQL scripts to make database object changes as required to support application goals (Create/Delete tables, columns, indexes, etc.)
• Manage database and application security through user administration and granting correct roles and privileges.
• Develop and implement ETL jobs to support application goals.
• Develop procedures in PL/SQL to support ETL or application goals.
• Troubleshoot database issues and manage to resolution.
• Troubleshoot data issues and manage to resolution.

Skills Required/Desired:

• Experience working with one or more of the following DBMS to create and maintain database objects. (SQL Server, Sybase 12, Oracle 10G)
• Experience writing and optimizing SQL.
• Experience writing PL/SQL procedures.
• Experience writing ETL jobs in SQL Server DTS and Informatica.
• Experience extracting and loading data.
• Proficiency with MS Office Suite of products.
• Good oral and written communication skills.