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.
Job Role: BI Developer (Oracle, SQL
Server)
Location: Philadelphia PA
Duration: 6+ Months Contract
Max
Rate: $47/Hr
Need: US Citizen, Green Card, EAD
Green Card Only!!
Must Have: Oracle, SQL Server
Job Description:
Analyze large customer data sets
using a variety of database query and visualization tools
Deploy analytic
models within the various self-service reporting systems and
environments
Partner with the National Data Warehouse team to support
migration of ETL, Tables, Data, etc. into the Enterprise Data
Warehouse.
Manage new data requests by partnering with business owners to
help define business rules and translate into data-driven results designed to
meet leadership objectives.
Perform ad hoc analysis to solve operational
issues and provide data for business cases.
Provide technical expertise in
extracting, integrating, and analyzing customer critical data
Compile and
verify daily, weekly, and monthly customer focused executive reporting
Design
and develop key performance metrics and indicators using standardized and custom
reports
Develop a solid understanding of both XH and Enterprise Data
Warehouses and be able to interpret the data
Work closely with XH
leadership
Technical
Requirements:
Hadoop
Hive
Python
Oracle
SQL
Server
Teradata
Tableau
Knowledge and Abilities:
Advanced SQL coding skills
with the ability to develop new logic as well as interpret, modify, and enhance
existing queries
Strong knowledge of database query tools such as Teradata
SQL Assistant and SQL Server Management Studio
Advanced knowledge of
BI/Reporting tools such as Tableau and SSRS
Advanced Excel modeling skills
(pivot tables, advanced functions, Visual Basic etc.)
Scripting knowledge
with Python / Unix shell scripting
Excellent written and verbal
communications skills
Strong organizational skills, detail oriented and
process-driven, with an orientation toward continuous process
improvement
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.
Analytical with strong problem solving ability
Proactive and
self-directed in work habits
If you are interested please share your resume at rshaw(at)ayrglobal(dot)com or you can directly call me on (609) 736-0817