Data Warehouse ETL Developer

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

Job summary

ETHEREUM TECHNOLOGIES LLC is seeking a Senior Data Engineer to monitor and optimize data pipelines in a production environment. The role focuses on advanced SQL, complex joins, and data modeling to support healthcare data needs.

You will work with SSIS for data integration, implement security-related tasks, and monitor latencies to ensure reliable reporting. The position requires 8–10 years of experience in a senior data/ETL role, with a strong debugging capability and experience in data

Qualifications

• Advanced SQL with complex joins and sub queries.
• Experience with CTEs and performance tuning.
• Strong debugging skills and data quality mindset.
• Proficiency with SSIS for data integration.

Responsibilities

• Monitor jobs configured in compose to track daily errors.
• Modify tasks to add tables and transforms.
• Maintain core data warehouse structure upgrades and implement security tasks.
• Monitor latencies and optimize data pipelines.

Skills

Advanced SQL

Complex joins

Sub queries

Common table expressions

Performance tuning

Debugging skills

SSIS

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

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