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
Skills Required
- 5+ years coding advanced SQL queries, ETL automation, and stored procedures
- 5+ years reporting, analytical, and database experience in dynamic business environments
- Microsoft Reporting Services (SSRS) - develop advanced reports and manage subscriptions
- Microsoft Integration Services (SSIS) - manage SQL Server ETL processes and job failures
- Relational database development (SQL Server, Teradata) including table, view, and procedure development
- Teradata environment experience
- Teradata SQL Assistant experience
- Excel - Charts, Pivot Tables, Equations, VBA
- Experience transforming complex datasets into relevant visualizations
- Bachelor's degree in Information Systems, Business Intelligence, Computer Science or equivalent
- Excellent communication skills and ability to work cross-functionally
- Tableau experience
- Oracle experience
What We Do
AYR Global IT Solutions Inc is a national staffing firm specializing in cloud, cybersecurity, and web application services, including ERP and BI implementations. They provide proven and experienced consultants to a diverse range of enterprise customers and global system integrators. Their mission is to bridge the gap between technology and business needs through tailored, innovative IT services and professional consulting across federal and commercial projects nationwide.
