Data Warehouse ETL Developer

Cloud Analytics Technologies, LLC; Fairfield (CA); On-site; USD 100,000 - 130,000; Full time

Job summary

A leading data analytics firm is seeking a talented individual to monitor and modify jobs in their analytics platform. Candidates must possess advanced SQL skills and have 8-10 years of senior-level experience. Knowledge in data modeling, particularly within healthcare, along with experience in automation tools, is advantageous. This opportunity promises a dynamic work environment and is open to diverse candidates.

Qualifications

• 8-10 years of experience in a senior-level role.
• Experience in data modeling related to healthcare.
• Familiarity with data warehousing automation tools.

Responsibilities

• Monitor jobs in compose for errors as part of production support.
• Modify tasks to integrate tables and transforms.
• Implement security tasks and oversee system upgrades.

Skills

Advanced SQL

Performance tuning techniques

Debugging skills

SSIS

Job description

Responsibilities

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

Qualifications

(Must haves)

• Advanced SQL: complex joins, subqueries, common table expressions, performance tuning techniques, 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

Equal Opportunity Employer

CLOUD ANALYTICS 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. CLOUD ANALYTICS 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 CLOUD ANALYTICS 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