Data Warehouse ETL Developer

Artifintech; Fairfield (CA); Vor Ort; USD 120.000 - 180.000; Vollzeit

Zusammenfassung

ARTIFICIAL INTELLIGENCE TECHNOLOGIES LLC in California is seeking a senior Data Engineer to monitor production jobs, optimize SQL workflows, and support data-rich healthcare projects. The role emphasizes reliability, performance, and security in a fast-paced environment.

You'll modify ETL tasks, add tables and transforms, and help upgrade core data pipelines while tracking latencies and ensuring robust data quality across systems.

Qualifikationen

• Advanced SQL required with complex joins, subqueries, and CTEs.
• 8–10 years of senior-level experience in analytics or data engineering.
• Experience with SSIS and data warehousing automation tools is preferred.

Aufgaben

• Monitor production jobs configured in the system daily for errors.
• Modify tasks to add tables and transforms as needed.
• Maintain core structures during upgrades and implement security related tasks, monitor latencies.

Kenntnisse

Advanced SQL

Complex joins

Subqueries

Performance tuning

SSIS

Tools

SSIS

Data warehousing tools

Jobbeschreibung

• 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

ARTIFICIAL INTELLIGENCE 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. ARTIFICIAL INTELLIGENCE 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 ARTIFICIAL INTELLIGENCE 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