Sr. Data Warehouse
2 days ago
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)
-
Sr. Data Warehouse ETL Developer
19 hours ago
Fairfield, CA, United States RIT Solutions, Inc. Full timeSr. 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...
-
Sr Data Warehouse ETL Developer
3 days ago
Fairfield, CA, United States RIT Solutions, Inc. Full timeSr 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 ...
-
Sr Data Warehouse ETL Developer
4 days ago
Fairfield, CA, United States RIT Solutions, Inc. Full timeSr 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 ...
-
SSIS Data Warehouse Engineer
4 days ago
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,...
-
Sr Data Platform Engineer
4 weeks ago
Westlake Village, CA, United States Private National Mortgage Acceptance Company, LLC Full timeOverview 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...
-
Sr Data Platform Engineer
3 weeks ago
Thousand Oaks, CA, United States PennyMac Full timePENNYMAC 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...
-
Senior Data Warehouse ETL Developer
3 weeks ago
Fairfield, United States Partnership HealthPlan of California Full timeOverview 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,...
-
Senior Data Warehouse ETL Developer
6 days ago
Fairfield, CA, United States Partnership HealthPlan of California Full timeOverview 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,...
-
Sr Data Center Engineer
1 day ago
Fairfield, CA, United States Tek Leaders Inc Full timeJob 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...
-
Sr. Warehouse Associate
3 weeks ago
Sacramento, CA, United States Rivian Full timeAbout 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...