logo

View all jobs

Senior Business Intelligence Reporting Analyst

San Francisco, CA
Job Title: Senior Business Intelligence Reporting Analyst
Location: San Francisco, CA
Type: Long-Term Contract

Job Description

Our client is migrating its banking platform from one vendor to another. This migration modifies the existing data models and taxonomy significantly, and, as a result, will impact dozens of user groups dependent on the current data lake and data marts. Reports and dashboards are currently sourcing data from the current sources. The reports and dashboards need to be modified to comply with the new data model and taxonomy without impacting the end-user information and business supporting needs.

Note: This is a senior-level position that requires a wide breadth of knowledge and outstanding communication skills.

Responsibilities

The Senior Analyst will review the current inventory of SSRS reports and Tableau dashboards and prepare a plan to convert them into the new environment. Closely work with users in validating new reports and obtain sign-off. The Senior Analyst is expected to be creative in coming up with tools/techniques that will help convert hundreds of reports efficiently (as opposed to hand coding every single aspect of the change manually)

Current Environment

- Data lake and data marts in SQL Server database, SSAS
- ETL used – SSIS, Informatica, Stored procedures
- Reports/Dashboards – SSRS and Tableau
- Data model and reporting needs are based out of client's current system  

New Environment

Data lake and data marts in SQL Server database, SSAS and mostly Snowflake 
- ETL used – Informatica and Stored procs compatible with Snowflake
- Reports/Dashboards – SSRS and Tableau
- Data model and reporting needs are based out on the client's current system (mapping documents from old data model to new

Skills Required

- Banking or insurance experience is highly preferred
- Strong data analysis and reporting skills
- Minimum of 5+ years of experience
- Background in SQL server database development (Stored procs and T-SQL)
- Background in ANSI SQL (Snowflake uses this version)
- Experience with ETL tools (preferably Informatica. SSIS or others will be considered)
- Minimum of 5+ years of experience
- Python experience is a plus
- Experience with reporting tools like SSRS, Tableau or similar

More Openings

Project Manager

Share This Job

Powered by