SAS/Tableau Reporting Consultant in San Francisco, CA at APEX Systems

Date Posted: 6/19/2018

Job Snapshot

Job Description

Job #:  859397

   

Location: San Francisco

 

Our Client's Fraud Analytics Group are in need of temporary end-to-end analytics support, focused on gathering data from multiple sources using SAS and subsequent development of Tableau reports.

Key Responsibilities

• Assist with data integration efforts including extraction, validation, and preparation of data from relational databases and other sources; Create calculations, statistics, and analytics needed to support fraud analytics reporting

• Assist with automation projects to populate and refresh reports on a scheduled basis

• Develop daily / weekly / monthly reports using SAS, SQL, Tableau, Excel, and other tools

• Adhere to best practices to ensure high standards of data accuracy, consistency, functionality, performance, documentation, and maintainability

• Perform quality assurance of data, processes, analytics, reports, and dashboards

• Respond to requests in a timely manner

• Follow format, content, and style guidelines

• Perform additional duties as assigned

Required Qualifications:

• Intermediate to Advanced SQL; Experienced with databases (creation of tables, views, stored procedures, and database elements)

*Experience with SAS- Macros,Dates, and SAS EG preferred

• 2+ years of experience developing in-depth reporting from scratch with Tableau 9+ (this should include filtering, performance tuning, actions, calculations, parameters, sets, level of detail, security, creation of workbooks, worksheets, and dashboards)

• 2+ years experience using Tableau with multiple data sources including relational databases (Teradata, SQL Server, or Oracle) and publishing dashboards to Tableau Server 9+

• 2+ years experience using Tableau with live data sources and scheduled extracts

• Experience using other BI tools

• Experience creating and formatting reports in Tableau for online visuals as well as PDF/printed document reporting

Desired Qualifications:

• Experience working (as a managed resource or previous employee) within Major Financial site 

• Experience with client's data systems and processes

• Experience working with BMG systems and databases is a plus

 

Please send your resume to Jennifer at jhlee@apexsystems.com if you are interested.