Data Warehouse Developer

Location: Rancho Cucamonga, CA

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

Job Description
Why you want to work here:
  • 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.
What You Will Do
  • 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
Keywords: SQL, SSIS, Stored Procedures, data quality/integrity

Compensation: $110,000 Per Year

For immediate consideration please click Apply or email resumes to:

Jennifer Carlson

You may also be interested in:

Business Intelligence Developer

Rancho Cucamonga, CA

View
Apply With Linkedin Back to Job Listings