Job Description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Data Warehouse Analyst, Senior

Full-time Staff French Camp, CA, US

30+ days ago Requisition ID: 1199

Salary Range: $114,000.00 To 167,000.00 Annually

The expected pay range is based on many factors such as geography, experience, education, and the market. The range is subject to change.

Remote position - must reside in California.

What You Will Be Doing:

Under direct supervision, responsible for completing service requests per user specifications, and leading the design and monitoring of the data warehouse.

Must have SQL, SSIS, and Python experience. 

• Leads and participates in resolving service requests by collecting system/business reporting and/or data requirements by interviewing stakeholders, identifying project scopes, and acting as the liaison between cross functional teams.
• Documents data warehouse business rules for collection, aggregation, standardization and validation of data via documented standards and guidelines.
• Develops and prepares reports that efficiently and effectively fulfill the agreed upon requirements.
• Makes recommendations for or identifies appropriate data sourcing, relative to the system of record in order to ensure data integrity/accuracy.
• Conducts data profiling to understand data relationships and recommends conforming logic.
• Conducts data modeling and maintains data models.
• Maintains templates for capturing metadata.
• Conducts and/or participates in peer review activities within the team as needed.
• Builds ETL (extract, transform, and load) packages to move data from one area to the next.

What You Bring:

Required

• Produces work that is accurate and complete.
• Produces the appropriate amount of work.
• Actively learns through experimentation when tackling new problems, using both successes and failures to learn.
• Rebounds from setbacks and adversity when facing difficult situations.
• Knows the most effective and efficient process to get things done, with a focus on continuous improvement.
• In-depth knowledge of leading software products and technologies pertaining to data warehousing and reporting with demonstrated experience in creating star schema data models.
• In-depth knowledge of database and data warehouse design concepts with demonstrated experience in Bill Inmon or Ralph Kimball data warehouse approach.
• In-depth knowledge of relational databases, with the ability to perform normalization and denormalization.
• In-depth knowledge of SQL Server query development with demonstrated experience in data profiling and SQL report creation.
• Strong experience with a report development application, such as SSRS.
• Strong experience with ETL development applications, including SSIS.
• In-depth experience documenting technical specifications with demonstrated experience using standards such as IEEE.
• In-depth knowledge of the software development life cycle with demonstrated experience in unit, integration and regression testing of deliverables.
• Strong analytical and problem-solving skills.
• Strong knowledge of the role of a Data Governance program in particular for data warehousing and for the business in general.
• Ability to establish and maintain effective and collaborative working relationships with individuals at all levels.
• Ability to effectively communicate complex technical issues to technical and non-technical audiences, make presentations and write technical specifications.
• Time management and organizational skills. Uses time effectively and efficiently. Values time. Concentrates his/her efforts on the more important priorities. Can attend to a broader range of activities. Meets deadlines.
• Strong customer service skills, with the ability to meet with and document customer requests and deliver accurately and timely on requests.
• Interpersonal skills - interacts effectively with individuals both inside and outside of HPSJ; relates openly and comfortably with diverse groups of people.
• Capable of championing data governance principles, developing and overseeing data governance policies and leading data governance activities.
• Ability to work independently and as part of a team.
• Ability to work flexible and/or extended hours as needed.
• Ability to speak and be understood in English.
• Ability to handle confidential information with appropriate discretion.

Preferred

• Strong knowledge of health care with demonstrated experience in healthcare specific computer hardware and software.
• Strong knowledge of health care information system with demonstrated experience reporting from systems such as QNXT claims payment system.
• Strong knowledge in managed care.
• Strong knowledge in the Agile Scrum development framework.
• Strong knowledge in a diagraming software application such as Microsoft Visio, with ability to create data/process flow diagrams from business requirements.

What You Have:

Education and Experience

Required

• Bachelor’s degree in Computer Science; Management Information System; Computer Information System; Applied Mathematics.
• At least eight years of data warehouse development and programming experience.
• Equivalent combination of education and experience.

Preferred

• Experience in a health care environment.

What You Will Get:

HPSJ Perks:

• Competitive salary
• Robust and affordable health/dental/vision with choices in providers
• Generous paid time off (starting at 3 weeks of PTO, 4 paid floating holidays including employee’s birthday, and 9 paid holidays)
• CalPERS retirement pension program, automatic employer-paid retirements contributions, in addition to voluntary defined contribution plan
• Two flexible spending accounts (FSAs)
• Employer-Paid Term Life and AD&D Insurance
• Employer-Paid Disability Insurance
• Employer-Paid Life Assistance Program
• Health Advocacy
• Supplemental medical, legal, identity theft protection
• Access to exclusive discount mall
• Education and training reimbursement in addition to employer-paid elective learning courses.
• A chance to work for an organization that is mission-driven – our members and community are at the core of everything we do.
• A shorter commute – if you’re commuting from the Central Valley to the Bay Area.
• Visibility and variety – you have a chance to work with people at all levels of the organization, and work on diverse projects.

Our Vision:

Continuously improve the health of our community.

Our Mission:

We provide healthcare value and advance wellness through community partnerships.

We are an equal opportunity employer and diversity is one of our core values. We believe that differences including race, ethnicity, gender, sexual orientation and other characteristics, will help us create a strong organization that is sensitive to the needs of those we serve. Employment decisions are made on the basis of qualifications and merit.

HPSJ provides equal employment opportunities to employees and applicants for employment and prohibits discrimination based on color, race, gender (including gender identity and gender expression), religion (including religious dress and grooming practices), marital status, registered domestic partner status, age, national origin (including language use) or ancestry, physical or mental disability, medical condition (including cancer and genetic characteristics), sex (including pregnancy, childbirth, breastfeeding or related medical condition), genetic information, sexual orientation, military or veteran status, political affiliation or any other characteristic made unlawful by applicable Federal, State or local laws. It also prohibits unlawful discrimination based on the perception that anyone has these characteristics, or is associated with anyone who has or is perceived to have these characteristics.

Job Tags

Similar Jobs