PlacentiaRecruiter Since 2001
the smart solution for Placentia 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.

OR

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, Placentia , 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
within


Log In or Create An Account

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

Placentia RSS job feeds