Software Engineer III – P3 at Credit One Bank, N.A.
Las Vegas, NV
About the Job
Software Engineer III – P3 with Credit One Bank, N.A. (Las Vegas, NV)
Job Description: Produce financial and market intelligence by querying data repositories and generating periodic reports. Deliver analytical applications to the organization that include ETL, Data Marts, Data Cubes (OLAP), standard reports and other analytical applications as required. Assist in assessing Data Architecture for future evolution and change and assess business needs, recommending new Visualization and Analytic tools as required. Utilize data transformation steps to cleanse, aggregate and summarize data to create star schemas consisting of fact and dimension tables. Work in collaboration with the organization to understand business issues, identify new valuable areas of analysis and develop reports that analyze data warehouse information. 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. Provide support and troubleshoot issues as needed for the automated ETL data processing environment. 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.
Job Requirements: Requires a Bachelor’s degree in Computer Science, Math, Information Technology, Finance, or related quantitative field and 3 years of experience in Business Intelligence or Data Analyst or related occupation. Must include experience in each of the following skills: Building Data Warehouse and Business Intelligence Solutions based on translation of business requirements; Microsoft Business Intelligence Technologies (SSAS, SSIS, and SSRS); Designing indexes using SQL statement optimization techniques; Identifying test scenarios for systems and user acceptance testing; SQL Server and SQL syntax; Troubleshooting code and data quality issues; Analyze and Test database SQL query for performance tuning; Oracle SQL and PL/SQL; data modeling tools; Linux, bash, shell scripting; SQL Server database tuning, backup and upgrades; and Agile, SCRUM, Jira.
To apply: send resume to: Credit One Bank, ATTN: Charlie Castonguay, Ref #C1B082, talent.acquisition@creditone.com.