Sr Power BI BoBJ Consultant c2c software jobs Oakland, CA

Position: Sr Power BI BoBJ Consultant
Location: Oakland, CA(Hybrid)

Duration: 12 + Months

Job Duties:

·       Develops SQL Business Intelligence (Bl) reports, models, and applications as illustrated by the following:

·       Designs, builds, and populates data objects such as SSAS cubes, relational dimensional databases, and SSAS data mining models

·       Designs and builds Bl user interfaces such as dashboards and reports using SAP business objects, Lumira, Tableau & other Bl Tool

·       Designs and builds data models to support self-service BI

·       Knowledge of data models, data marts & data warehouses.

·       Supports Data Warehouse enhancements and operations including table, view, stored procedure, and other changes.

·       Performs query tuning and optimization

·       Develops, monitors, and maintains ETL (Extract, Transform, Load) processes that extract, transform, and load data into the Data Warehouse and Bl data objects.

·       Meets with Lines of Business and Business Systems Analysts to define reporting requirements and goals and to identify the data needed for meeting business requirements.

·       Maintains data dictionary and related meta-data stores.

·       Follows change and version control in moving code from development to test/QA and to production environments

·       Participates in the development of Bl applications and solutions.

·       Develops routines and procedures for end-users to facilitate best practices use of reporting tools and applications.

·       Assists Lines of Business with the development and deployment of reports and usage of self-service Bl tools

·       Supports the automated report generation, distribution, and archiving processes.

·       Research, reviews, and analyzes the effectiveness and efficiency of existing reporting and ETL procedures and develops strategies for enhancing or further leveraging these processes.

·       Follows appropriate incident, problem, change management, and project processes.

·       Achieves goals assigned to the Developer as part of the department’s annual operating plan and budget

·       A bides by the current laws and organizational policies and procedures designed and implemented to promote an environment which is free of harassment and other forms of illegal discriminatory behavior in the workplace.

·       Coordinates specific work tasks with other personnel within the department as well as with other departments to ensure the smooth and efficient flow of information.

·       Cooperates with, participates in, and supports the adherence to all internal policies, procedures, and practices in support of risk management and overall safety and soundness

·       Complies with established operating policies and procedures to maintain adequate controls and to support the bank’s adherence to outside regulatory requirements.