Senior Reporting Analyst w/ SSIS/SSRS & Tableau-Philadelphia, PA - Georgia IT Inc.
Philadelphia, PA
About the Job
Job # 8713
Title: Senior Reporting Analyst w/ SSIS/SSRS & Tableau
Rate: $40/ hour on W2 only
Location: Philadelphia, PA 19102 F2F Interview Required
JOB DESCRIPTION
Support the Xfinity Home Reporting team by creating new and maintaining existing code base used to provide reporting to end users.
JOB DUTIES
- Partner with subject matter experts to document and translate business requirements into technical requirements
- Craft technical solutions for new and existing reporting processes based on technical requirements
- Ensure technical solutions are scalable and easily adaptable to change
- Provide and present estimates for proposed solutions. Estimates should consider requirements, development, testing, and implementation/PVT efforts
- Create new and modify existing SSRS reports
- Create new and modify existing tableau reports and processes
- Create new and modify existing SQL server queries, views, packages, and ETL jobs
- Write SQL select queries against a large Teradata database to provide ad hoc analytics and to QC new reports/processes created
- Work with central Teradata team to create new and modify existing Teradata views as required
- Create and execute on high level test plans for technical changes to reports and databases
- Ensure adequate controls are in place for all processes created
- Analyze current database/reporting logic to optimize data delivery processes and reduce code toxicity
QUALIFICATIONS
Bachelor's degree (B. A.) in Computer Science, Accounting, and/or Finance required. Advanced Degree preferred.
Minimum of 5-7 years' experience:
- Reporting/analysis/database development
- Writing advanced SQL queries to support business inquiries, ETL automation, developing stored procedures
- Creating and maintaining SSRS reports
- Must have worked in a datamart / datawarehouse environment.
- Analytical functions and performing tuning
- Advanced BI/Reporting Tool experience (SSRS/Tableau) required
- Comfortable with Excel including pivot tables, charts, formulas and VBA being a plus
- Demonstrated ability to quickly understand complex businesses, including financial, operational, and strategic aspects
- Strong time management and prioritization skills with a demonstrated ability to execute against multiple projects, adapt to changing priorities, and excel in a fast-paced, results-oriented work environment.
- Strong communication and interpersonal skills, ability to work in team environment, and experience communicating with senior leadership on complex concepts and presenting executive level summaries.
TECHNICAL BACKGROUND
- Microsoft Reporting Services (SSRS) Ability to develop advanced reports, manage subscriptions, etc
- Microsoft Integration Services (SSIS) - Ability to manage and create SQL server ETL processes
- SQL Server Table, View & Procedure development
- Excel
- VBA a plus
- Tableau
- Teradata experience a plus
- Teradata SQL Assistant experience a plus
- Oracle experience a plus
- Toad experience a plus
Please provide the following details kindly for a better submission.
Job ID Number:
Full Name:
Contact No.:
Best time to call:
Interview Activity/ Offer Pending:
Email ID:
Work authorization:
Current Location (city/state):
Rate: Please give rate of the last 3 Projects
Date of Birth (Just need the Month and Day, Not the year):
Total IT Experience:
US IT Experience:
Relocation (Yes/No):
Able to do Onsite Interview (Yes/No):
Availability Date to Start:
If the candidate has been presented to the company in the past, please answer (Y/N)?:
Brief Description of why the candidate qualifies: (3- 4 Sentences)
Source : Georgia IT Inc.
