Senior Data Warehouse ETL Developer - SQL/SSIS Expert

Artifintech; Fairfield (CA); On-site; USD 120,000 - 180,000; Full time

Job summary

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.

Qualifications

• 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.

Responsibilities

• 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.

Skills

Advanced SQL

Complex joins

Subqueries

Performance tuning

SSIS

Tools

SSIS

Data warehousing tools

Job description

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.