Overview

The Data Engineer Consultant helps build and maintain enriched data infrastructure to improve and strengthen Northwest Permanente's capabilities in using data to drive analytical thinking, storytelling, and decision-making to support the design, development, and optimization of scalable data solutions and workflows within our administrative systems. The Engineer will partner with department leaders and system analysts to manage small to medium cross departmental projects and provides technical leadership. The ideal candidate operates with an agile mindset, employs customer-centered thinking and strong consultative services, and leverages innovative solutions to deliver value in a fast-paced, deadline-driven environment. This is a hybrid position that is a blend of working both remotely and in office.Primary Responsibilities:

• Utilize strong consulting skills to work across multiple departments to collect, document and translate business requirements into technical solutions.
• Create conceptual, logical, and physical data models for both relational and dimensional solutions.
• Generate data dictionaries to document data lineages, data definitions, transformations, and metadata for data infrastructure projects; identifies and reconciles inconsistencies in data definitions; takes steps to assure metadata accuracy and validity.
• Utilize deep knowledge of systems, database management and applications to translate business requirements and functional specifications into physical program designs, code modules, stable and reliable data solutions. Design solutions for optimizations and coordinate with system vendors to plan, design, test and implement solutions to meet business needs.
• Applies knowledge of relational database skills including advanced SQL knowledge and the ability to create complex queries and stored procedures.
• Partners with department leaders and technical resources to ensure that data engineering workflows are thoroughly tested by implementing reliable error/exception handling and rollback mechanisms.
• Performs unit testing, system integration testing, and assist with user acceptance testing to ensure data integrity and process reliability.
• Maintains data integrity and quality by developing robust data workflows, establishing and enforcing data standards, and perform data mapping and documentation, generate diagrams and entity-relationship models. This includes generating reports, creating schedules, defining work processes, and developing maintenance procedures.
• Assists in efforts to facilitate, analyze, design, and execute architecture solutions and ensure solutions are leveraged; assists in creating documents and communicates the integration approach for components of the solution.
• Creates Extract, Transform, Load (ETL) design, development, and processes.
• Engage knowledge of current data security guidelines for handling data in flight and data at rest.
• Assists in efforts to identify and design solutions that allow performing root cause analyses to enable proactive issue resolution and data quality maintenance; assists in efforts to build processes and diagnostics tools/measures into the development process so that data pipelines can be monitored, and issues detected proactively.
• Documents programming changes and design, system modifications and their associated maintenance.
• Assists in executing strategies and plans for data security, backup, recovery, business continuity, and archiving.
• Perform Database upgrades, patching, tuning and indexing and support database troubleshooting and recovery due to failures.
• Collaborates with department leaders to develop opportunities for data reuse, migration, or retirement.
• Works closely with Business Analysts, Data Engineers, Application owners and technology SMEs both inside and out of the organization.
• Practices self-leadership and promotes learning in others by soliciting and acting on performance feedback.

Qualifications:

• Bachelor's degree in Computer Information Systems, Computer Science, or related field.
• Four (4) years of experience in IT with a broad range of exposure to all aspects of business planning, systems analysis, application development, and/or data warehouse development using Software Development Life Cycle (SDLC) methodologies.
• Four (4) years data analytical experience.
• Two (2) years of hands-on experience in custom or structured (e.g., Informatica, Business Objects Data Integrator, etc.) ETL design, implementation, and maintenance such as using Oracle, PL/SQL, SQL, SAS, Linux, SFTP, and TCP/IP.
• Two (2) years of hands-on experience in using web services and APIs to retrieve and integrate data, with in-depth knowledge of JSON, XML, REST, and/or SOAP.
• Two (2) years of hands-on experience in architecture, data modeling, and implementation of the enterprise data solutions.
• Strong creative thinking skills with demonstrated ability to work with ambiguity.
• A consultant mindset, critical thinking and problem-solving skills.
• Experience working with relational databases, data extraction and manipulation language, and programming.
• Knowledge of architecture principles and techniques across master data, transaction data and derived/analytic data.
• Experience in requirement gathering, leading data analysis reviews, and documenting specifications.

For more information about this position, contact Marisa Walter, marisa.e.walter@kp.org.About Northwest Permanente:We are the Permanente in Kaiser Permanente. Northwest Permanente is a self-governed, multi-specialty group of 1,500 physicians, clinicians, and administrative professionals caring for 630,000 members in Oregon and Southwest Washington. Together with Kaiser Foundation Health Plans and Kaiser Foundation Hospitals, we form Kaiser Permanente of the Northwest, an integrated health care program. Kaiser Permanente is one of the nation's preeminent health care systems, a benchmark for comprehensive, integrated, value-based, and high-quality care.Our Northwest Permanente administrative professionals enjoy a wide range of company sponsored benefits:

• 15% employer contribution to retirement programs, including pension
• 90% employer-paid health plan
• Tuition Reimbursement
• Child Care Benefits
• Flexible Work Schedules
• Paid Parental Leave
• Self-Care Days + Paid Time Off

Equal Opportunity EmployerAt Northwest Permanente, we are committed to providing an environment of mutual respect where equal employment opportunities are available to all applicants without regard to race, color, religion, sex, pregnancy (including childbirth, lactation, and related medical conditions), national origin, age, physical and mental disability, marital status, sexual orientation, gender identity, gender expression, genetic information (including characteristics and testing), military and veteran status, and any other characteristic protected by applicable law. Northwest Permanente believes that equity, inclusion, and diversity among our employees are critical to our success, and we seek to recruit, develop, and retain the most talented people from a diverse candidate pool.