Previous Job
Previous
Sr. Data Warehouse ETL Developer
Ref No.: 18-13757
Location: El Segundo, California
Who does this position report to?
Can sit in LA or Denver

OVERVIEW OF POSITION:
Responsible for the Data Warehouse and Informatics functions for HealthCare Partners (HCP). Works with business users to define and develop solutions for the company through the use of our data assets. Designs, develops and implements various reporting and analysis solutions. Ensures improved data-based decision-making capability across HCP.

ESSENTIAL FUNCTIONS:
Designs and writes SQL scripts, stored procedures, and user defined functions.
Responsible for entire ETL process of transforming, cleaning, and standardizing data and metadata so it can be loaded into a data warehouse or data mart.
Consistently exhibits behavior and communication skills that demonstrate HealthCare Partners' (HCP) commitment to superior customer service, including quality, care and concern with each and every internal and external customer.
Builds data warehouse infrastructure including complex data models and strategic data sets and databases.
Specifies the creation of content in support of internal and external customers for data and information.
Interacts with company leadership as required to facilitate the development of strategic data sets for the organization.
Ensures the reliability and timeliness of the data warehouse systems and underlying technologies.
Develops solutions to streamline business processes to achieve departmental and company-wide goals more effectively and efficiently.
Communicates status, problems, resolutions, etc. on projects and assignments.
Contributes skills and knowledge to other database and reporting projects as determined by management.
Directs the work of other staff and serves as a mentor to junior staff.
Uses, protects, and discloses HCP patients' protected health information (PHI) only in accordance with Health Insurance Portability and Accountability Act (HIPAA) standards.
Performs additional duties as assigned.

EDUCATION:
Bachelor's degree from a four-year college and/or a professional certification requiring formal education beyond a two-year college.

EXPERIENCE:

Minimum:
A minimum of three years of experience with Microsoft SQL Server or ORACLE including database design and writing SQL scripts.
Hands on experience with integration tools such as SSIS or Informatica
Strong background in Business Analysis including supporting the design of new Production systems or system enhancements to existing systems.

Preferred:
5 years of analytical/planning experience in healthcare.

KNOWLEDGE, SKILLS, ABILITIES:
Specialization with related databases, architecture and implementation of data models and database designs, data access and table maintenance codes.
Understanding of data warehouse methodology.
Demonstrated achievement in building a research and analysis function.
Excellent presentation skills.
Excellent written and verbal communications skills.

We offer a competitive salary and benefits program including Health, Dental, Vision, employer-matching 401(k), Continuing Education, Tuition Reimbursement, free Basic Life and AD&D insurance, company paid Long Term Disability, a generous Paid Time Off schedule, and more.

Client manages and operates medical groups and affiliated physician networks in California, Colorado, Florida, Nevada, New Mexico, Pennsylvania and Washington. A leading independent medical group in America, Client has over two decades of experience providing coordinated, outcomes-based medical care in a cost-effective manner. As of June 30, 2017, Client's teammates, employed clinicians and affiliated clinicians provided care for approximately 1.7 million patients. Client's leadership development initiatives and social responsibility efforts have been recognized by Fortune, Modern Healthcare, Newsweek and WorldBlu.

What are the 3-4 non-negotiable requirements on this position?
At least 5-7 years of SSIS Development experience At least 5 years of healthcare industry experience At least 3-5 years of project lead/technical lead experience

What are the nice-to-have skills?
A minimum of three years of experience with Microsoft SQL Server or ORACLE including database design and writing SQL scripts. Hands on experience with integration tools such as SSIS or Informatica Strong background in Business Analysis including supporting the design of new Production systems or system enhancements to existing systems.

What is exciting about this opportunity?
We are in the process of merging with other Client. There will be numerous opportunities for internal advancement once the merger is complete.