Robert Half Technology Database Developer in Brea, California

The BI Developer is responsible for designing, developing, managing and delivering state of the art Database platforms and Business Intelligence solutions. These database platforms and solutions are critical to powering the current and future transactional and analytical and Business Intelligence tools our client Essential Duties and Responsibilities: include the following. Other duties may be assigned.

  • Designs, develops and monitors an Enterprise Data Warehouse

  • Designs and monitors the construction of user-facing presentation tools, such as Microsoft SQL Server Reporting Services (SSRS) reports, Performance Point and PowerPivot

  • Designs, develops and monitors Enterprise Transformation Language (ETL) processes

  • Establishes and implements standards and strategies for data management, lifecycle, and quality

  • Defines and implements best practices and standards for the data modeling processes

  • Creates and maintains the logical and physical Data Models for the production and Business Intelligence Data Warehouse and Data Marts

  • Collaborates in data design walkthroughs to communicate Data Warehouse and Data Mart table designs to the development team

  • Develops prototype views and reports of the data, and works with business users both internal and external to refine their requirements

  • Demonstrates self-reliance in researching technical solutions and product functionality

  • Continuously improves existing approaches by seeking opportunity to creatively transform current business practices into fresh alternative solutions

  • Monitors production support issues and develops corrective solutions

  • Conducts performance tuning of existing data structures

  • Acts with honor and integrity, serving as a role model for the IT department and company

  • Respects and maintains HIPAA confidentiality guidelines

  • Acts as an interdepartmental liaison between all New Century Health offices, departments, and committees

  • Performs other duties as assigned To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

  • Strong experience working in Microsoft SQL Server and the Microsoft Business Intelligence Stack (SSRS, SSAS and SSIS)

  • Knowledge of administration of SQL Server for transactional and analysis systems

  • Strong Cube/analytical Data Model design expertise

  • Strong MDX experience preferred

  • Snowflake and Star Schema design

  • Strong Experience in PowerPivot, PerformancePoint, and SharePoint Integration for SSRS required

  • Able to work remotely for distributed development teams.

  • Knowledge of Microsoft DQS (Data Quality Services) and MDS (Master Data Management Services)

  • Specific knowledge of Software Configuration Change Management (SCCM) and Deployment Requirements for BI/DW Projects (preferred)

  • Strong business system analyst skills

  • Effective verbal and written communications skills and effective presentation skills

  • Self-motivator, independent, cooperative, flexible, creative

  • Successful in translating technical language to lay audiences

  • Expert level with T-SQL (Transact-SQL)

  • Healthcare experience required

  • Experience with deploying redundant database platforms and solutions using Microsoft Cluster, Replication is a plus

  • MCDBA Certification preferred Education and / or Experience:

  • Bachelor's degree in Computer Sciences or Computer Engineering or associated discipline or the equivalent experience

  • Requires three (3) to five (5) years' experience as a Business Intelligence/Database Warehouse Architect and/or in combination with Database Analyst experience or other equivalent work experience

  • Requires familiarity with SSRIS, SSAS, and SSIS, to apply

With more than 100 locations worldwide, Robert Half Technology is a leading provider of IT professionals on a project and full-time basis for initiatives ranging from web development and systems integration to network security and technical support. Through our alliances with industry-leading organizations such as HDI® and the Microsoft® Partner program, we have access to client companies that other staffing firms don't. In addition to our free job search services, we provide our candidates with access to free online technical training and a competitive benefits and compensation package.

Our parent company, Robert Half, once again was named to FORTUNE® magazine's list of "World's Most Admired Companies" and was the highest-ranked staffing firm. (March 1, 2016)

Contact your local Robert Half Technology office at 888.674.2094 or visit to apply for this job now or find out more about other job opportunities.

All applicants applying for U.S. job openings must be authorized to work in the United States. All applicants applying for Canadian job openings must be authorized to work in Canada.

Equal Opportunity Employer M/F/Disability/Vet

By clicking 'Apply Now' you are agreeing to Robert Half Terms of Use.

Req ID: 00350-0008890470

Functional Role: Database Developer

Country: USA

State: CA

City: Brea

Postal Code: 92821

Compensation: DOE

Requirements: SSRS - SQL Server Reporting Services, SSIS - SQL Server Integration Services, SSAS - SQL Server Analysis Services, ETL - Extract Transform Load, T-SQL - Transact-SQL, C# - Sharp