Data Warehouse ETL Developer

Valiant Technologies LLC; Fairfield (CA); On-site; USD 120,000 - 180,000; Full time

Job summary

VALIANT TECHNOLOGIES LLC is seeking a senior data engineering professional to monitor and optimize production job configurations. The role involves tracking daily tasks and implementing improvements across the data pipeline.

The ideal candidate will have 8-10 years of experience, expert SQL skills (complex joins, subqueries, CTEs), and SSIS proficiency. Familiarity with data modeling in healthcare data warehousing is a plus.

Qualifications

• Senior level with 8-10 years of experience.
• Advanced SQL with complex joins, subqueries, and CTEs.
• Performance tuning techniques.
• Good debugging skills.
• SSIS experience.

Responsibilities

• Monitor daily jobs configuring in compose to track for errors.
• Modify tasks to add tables and transforms.
• Maintain core structure upgrades and implement security-related tasks.
• Monitor latencies and overall performance.

Skills

Advanced SQL

Good debugging skills

Performance tuning

Tools

SSIS

Job description

• Monitoring the jobs that are configuring in compose to track on a daily basis for any errors (more like a productions support
• Modify tasks to add tables and transforms
• Maintain core structure upgrades, implementing security related tasks, monitoring latencies,

Top Requirements

(Must haves)

• Advanced SQL:
  • Need to know complex joins
  • Sub queries
  • Common table expression
  • Performance tuning techniques
  • Good debugging skills
  • SSIS
• Senior Level 8-10 years of experience

Additional Qualifications

(Nice to Haves)

• Data Modeling Experience
  • Architecture
  • What Kind of Data Modeling What is the subject? Healthcare
• Worked on data warehousing automation tools

VALIANT TECHNOLOGIES LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. VALIANT TECHNOLOGIES LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will VALIANT TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract