Business Intelligence Developer

Location: NYC, NY
Date Posted: 06-20-2018
JOB DESCRIPTION: 
A need for a Business Intelligence developer to design, develop and deliver BI solution for these components namely BI 420 C, BI Tax credits, M/WBE, EO50, Sponsor review

The candidate will execute following tasks:
  • Performance tune and optimize queries
  • Create dimensional logical, physical data models
  • Create ETL mapping documentation
  • Create data profile of the subject area mentioned above
  • Create ETL packages for loading data the above subject areas
  • Create BI models in OBIEE
  • Participate in project development using Agile methodology

MANDATORY SKILLS/EXPERIENCE:
  • Experience with Oracle Database: 5 years
  • Experience with Oracle Database: 5 years
  • 5 years
  • OBIEE Design and Deployment: 5 years
  • Oracle Business Intelligence Dashboards, Reporting Design and Development:
  • ETL Development via Oracle Data Integrator (ODI): 3 years
  • Writing SQL queries to perform complex data analysis: 3 years
  • Solid understanding of dimensional model (Star Schema & Snowflake Schema)

DESIRABLE SKILLS/EXPERIENCE:
  • Should have a good understanding of ETL concepts.
  • Excellent verbal and writing skills.
  • Detailed knowledge of Erwin.
  • Proficient in BI 11g Analytics.
  • Proficient in BI Desktop Tools.
  • Experience using Business Intelligence (BI) Publisher, and with BI applications.
  • Experience in core OBIEE applications dashboards, and repository
  • OBIEE development experience report development and metadata repository
  • configuration.
  • maintenance.
  • Experience implementing, supporting, and maintaining Oracle BI applications.
  • Proficient in BI 11g Publisher.
  • Proficient in BI 11g database SQL language.
  • Strong communication, influencing and leadership skills.
  • Experience in debugging and optimizing SQL queries.
  • Should have good proficiency in transformation and mapping using ODI

SPECIAL REQUIREMENTS:
  • Detailed knowledge of XML.
  • Familiarity with Oracle database architecture.
 
 
 
 
If you are interested in getting more information about this opportunity, please contact Irina Rozenberg  irozenberg@arielpartners.com  at your earliest convenience.


At Ariel Partners, we solve the most difficult problems that inhibit technology from enabling our customers to achieve their goals. Our vision is to be recognized by our stakeholders as an elite provider of IT solutions, so when they have their biggest challenges we’re on their short list. We’re looking for team members who share our values of: Integrity to do the right thing even when it hurts; Commitment to the long term success and happiness of our customers, our people, and our partners; Courage to take on difficult challenges, accept new ideas, and accept incremental failure; and the constant pursuit of Excellence

Ariel Partners is an Equal Opportunity Employer in accordance with federal, state, and local laws.

 
or
this job portal is powered by CATS