Previous Job
Previous
Business Intelligence Developer (3-5 years)
Ref No.: 18-00037
Location: Jersey City, New Jersey
Position Type:Direct Placement
Experience Level: 2 Years
Start Date: 05/14/2018
Pay Rate : $ 85,000.00 - 100,000.00 /Hour
Business Intelligence Developer (2 + years of experience)
Location: Jersey City, NJ

Salary: 85-100K+7% Bonus

~Must have 3-5 years of ETL Development experience.
~Must have reporting experience with any type of reporting tool such as Tableau, MicroStrategy, Cognos, etc.
~Must have strong Database skills with either Oracle or SQL.​

Requirements:
Education –
Bachelor's degree in Computer Science or other related business area preferred. Master's Degree in business or computer science a plus. Business experience will be considered in lieu of a degree.


Skills-
Management, Leadership, and Personal Skills
Dependable:
  • People Oriented
  • Good Interpersonal Skills
  • Establishes and maintains effective working relationships at all levels
  • Self-Starter
  • Strong Communication Skills: Verbal & Written
  • Good documentation skills
  • Willing to learn new skills
  • Possesses an analytical approach toward drawing logical conclusions

Technical Skills:
  • Good working knowledge designing and developing dimensional models, operational data stores, and master data repositories.
  • Good working knowledge of ETL development with SAP Data Services or equivalent
  • Good working knowledge of report development in BusinessObjects Enterprise including Web Intelligence & Crystal Report or equivalent tools
  • Familiarity of BusinessObjects Universe design
  • Working knowledge administering SAP Data Services & BusinessObjects Enterprise environments
  • Good working knowledge writing Oracle SQL queries and developing PL/SQL stored procedures and packages
  • Familiarity with MS SQL Server & No SQL databases
  • Good working knowledge using Erwin (or similar modeling tool) and building 3rd normal form / dimensional models
  • Familiarity working with a job scheduling tool such as TIDAL
  • Familiarity with dashboard development using QlikView or other tools
  • Familiarity with Amazon Business Intelligence tools such as Redshift and AWS Cloud terminology is a plus
  • Familiarity with statistical/analytical tools such as R, Python or SAS is a plus

Experience-
  • Minimum 3 years of IT experience
  • Minimum 2 years of working on Business Intelligence projects
  • Minimum 2 years of ETL development experience preferably SAP Data Services
  • Minimum 1 year of experience developing reports & universes in SAP BusinessObjects Enterprise
  • Minimum 1 year of experience with Oracle development using SQL & PL/SQL
  • Knowledge of MS SQL Server is a plus
  • Minimum 1 year of experience designing dimensional & 3rd normal form data models
  • Working knowledge of QlikView as a dashboard development tool is preferred
  • Working knowledge of a scheduler tool such as TIDAL is a plus


Function:
Design and develop various components of the Business Intelligence environment at the Bank, including the data warehouse and related decision support facilities. Perform the activities related to the design, development, documentation, and support of the Bank's data warehouse data model / architecture and the establishment of policies and procedures pertaining to its management, maintenance, and utilization. Set and monitor standards related to the data warehouse data model. Assist the business intelligence architect and project manager in the management of the Bank's data warehouse environment.

Essential Duties:
  • Provide the necessary level of self-management and task control to keep all assigned projects on schedule.
  • Perform preliminary project analysis and document findings in the manner required by department standards
  • Design, develop, maintain and document the components of the Business Intelligence environment.
  • Work with architects to translate requirements into technical specifications. Helps identify and assess potential data sources.
  • Analyze, design & develop ETL jobs and reports.
  • Identify data quality issues.
  • Design, implement and document data warehouse schemas using Bank's standard technology tools Report development in BusinessObjects Enterprise Web Intelligence & Crystal Reports.
  • Develop Scheduler jobs
  • Develop, manage, schedule, and document data warehouse operations and tasks, including extraction, movement, loading, archival, security, backup, and aggregate table creation.
  • Test, monitor, manage and validate data warehouse activity, including data extraction, transformation, movement, loading, cleansing, and updating processes.
  • Provide full support for the Bank's business intelligence environment. Support includes but is not limited to: problem resolution (business and non-business hours); user support; and system maintenance.
  • Support the Bank's application development process.
  • Assist project managers and end users in identifying and recommending automated solutions to business problems.
  • Assist the database administrator where appropriate in troubleshooting performance issues in Oracle data warehouse
  • Monitor business use and performance of the data warehouse and provides feedback to data warehouse architects, developers, and database administrators.
  • Ensure the data warehouse meets service level requirements.


intelligence SAS office business objects business intelligence SAS office business objects business intelligence SAS office business objects business intelligence SAS office business objects business intelligence SAS office business objects business intelligence SAS office business objects business intelligence SAS office business objects business intelligence SAS office business objects business intelligence SAS office business objects business intelligence SAS office business objects business intelligence SAS office business objects business intelligence SAS office business objects business intelligence SAS office business objects business intelligence SAS office business objects business intelligence SAS office business objects business intelligence SAS office business objects business intelligence SAS office business objects business intelligence SAS office business objects business intelligence​