An R / Python Data Engineer, will be responsible for developing, maintaining, and improving data pipelines that integrate a variety of data sources, including APIs, databases, and shared network drives. The developer will work alongside a team of data analysts and developers, primarily experienced in R, to introduce robust Python-based ETL processes into our data infrastructure.

This individual contributor is primarily responsible for driving strategic data-informed decisions, gathering data and information on targeted variables in an established systematic fashion, preparing data for analytic efforts, and interpreting data analyses. This position executes creative data analytic approaches leading to actionable outcomes, develops, implements, and automates business and reporting solutions, and develops analytical and/or statistical models enabling informed business decisions.

Essential Responsibilities:

• 
  
• Design, implement, and maintain data pipelines leveraging multiple data sources.
• 
  
• Ensure the optimization, scalability, and resilience of data extraction, transformation, and load (ETL) processes.
• 
  
• Manage and maintain on-prem data infrastructure, ensuring high availability, security, and performance.
• 
  
• Collaborate with data analysts and developers to understand data needs and deliver efficient solutions.
• 
  
• Contribute to and advocate for coding best practices, robust documentation, and continuous improvement in data engineering practices.
• 
  
• Work closely with geospatial datasets and tools, ensuring efficient and accurate processing of spatial data.
• 
  
• Practices self-development and promotes learning in others by proactively providing information, resources, advice, and expertise with coworkers and customers; building relationships with cross-functional stakeholders; influencing others through technical explanations and examples; adapting to competing demands and new responsibilities; listening and responding to, seeking, and addressing performance feedback; providing feedback to others; creating and executing plans to capitalize on strengths and develop weaknesses; supporting team collaboration; and adapting to and learning from change, difficulties, and feedback.
• 
  
• Completes work assignments and supports business-specific projects by applying expertise in subject area; supporting the development of work plans to meet business priorities and deadlines; ensuring team follows all procedures and policies; coordinating resources to accomplish priorities and deadlines; collaborating cross-functionally to make effective business decisions; solving complex problems; escalating high priority issues or risks as appropriate; and recognizing and capitalizing on improvement opportunities.
• 
  
• Executes creative data analytic approaches leading to actionable outcomes by defining and calculating metrics to be analyzed; defining, calculating, and validating algorithms; and conducting analyses, including descriptive, correlational, inferential, and/or predictive statistics.
• 
  
• Develops, implements, and automates business and reporting solutions by working with stakeholders in their design, planning, and implementation while ensuring consistency and coherency; evaluating and summarizing data and results; creating summary statistics; developing data reports, visualizations, and/or interactive Business Intelligence (BI) reports; reporting to stakeholders on key findings; identifying needs for the development and implementation of additional reporting solutions; and preparing documentation as appropriate.
• 
  
• Interprets data analyses by applying findings to contextual settings; and developing insights, reports, and presentations telling a compelling story to stakeholders to enable and influence decision making; and providing context related to data interpretations and/or limitations as appropriate.
• 
  
• Drives strategic data-informed decisions by consulting with clients to identify and clarify key business needs; developing outcomes and process measures; translating business requirements; determining data/information needs and data collection methods; developing analysis plans; measuring the impact of business decisions on clients, customers, and/or members; working with clients and staff to identify opportunities and methods to improve efficiencies with analysis; supporting and training end-users; and documenting processes and deliverables.
• 
  
• Gathers data and information on targeted variables in an established systematic fashion by validating data sources; querying, merging, and extracting data across sources; completing routine data refresh and update; developing and/or delivering tools for electronic data collection; and providing user training, support, and documentation.
• 
  
• Develops analytical and/or statistical models enabling informed business decisions by determining data and analytical requirements; creating models leading to actionable insights; and testing, refining, and validating models.
• 
  
• Prepares data for analytic efforts by integrating and consolidating data; ensuring data quality and accuracy; profiling data inaccuracies and recommending process improvements or system changes to enhance overall quality of the data; and cleaning and creating final data set(s) for analysis.
• 
  

Minimum Qualifications:

• Minimum one (1) year experience in a leadership role with or without direct reports.
• Bachelors degree in Mathematics, Statistics, Engineering, Social/Physical/Life Science, Business, or related field and Minimum five (5) years experience in data analytics or a directly related field. Additional equivalent work experience in a directly related field may be substituted for the degree requirement.

Additional Requirements:

• Knowledge, Skills, and Abilities (KSAs): Negotiation; Business Planning; Written Communication; Data Extraction; Data Mining; Data Visualization Tools; Statistical Programming Language; Relational Database Management; Vendor Management; Project Management

Preferred Qualifications:

• Two (2) years project management experience.
• Two (2) years experience in process improvement.
• Strong proficiency in Python with a focus on data pipeline and package development.
• Experience with Dagster or other modern data orchestration tools.
• Knowledge of SQL databases like PostgreSQL, SQL Server, and Oracle.
• Proficient with version control tools like Git and platforms like GitHub, employing a feature-branch workflow.
• Familiarity with project and documentation tools such as Jira and Confluence.
• Familiarity with R is a plus, especially concerning geospatial data processing.
• Experience with geospatial tools and libraries, including but not limited to PostGIS, GeoPandas, Fiona, Shapely, GDAL, ArcGIS, ArcPy, leaflet, and sf.
• Ability to translate business logic written in SAS into Python code is also a plus.

Primary Location: California,Oakland,Kaiser Center

Additional Locations:

East Annex - Parsons, 75 N. Fair Oaks Ave., Pasadena,California, 91103

Regional Office - 9 Piedmont, 9 Piedmont Center 3495 Piedmont Rd. NE, Atlanta,Georgia, 30305

Rockville Regional Offices, 2101 E. Jefferson St., Rockville,Maryland, 20852

Waterpark I, 2500 S. Havana St., Aurora,Colorado, 80014

California Service Center - Rio S.D., 8954 Rio San Diego Dr., San Diego,California, 92108

Multnomah St. Parking Structure, 500 NE Multnomah St. @ 7th Ave., Portland,Oregon, 97232

Northwest DC Medical Offices, 2301 M St. NW, Washington,Dist of Columbia, 20037

Alexandria Medical Center, 3000 Potomac Ave., Alexandria,Virginia, 22305

Renton Administration - Adams, 2921 Naches Ave. SW, Renton,Washington, 98057

Scheduled Weekly Hours: 40

Shift: Day

Workdays: Mon, Tue, Wed, Thu, Fri

Working Hours Start: 08:00 PM

Working Hours End: 05:00 PM

Job Schedule: Full-time

Job Type: Standard

Employee Status: Regular

Employee Group/Union Affiliation: NUE-PO-01|NUE|Non Union Employee

Job Level: Individual Contributor

Specialty: Data Analytics & Reporting

Department: Po/Ho Corp - Ntl Provider Contracting-Proj - 0315

Pay Range: $124400 - $161040 / year

The ranges posted above reflect the location in the job posting. The salary range may vary if you reside in a different location or state than the location posted.

Travel: No

At Kaiser Permanente, equity, inclusion and diversity are inextricably linked to our mission, and we aim to make it a part of everything we do. We know that having a diverse and inclusive workforce makes Kaiser Permanente a better place to receive health care, a more supportive partner in our communities we serve, and a more fulfilling place to work. Working at Kaiser Permanente means that you agree to and abide by our commitment to equity and our expectation that we all work together to create an inclusive work environment focused on a sense of belonging and wellbeing.

Kaiser Permanente is an equal opportunity employer committed to a diverse and inclusive workforce. Applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy), age, sexual orientation, national origin, marital status, parental status, ancestry, disability, gender identity, veteran status, genetic information, other distinguishing characteristics of diversity and inclusion, or any other protected status.