ETL/BI/Data reports consultants

AYR Global IT Solutions is a national staffing firm focused on cloud,
cyber security, web application services, ERP, and BI implementations by
providing proven and experienced consultants to our clients.
Our competitive, transparent pricing
model and industry experience make us a top choice of Global System
Integrators and enterprise customers with federal and commercial
projects supported nationwide.

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