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, Los Angeles , Senior Business Intelligence Developer, Health Care , Los Angeles, CA, California
Click
here to apply!
|