ETL/BI/Data reports consultants

Subject: ETL/BI/Data reports consultants
Location: Philadelphia, Pa.
Duration: One year plus

Experience - Must haves!
5+ years coding advanced SQL queries, ETL automation, and stored procedures to support business inquiries
5+ years of demonstrated reporting, analytical, and database experience in a dynamic business environment
Advanced BI/Reporting Tool experience (SSRS) required.
Experience with transforming complex datasets into relevant visualizations
Familiar with relational database technology and terminology
Functional Competencies
SQL coding proficiency (5+ years)
Microsoft Reporting Services (SSRS) – Ability to develop advanced reports, manage subscriptions, etc.
Microsoft Integration Services (SSIS) - Ability to manage SQL Server ETL processes / job failures, etc.
Relational database development (SQL Server, Teradata)
SQL Server – Table, View & Procedure development
Teradata environment experience
Teradata SQL Assistant experience
Excel – Charts, Pivot Tables, Equations, VBA
Tableau experience a plus
Oracle experience a plus
Qualifications
Bachelor’s degree required (preferably in Information Systems, Business Intelligence, or Computer Science) with related experience, or an equivalent combination of education and experience from which comparable knowledge and abilities can be acquired.
A sound technical background with the ability to analyze complex data sets, business processes, and quickly adapt to the use of new technologies.
Must have excellent communication skills with the ability to share technical capabilities and work cross-functionally between business functions.

If anyone might be intersted please send resumes to kmarsh@ayrglobal (dot) com or you can reach me direct at (571) 250-6817