the smart solution for Los Angeles jobs

Senior Business Intelligence Developer

Company: Berklee College of Music
Location: Los Angeles, CA
Posted on: November 21, 2018

Job Description:

Contribute to creating and supporting standard and ad hoc reports for IT
and Senior Business Management; Collaborate with Business Analysts and
key business contacts to translate functional and technical
specifications into a comprehensive reporting design; Assist in
requirements analysis, data analysis, data mapping, report development &
testing, report modifications and documentation; Determine and develop
strategy and framework for consistent report standards; Research, audit
and analyze high level complex and advanced data; Define, design and
develop new and enhanced reports in support of strategic planning,
portfolio and project management, resource management and development of
standard processes; Design database architectures, data warehouses and
data migrations; Design, program, test, debug, maintain and document
hardware/software for an advanced level of projects to meet business
application needs interpreting policies, procedures and guidelines;
Develop, implement, and maintain ETL (extract, transform, and load)
solutions to bring new data into the data warehouse; Work closely with
business clients to resolve issues and enhance systems; Assess and
evaluate technology needs to recommend solution options; Perform
interface analysis on detail level; Work with SQL Server Integration
Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server
Analysis Services (SSAS) and SQL Server Management Studio (SSMS).

Education and Experience:

Bachelor's degree (or higher) in Computer Science, Engineering,
Statistics, Math, Business Systems or related quantitative field
(willing to accept foreign education equivalent) plus sixty months'
experience as Business Intelligence Developer.


Master's degree in Computer Science, Engineering, Statistics, Math,
Business Systems or related quantitative field (willing to accept
foreign education equivalent) and thirty-six months' experience in
Business Intelligence Developer.

Skill Requirements:

Within five (5) years must have experience in designing the efficient
ETL process to transform and load data from various sources across the
enterprise; Developing efficient SSIS packages for processing fact and
dimension tables with efficient transformations; Extracting,
Transforming and Loading source data into respective target tables to
build the required data marts; Responsible for Deploying, Scheduling
Jobs, Alerting and Maintaining SSIS packages; Implementing and managing
Event Handlers, Package Configurations, Logging, System and User-defined
Variables, Check Points and Expressions for SSIS Packages; Creating and
executing unit, functional and integrated testing; Developed various
reports which include drill down reports, drill through repots, cascaded
parameterized reports, matrix reports using SSRS in share point
integrated mode; Worked on querying the data and creating-on demand
reports using Report Builder in SSRS and also responsible to set up
report subscriptions and deploy them to share point server.

Interested candidates should email resumes to jtorres@lacare.org - with
reference to the job title

Keywords: Berklee College of Music, Los Angeles , Senior Business Intelligence Developer, Health Care , Los Angeles, CA, California

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest California jobs by following @recnetCA on Twitter!

Los Angeles RSS job feeds