Data Warehouse Developer

Location: Rancho Cucamonga, CA

Skills: SQL, SSIS, ETL, Stored Procedures, data quality/integrity

Job Description

Job Title: Data Warehouse Developer

Why work here as a Data Warehouse Developer?

  • Company rewards team members for talent and contribution. Comp packages include salary, bonus, and benefits package valued at 35% of annual salary! Multiple paid holidays and multiple PTO days each year.
  • Winning team culture and was recently names "Favorite overall Company to Work For," and "Favorite Workplace Culture" in a recent new survey.
  • Located in Rancho Cucamonga and very close to many major freeways, great shopping/dining/entertainment, and a brand-new facility that includes free parking, weekly car wash, quiet rooms and a large cafeteria that serves Starbucks.

As a Data Warehouse Developer, you will:

  • Design, plan and develop data warehouse and analytics solutions to increase the usability, completeness, and efficacy of enterprise data
  • Design and create procedures to acquire, harmonize, and consolidate data assets
  • Design, develop and lead data warehouse Extraction, Transformation and Loading (ETL) solutions using Microsoft SQL Server Integration Services (SSIS)
  • Lead ETL development and provide support for systems as necessary for business continuity
  • Create high throughput historical and incremental ETL jobs
  • Lead and mentor tuning and coding activities to produce efficient and high quality solutions
  • Lead, design, develop and implement data collection processes in conjunction with the data warehouse
  • Source data from payer platforms and legacy systems supporting a centralized data warehouse and reporting platform
  • Work with data informaticsts and data analysts to translate analytic requirements into technical solutions
  • Analyze user requirements and translate into database requirements and implement in database code
  • Manage and enforce standards on data modeling, data profiling, database design and metadata management
  • Monitor and support ETL processes ensuring integrity and proper integration of all data sources
  • Create high throughput historical and incremental ETL jobs
  • Provide detailed analysis of data issues, data mapping, and the process for automation and enhancement of data quality
  • Ensure that all deliverables are thoroughly documented in data warehouse and ETL knowledge base documents

What Gets You The Job?

  • Bachelor’s Degree required (Master’s Degree is a plus)
  • 5 years’ experience performing data warehouse development, modification and support
  • 5 years’ experience with knowledge of data warehouse technical architectures, ETL, data structures, and reporting tools and environments
  • 3 years’ experience with SQL Server (SSIS) with the ability to perform SQL query tuning activities
  • Strong understanding of database structures, theories, principles, and practices
  • Strong knowledge of SQL including multi-server environment knowledge (i.e. linked servers, data replication, backup/restore with MS SQL Server 2008 and newer)
  • Highly skilled in developing and optimizing T-SQL (DDL, DML, DCL) queries, stored procedures, functions, and views for various applications that involve numerous database tables and complex business logic
  • Experience in code development, testing for QA, and data profiling
  • Experience in normalized, dimensional, star schema and snow flake schematic models
  • Knowledge of the full software development life cycle (SDLC), including coding standards, code reviews, source control management, build processes, testing, and operations
  • Experience and knowledge in logical, rational, dimensional, and physical data modeling
  • Background in database systems along with a strong knowledge of SQL. Multi-server environment knowledge such as linked servers, data replication, backup/restore with MS SQL Server 2008+
  • Extensive experience developing and optimizing T-SQL (DDL, DML, DCL) queries, stored procedures, functions, and views for various applications
  • Knowledge of healthcare systems and healthcare databases is a huge plus

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.

Job Title: Data Warehouse Developer

Why work here as a Data Warehouse Developer?

  • Company rewards team members for talent and contribution. Comp packages include salary, bonus, and benefits package valued at 35% of annual salary! Multiple paid holidays and multiple PTO days each year.
  • Winning team culture and was recently names "Favorite overall Company to Work For," and "Favorite Workplace Culture" in a recent new survey.
  • Located in Rancho Cucamonga and very close to many major freeways, great shopping/dining/entertainment, and a brand-new facility that includes free parking, weekly car wash, quiet rooms and a large cafeteria that serves Starbucks.

As a Data Warehouse Developer, you will:

  • Design, plan and develop data warehouse and analytics solutions to increase the usability, completeness, and efficacy of enterprise data
  • Design and create procedures to acquire, harmonize, and consolidate data assets
  • Design, develop and lead data warehouse Extraction, Transformation and Loading (ETL) solutions using Microsoft SQL Server Integration Services (SSIS)
  • Lead ETL development and provide support for systems as necessary for business continuity
  • Create high throughput historical and incremental ETL jobs
  • Lead and mentor tuning and coding activities to produce efficient and high quality solutions
  • Lead, design, develop and implement data collection processes in conjunction with the data warehouse
  • Source data from payer platforms and legacy systems supporting a centralized data warehouse and reporting platform
  • Work with data informaticsts and data analysts to translate analytic requirements into technical solutions
  • Analyze user requirements and translate into database requirements and implement in database code
  • Manage and enforce standards on data modeling, data profiling, database design and metadata management
  • Monitor and support ETL processes ensuring integrity and proper integration of all data sources
  • Create high throughput historical and incremental ETL jobs
  • Provide detailed analysis of data issues, data mapping, and the process for automation and enhancement of data quality
  • Ensure that all deliverables are thoroughly documented in data warehouse and ETL knowledge base documents

What Gets You The Job?

  • Bachelor’s Degree required (Master’s Degree is a plus)
  • 5 years’ experience performing data warehouse development, modification and support
  • 5 years’ experience with knowledge of data warehouse technical architectures, ETL, data structures, and reporting tools and environments
  • 3 years’ experience with SQL Server (SSIS) with the ability to perform SQL query tuning activities
  • Strong understanding of database structures, theories, principles, and practices
  • Strong knowledge of SQL including multi-server environment knowledge (i.e. linked servers, data replication, backup/restore with MS SQL Server 2008 and newer)
  • Highly skilled in developing and optimizing T-SQL (DDL, DML, DCL) queries, stored procedures, functions, and views for various applications that involve numerous database tables and complex business logic
  • Experience in code development, testing for QA, and data profiling
  • Experience in normalized, dimensional, star schema and snow flake schematic models
  • Knowledge of the full software development life cycle (SDLC), including coding standards, code reviews, source control management, build processes, testing, and operations
  • Experience and knowledge in logical, rational, dimensional, and physical data modeling
  • Background in database systems along with a strong knowledge of SQL. Multi-server environment knowledge such as linked servers, data replication, backup/restore with MS SQL Server 2008+
  • Extensive experience developing and optimizing T-SQL (DDL, DML, DCL) queries, stored procedures, functions, and views for various applications
  • Knowledge of healthcare systems and healthcare databases is a huge plus

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.

Compensation: $120,000/Year

For immediate consideration please click Apply or email resumes to:

Barbara Meadows

You may also be interested in:

Business Intelligence Developer

Rancho Cucamonga, CA

View
Apply With Linkedin Back to Job Listings