Responsibilities Kforce has a client that is seeking a Senior Data Warehouse ETL Developer in Fairfield, CA. Responsibilities: • Senior Data Warehouse ETL Developer will monitor the jobs that are configuring in compose to track on a daily basis for any errors (more like a productions support • Validate data - quality, accuracy • Modify tasks to add tables and transforms • As a Senior Data Warehouse ETL Developer, you will maintain core structure - upgrades, implementing security related tasks, monitoring latencies • Will be the person coding but also maintaining the infrastructure around Qlik Compose 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) The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future. We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave. Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law. This job is not eligible for bonuses, incentives or commissions. Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status. By clicking “Apply Today” you agree to receive calls, AI-generated calls, text messages or emails from Kforce and its affiliates, and service providers. Note that if you choose to communicate with Kforce via text messaging the frequency may vary, and message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You will always have the right to cease communicating via text by using key words such as STOP.