Sr. Data Warehouse

2 days ago


Fairfield CA, United States Client of Maven Companies Inc. Full time

Top Requirements (Must haves)

Senior Level – 8-10 years of experience
Healthcare background

Does NOT want to see:
Informatica
DataStage
BI Developers

DOES want to see:
~10+ years of Experience
~ Has Built a Data Warehouse from scratch using SSIS and Advanced SQL
~ SSIS
~ Advanced SQL (T-SQL):
~ Complex Joins
~ Performance Tuning and Debugging
~ Sub Queries
~ Common Table Expressions
~ How to use different types of Indexes
~ Understanding differences with Key types
~ How to use different Operators within Data Tables
~ Data Warehousing
~ How to use different Dimension Tables
~ How to use different Fact Tables
~ Snowflake
~ Data Modeling
~ STAR Schema
~ Kimball Architecture


Technical Requirements:-
SQL :
Strong understanding of complex joins
Performance tuning and debugging skills
Sub queries
Common table expression
ETL/ELT :
Experience with SSIS
End-to-end data loading and extraction in data warehousing
How do build a data warehouse from scratch (including data modeling techniques) how do we design table how do we come up with ETL
Data Architecture :
Familiarity with STAR schema and Snowflake
Understanding of Kimball methodology
Experience with different fact and dimension tables
Performance tuning strategies for large datasets
Data storage strategies for large-scale data
Data Modeling :
Experience in data modeling and ELT architecture
Understanding of subject areas created
Tools & Languages :
Qlik Compose (willing to train)
.NET or Python (preferred)



  • Fairfield, CA, United States RIT Solutions, Inc. Full time

    Sr. Data Warehouse ETL Developer 1. Hybrid - 2 days in Fairfield, CA 2. Remote in CA - open to travel to be onsite for critical meetings Candidates must come from a medical/healthcare background o Qlik Compose Development o Configuring tasks o Monitoring tasks • Qlik Replicate experience • dvanced SQL: o Need to know complex joins o Sub queries o...


  • Fairfield, CA, United States RIT Solutions, Inc. Full time

    Sr Data Warehouse ETL Developer 4-6 months to start + CTH While on Contract: Hybrid - 2 days in Fairfield, CA Remote in CA - open to travel to be onsite for critical meetings When converted or if we place direct: Required - Hybrid - 2 days in Fairfield, CA Compose experience: Qlik Compose Development Configuring tasks Monitoring tasks ...


  • Fairfield, CA, United States RIT Solutions, Inc. Full time

    Sr Data Warehouse ETL Developer 4-6 months to start + CTH While on Contract: Hybrid - 2 days in Fairfield, CA Remote in CA - open to travel to be onsite for critical meetings When converted or if we place direct: Required - Hybrid - 2 days in Fairfield, CA Compose experience: Qlik Compose Development Configuring tasks Monitoring tasks ...


  • Fairfield, California, United States Steneral Consulting Full time $120,000 - $180,000 per year

    **SSIS Data Warehouse EngineerFairfield, CA (Hybrid Role)6-12+Months**Design, build, and maintain data warehouses from scratch using SSIS and advanced SQL (T-SQL).Develop, monitor, and support ETL jobs, ensuring daily performance and error tracking.Perform advanced SQL tasks including complex joins, subqueries, common table expressions, performance tuning,...


  • Westlake Village, CA, United States Private National Mortgage Acceptance Company, LLC Full time

    Overview Pennymac (NYSE: PFSI) is a specialty financial services firm with a comprehensive mortgage platform and integrated business focused on the production and servicing of U.S. mortgage loans and the management of investments related to the U.S. mortgage market. At Pennymac, our people are the foundation of our success and at the heart of our dynamic...


  • Thousand Oaks, CA, United States PennyMac Full time

    PENNYMAC Pennymac (NYSE: PFSI) is a specialty financial services firm with a comprehensive mortgage platform and integrated business focused on the production and servicing of U.S. mortgage loans and the management of investments related to the U.S. mortgage market. At Pennymac, our people are the foundation of our success and at the heart of our dynamic...


  • Fairfield, United States Partnership HealthPlan of California Full time

    Overview Responsible for the development of all processes necessary to complete all phases of the Enterprise Data Warehouse (EDW). This includes source identification, data collection, data transformation, normalization, rule administration, error detection and correction, data consolidation, data storage, data distribution, schema mapping, data enrichment,...


  • Fairfield, CA, United States Partnership HealthPlan of California Full time

    Overview Responsible for the development of all processes necessary to complete all phases of the Enterprise Data Warehouse (EDW). This includes source identification, data collection, data transformation, normalization, rule administration, error detection and correction, data consolidation, data storage, data distribution, schema mapping, data enrichment,...


  • Fairfield, CA, United States Tek Leaders Inc Full time

    Job Title: Sr Data Center Engineer Location: Fairfield, CA Duration: 3 month contract – possibility to extend Interview Schedule: One video/one on-site Note: on-prem data center expertise required Top "Must-Have" Skillsets These are core, non-negotiable technical capabilities required to perform the role effectively: 7+ years of experience supporting...


  • Sacramento, CA, United States Rivian Full time

    About Rivian Rivian is on a mission to keep the world adventurous forever. This goes for the emissions-free Electric Adventure Vehicles we build, and the curious, courageous souls we seek to attract. As a company, we constantly challenge what's possible, never simply accepting what has always been done. We reframe old problems, seek new solutions and operate...