girl looking into her desktop
Back to search results

Client Reporting Analyst III: BI and ETL Developer

Charlotte, North Carolina;

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:

H5

Shift: 

1st shift (United States of America)

Hours Per Week:

40

Weekly Schedule:

Referral Bonus Amount:

0

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

Shift:

1st shift (United States of America)

Hours Per Week: 

40

Learn more about this role

Full time

JR-22030182

Band: H5

Manages People: No

Travel: Yes, 5% of the time

Manager:

Talent Acquisition Contact:

Jennifer Johnston

Referral Bonus:

0