Role : Data analyst / SQL Developer / Tableau

Location :  IRVING, Texas

Rate : $45/hr

Duration : 6 Months

Job Description :

Position for ambitious self-starter with extensive background in Business Intelligence or Data warehouse data analysis and strong sense of intellectual curiosity to understand and solve business problems. Extensive experience in database and SQL skills such as analyzing and improving table performance Analysis and tuning SQL queries. Has strong skillset in creating reports and performing business analysis in Tableau and Excel. Strong communication skills to communicate analysis, findings and insights.

Database requirements
Candidate needs to have ?5+ years of proficiency in creating complex SQL and ETL in variety of databases in priority order: Teradata, SQL Server and Oracle.
Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Objects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, etc.
Extensive experience in developing UNIX Shell scripts, SQL and PL/SQL (Coding Procedures, Functions, Database Packages and Triggers).
Scheduled complex cron jobs on UNIX platform using crontab format
Teradata certification a plus
Reporting requirements
Candidate needs to be familiar with reporting and analysis tools especially Tableau, Excel. SQL reporting services a plus.
Familiarity with Tableau Javascript API, Rest API and Data Extract API
Ability to leverage best practices for dashboards and data visualizations
Ability to identify and resolve performance issues
Knowledge of Tableau metadata and ability to create and maintain data dictionaries
Tableau certification is a plus
Education requirements
At least B.Sc. in computer science, preferable Masters

Qualification
Rating

Must Have

Complex Problem Solving Skills

Problem Solving Skills *

0 (No Familiarity) of 5 (Expert)

Needs Analysis and Design

Software Development Phases *

0 (No Familiarity) of 5 (Expert)

Process

Organizational Skills *

0 (No Familiarity) of 5 (Expert)

Productivity Software

Microsoft Excel *

0 (No Familiarity) of 5 (Expert)

and 0 Yrs.

Microsoft Word *

0 (No Familiarity) of 5 (Expert)

and 0 Yrs.

Social Skills

Communication Skills *

0 (No Familiarity) of 5 (Expert)

Primary Skill Requirement

Data analyst / SQL Developer / Tableau

CM Work Order #

Coordinator Use Only

Data analyst / SQL Developer / Tableau

Position for ambitious self-starter with extensive background in Business Intelligence or Data warehouse data analysis and strong sense of intellectual curiosity to understand and solve business problems. Extensive experience in database and SQL skills such as analyzing and improving table performance Analysis and tuning SQL queries. Has strong skillset in creating reports and performing business analysis in Tableau and Excel. Strong communication skills to communicate analysis, findings and insights.

Database requirements

Candidate needs to have >5+ years of proficiency in creating complex SQL and ETL in variety of databases in priority order: Teradata, SQL Server and Oracle.

Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Objects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, etc.

Extensive experience in developing UNIX Shell scripts, SQL and PL/SQL (Coding Procedures, Functions, Database Packages and Triggers).

Scheduled complex cron jobs on UNIX platform using crontab format

Teradata certification a plus

Reporting requirements

Candidate needs to be familiar with reporting and analysis tools especially Tableau, Excel. SQL reporting services a plus.

Familiarity with Tableau Javascript API, Rest API and Data Extract API

Ability