Job Summary

Responsible for performing tasks related to project completion including analysis, testing, documentation, problem resolution, and implementation of solutions as they apply to the organization's strategy. Responsible for performing tasks related to report development including requirements gathering, specification and definition documentation, design, testing, validation, analysis, and maintenance for all reporting projects.

Job Duties

• Gathers requirements and defines scope independently on projects of all size.

• Supports Associate and Intermediate analysis in this task across projects.

• Facilitates gathering scope in large projects across multiple analysts.

• Plans projects and provides time and effort estimates based on requirements gathering.

• Assists other analysts as needed in project planning and time and effort estimation.

• Builds solution architecture for both business intelligence and data project work.

• Locate and identify data needed, profiles to determine quality and appropriateness, understands necessary manipulation and relationships to be established, and recognizes how to transform the data set to establish what is needed for next stage BI and reporting.

• Deliver clear requirements for requests to perform ETL from other team members.

• Mastery of data literacy - able to identify and derive key insights from data.

• Educate others on key data literacy concepts.

• Responsible for following data governance and stewardship practices as defined.

• Performing documentation and discovery associated with these initiatives.

• Identifying data quality issues while performing data profiling and testing and validation.

• Able to act as a data steward and resolve issues or work with appropriate parties to have issues resolved and documented.

Work is typically performed in an office environment. Accountable for satisfying all job specific obligations and complying with all organization policies and procedures. The specific statements in this profile are not intended to be all-inclusive. They represent typical elements considered necessary to successfully perform the job.

*Relevant experience may be a combination of related work experience and degree obtained (Associate’s Degree = 2 years; Bachelor’s Degree = 4 years, Master's Degree = 6 years).

Position Details

• Ideal candidate is proficient with SQL, Tableau, and Epic EHR Clarity Database

• Ability to discover insights in large and complex data sets and proactively anticipates business needs

• Strong SQL experience including joins and subqueries, pivots, aggregate functions, query optimization, etc.

• Mentors junior analysts on technical concepts including SQL query performance/validation and visualization concepts

Education

High School Diploma or Equivalent (GED)- (Required)

Experience

Minimum of 8 years-Relevant experience* (Required)

Certification(s) and License(s)

OUR PURPOSE & VALUES: Everything we do is about caring for our patients, our members, our students, our Geisinger family and our communities. KINDNESS: We strive to treat everyone as we would hope to be treated ourselves. EXCELLENCE: We treasure colleagues who humbly strive for excellence. LEARNING: We share our knowledge with the best and brightest to better prepare the caregivers for tomorrow. INNOVATION: We constantly seek new and better ways to care for our patients, our members, our community, and the nation. SAFETY: We provide a safe environment for our patients and members and the Geisinger family We offer healthcare benefits for full time and part time positions from day one, including vision, dental and domestic partners. Perhaps just as important, from senior management on down, we encourage an atmosphere of collaboration, cooperation and collegiality. We know that a diverse workforce with unique experiences and backgrounds makes our team stronger. Our patients, members and community come from a wide variety of backgrounds, and it takes a diverse workforce to make better health easier for all. We are proud to be an affirmative action, equal opportunity employer and all qualified applicants will receive consideration for employment regardless to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or status as a protected veteran.

We are an Affirmative Action, Equal Opportunity Employer Women and Minorities are Encouraged to Apply. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of disability or their protected veteran status.