BI Developer

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!!

Responsibilities

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; 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