Client Reporting Analyst III: BI and ETL Developer

Job Description:

The Team:

The Consumer Banking and Investment Performance reporting team is responsible for helping the enterprise measure and drive organization and associate performance.  The reporting team offers a compelling combination of professional opportunities, focused on building end-to-end reporting solutions.  We work across our space to deliver robust enterprise dashboards and scorecards as well as ad-hoc reporting capabilities to allow self-serve reporting to leaders and local insight teams.

Key Responsibilities:

• Analyze disparate database sources, including relational structures, dimensional data models and cubes.
• Develop and maintain database objects and ETL to support data preparation for BI reports, dashboards, scorecards, and Self-Serve analytic capabilities.
• Help drive efficient yet robust reporting solutions that will help drive report consolidation and provide more self-serve opportunities
• Be positive, highly motivated, innovative, self-starter with strong sense of ownership and ability to create and execute plans with little oversight.

Required Skills and Experience:

• 3+ years of experience leading end-to-end BI solutions including requirements gathering, sourcing, transformation, and reporting.
• 3+ years of expert level data analysis in a major relational database like SQL Server/Oracle/Teradata
• 3+ years of experience in data analysis and reporting, demonstrating advanced proficiency using SAS/SQL query language to access Teradata / SQL Server databases.
• Experience in database design and ETL (Extraction, Transformation and Loading) processes
• Experience in BI report development (MicroStrategy, Tableau etc)

Desired Skills:

• Bachelor's Degree in Statistics, Finance, Computer Science, Information Systems, Mathematics, Engineering, or an analytical field, or equivalent experience
• Experience in financial services with emphasis on business insights and data/financial analysis; specific experience with card services.
• Hands on experience designing data models and data transformation workflow.
• Experience with Alteryx, Hadoop, Impala, HIVE SQL, SQL server stored procedures and JAMS/Autosys schedulers.
• Ability to manage varied set of priorities, both planned and ad-hoc, and adapt within a dynamic and fast-paced environment.
• Excellent verbal and written communication, interpersonal, organizational, documentation, and presentation skills.
• Experience using analysis tools like Query Analyzer, SAS, Toad with different data platforms

Job Band:

Shift: 

Hours Per Week:

Weekly Schedule:

Referral Bonus Amount: