Credit One Bank Careers

Business Intelligence Application Developer III in Las Vegas, NV at Credit One Bank

Date Posted: 4/19/2018

Job Snapshot

Job Description

Position Summary

The BI Application Developer III is an experienced Data Warehousing Developer and Architect that will work as a senior member in a team environment building business intelligence applications. The ideal candidate has five or more years of experience in Data Warehousing and Business Intelligence and has working knowledge of Microsoft BI tools SSIS, SSAS and SSRS. The BI Application Developer III will deliver analytical applications to the organization that include ETL, Data Marts, Data Cubes (OLAP), standard reports and other analytical applications as required. The candidate will fill a strategic role assessing Data Architecture for future evolution and change and assess business needs, recommending new Visualization and Analytic tools as required. The candidate will provide forward-thinking Business Intelligence and Data Management recommendations and play a key role in expanding the Company’s Business Intelligence Architecture. The BI Application Developer III will help to teach and assist the less experienced members of the team.

 

Summary of Essential Job Functions

 

Development: Data Architecture, Data Models, ETL and OLAP Cubes – Design, Develop and Deploy Dimensional Data Models. Create Integration Services packages, scripts and other elements to move data from source systems into the data warehouse. The BI Application Developer III will also utilize data transformation steps to cleanse, aggregate and summarize data to create star schemas consisting of fact and dimension tables. The candidate will assist in reviewing design and code produced by team members.

Report Development - Work in collaboration with the organization to understand business issues, identify new valuable areas of analysis and develop reports that analyze data warehouse information to support effective rapid decision making. Assist in developing and deploying reports using various tools including SSRS, Excel and Sharepoint. Recommend additional tools for improved Data Visualization for business users.

Ad-Hoc Reporting Environment Support – Deploy and maintain reporting models using Visual Studio and SQL Server Reporting services that the business community can leverage for self-service analysis. Publish and maintain necessary metadata (data dictionary, etc.) to support the self-service reporting environment. Conduct informal training sessions that foster a solid understanding within the business community of both the ad-hoc reporting models and reports published through the reporting dashboard.

Production Processing Support - Provide support and troubleshoot issues as needed for the automated ETL data processing environment. Assess the growing and evolving environment for improvement and work with the BI team to enhance process logic, improve data quality, and improve performance and data availability.

Job Requirements

Position Requirements

  • Bachelor's degree in Math, IT or Finance.
  • Five or more years’ experience building Data Warehouse and Business intelligence solutions.
  • Experience working with SQL queries and data processes.
  • Demonstrable experience using Microsoft Business Intelligence technologies: SSAS, SSIS, SSRS or similar technologies.
  • Expert knowledge with SQL Server 2012 or later and SQL syntax.
  • Expert knowledge with OLAP (SSAS, Cubes) and MDX query syntax. Knowledge of DAX a plus.
  • Experience with Microsoft Sharepoint is a plus.
  • Ability to work directly in a team environment with a business group to translate business requirements into reporting solutions.
  • Keen interest in understanding business issues through detailed information analysis and the ability to analyze data in terms of its business meaning.
  • Ability to comprehend index design and SQL statement optimization techniques.
  • Ability to work in a collaborative environment on complex problems.
  • Must be able to analyze and understand business needs and requirements in order to translate to system specifications and deliverable solutions.
  • Should be able to effectively identify test scenarios in order to assist with systems and user testing.
  • Ability to troubleshoot both Code and Data quality issues.
  • Good communication and documentation skills.
  • Strong work ethic and organized work habits.
  • Ability to interface well with business end-users and vendors.
  • Foster company success through a professional appearance, being courteous to customers & vendors and by having a positive attitude.

Physical Requirements

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

  • While performing the duties of this job the employee is regularly required to sit. However, the employee may choose to stand and move within the cubicle area.
  • Dexterity of hands and fingers to operate a computer keyboard and mouse.
  • Must possess the ability to effectively hear and communicate.
  • The employee is occasionally required to stand and walk.
  • The employee must occasionally lift and/or move up to 5 pounds.
  • Specific vision abilities required by this job include close vision, peripheral vision, depth perception and ability to adjust focus.

 

Based on the Fair Labor Standards Act (FLSA), management has analyzed this position and determined it to be exempt.

CHECK OUT OUR SIMILAR JOBS

  1. Software Engineer Jobs
  2. Project Engineer Jobs