Business Intelligence Specialist Loc: Roseville, CA
100,000 - 200,000
Job Description:
Responsibilities will include and are not limited to the following:
- Develops, documents, and communicates the overall architectural approach for enterprise Business Intelligence.
- Plans and implements best-in-class Business Intelligence capabilities across the entire company\'s ecosystem.
- Advises technology and business leadership on Business Intelligence strategy and planning.
- Functions as the primary subject matter expert for reporting and dash boarding for the organization.
- Develops, deploys and maintains report and dashboards as needed.
- Develops reporting and dashboard review and testing standards, and creates appropriate documentation to ensure viability and consistency.
- Develops templates for documenting user needs for reports and dashboards.
- Ensures that all BI development follows standards and appropriate practices for code management, change control, version control, and release management.
- Leads the BI development practice leveraging best practices to ensure quality development, ease of maintenance, high level of usability, and rapid delivery of BI reports and dashboards. Communicates best practices to business units and IT colleagues as appropriate.
- Monitors the performance of existing reports and dashboards to ensure proper performance and the retirement of obsolete objects.
- Designs and prototypes analytic solutions with clients.
- Consults with other reporting and IT professionals within the organization to ensure adherence to enterprise direction and standards within the data warehouse environment.
- Performs all other job duties as assigned by supervisor.
Your Profile:
The successful candidate will possess the following:
- Bachelor's Degree in Computer Science or related field preferred with 6 years Business Intelligence implantation experience required; OR an equivalent combination of education and experience required.
- Expert knowledge of Business Intelligence standards and best practices.
- Expert at writing SQL for querying a database.
- Expert in a least on of the following BI tools: Tableau, Business Objects, Cognos, Tibco, SSRS, TM1, Power Pivot, Oracle Business Intelligence (OBI).
- Strong understanding of dimensional data modeling.
- Strong SQL optimization capabilities.
- Experienced in developing stored procedures.
- Experienced in delivering reporting solutions on SharePoint.
- Clear understanding of RDBMS fundamentals.
- Proficient with MS Word, Excel, and Outlook.
- Ability to write clear documentation of operating procedures, and ability to write specifications.
- Exceptional communication, problem solving, and teamwork skills.
- High level of cooperation with others and is responsive to the Bank\'s needs.
- Extremely detail oriented and able to follow clear methodologies for troubleshooting and development.
- Ability to support and work within standard software development life cycle practices.
- Analytical thinking, strong judgment, and problem analysis techniques.
- Ability to work effectively without direct supervision.
- Ability to comprehend and interpret Bank policies and procedures.
- Possess effective time management and organizational skills.