Principle Data Warehouse Engineer

Kaiser Permanente Renton , WA 98055

Posted 2 months ago

Description:

In addition to the responsibilities listed below, this position is responsible for designing and building middleware solutions. Some of the unique challenges this position will face include designing solutions across heterogeneous environments and understanding and communicating about the different layers of technology involved.

Health Plan data preparation is performed in the Enterprise Data Warehouse (EDW) as a service for our Health Plan Business Team. Complex SQL queries are commonly used in performing business data analysis within the EDW on our Teradata platform, housing the subject areas, such as Enrollment, Claims, Referrals, Pharmacy, Encounters, Provider, and Lab, that are used across the KP Enterprise for reporting and analytics. Our engineers are generalists and have the opportunity to work in a highly technical data warehouse environment while also gaining and demonstrating business expertise and supporting our clinical partners in decision making.

Essential Responsibilities:

  • Conducts or oversees business-specific projects by applying deep expertise in subject area; promoting adherence to all procedures and policies; developing work plans to meet business priorities and deadlines; determining and carrying out processes and methodologies; coordinating and delegating resources to accomplish organizational goals; partnering internally and externally to make effective business decisions; solving complex problems; escalating issues or risks, as appropriate; monitoring progress and results; recognizing and capitalizing on improvement opportunities; evaluating recommendations made; and influencing the completion of project tasks by others.

  • Practices self-leadership and promotes learning in others by building relationships with cross-functional stakeholders; communicating information and providing advice to drive projects forward; influencing team members within assigned unit; listening and responding to, seeking, and addressing performance feedback; adapting to competing demands and new responsibilities; providing feedback to others, including upward feedback to leadership and mentoring junior team members; creating and executing plans to capitalize on strengths and improve opportunity areas; and adapting to and learning from change, difficulties, and feedback.

  • As part of the IT Engineering job family, this position is responsible for leveraging DEVOPS, and both Waterfall and Agile practices, to design, develop, and deliver resilient, secure, multi-channel, high-volume, high-transaction, on/off-premise, cloud-based solutions.

  • Provides insight into recommendations for technical solutions that meet design and functional needs.

  • Translates business requirements and functional specifications into physical program designs, code modules, stable application systems, and software solutions by partnering with Business Analysts and other team members to understand business needs and functional specifications.

  • Ensures appropriate translation of business requirements and functional specifications into physical program designs, code modules, stable application systems, and software solutions by partnering with Business Analysts and other team members to understand business needs and functional specifications.

  • Serves as an expert for innovative technical solutions that meet design and functional needs.

  • Facilitates and serves as a technical expert for project teams throughout the release schedule of business and enterprise software solutions.

  • Builds and maintains trusting relationships with internal customers, third party vendors, and senior management to ensure the alignment, buy-in, and support of diverse project stakeholders.

  • Recommends complex technical solutions that meet design and functional needs.

  • Collaborates with architects and/or software consultants to ensure functional specifications are converted into flexible, scalable, and maintainable solution designs.

  • Provides expertise and guidance to team members for systems incident responses for complex issues.

  • Provides implementation and post-implementation triage and support of business software solutions by programming and/or configuring enhancements to new or packaged-based systems and applications.

  • Reviews and validates technical specifications and documentation.

  • Identifies specific interfaces, methods, parameters, procedures, and functions to support technical solutions while incorporating architectural designs.

  • Supports component integration testing (CIT) and user acceptance testing (UAT) for application initiatives by providing triage, attending test team meetings, keeping the QC up-to-date, performing fixes and unit testing, providing insight to testing teams in order to ensure the appropriate depth of test coverage, and supporting the development of proper documentation.

  • Leads systems incident support and troubleshooting for complex and non-complex issues.

  • Identifies specific interfaces, methods, parameters, procedures, and functions, as required, to support technical solutions serving as an escalation point for complex or unresolved issues related to requirements translation.

  • Develops and validates complex testing scenarios to identify application errors and ensure software solutions meet functional specifications.

  • Participates in all software development lifecycle phases by applying comprehensive understanding of company methodology, policies, standards, and internal and external controls.

  • Develops, configures, or modifies basic to moderately complex integrated business and/or enterprise application solutions within various computing environments by designing and coding component-based applications using programming languages.

  • Provides consultation to help ensure new and existing software solutions are developed with insight into industry best practices, strategies, and architectures.

  • Builds partnerships with IT teams and vendors to ensure written code adheres to company architectural standards, design patterns, and technical specifications.

  • Leads the development, validation, and execution of testing scenarios to identify application errors and ensure software solutions meet functional specifications.

  • Leads, mentors, and trains other technical resources to develop software applications.

Minimum Qualifications:

  • Minimum three (3) years experience in middleware development and integration.

  • Minimum five (5) years experience working on project(s) involving the implementation of solutions applying development life cycles (e.g., SDLC).

  • Minimum two (2) years in a technical leadership role with or without direct reports.

  • Bachelor's degree in Computer Science, CIS, or related field and Minimum eight (8) years experience in software development or a related field. Additional equivalent work experience may be substituted for the degree requirement.

Preferred Qualifications:

  • Four (4) years experience in systems analysis, including defining technical requirements and performing high level design for complex solutions.

  • Four (4) years experience with engineering tools such as bug tracking and source code control systems.

  • Three (3) years of IT experience developing and implementing business systems within an organization.

  • One (1) year experience in data modeling and analytics.

  • Three (3) years of development experience with Agile Methodology

  • Three (3) years of development experience on Microsoft Azure

  • Three (3) years of development experience using DevOps

  • Three (3) years of development experience with Informatica

  • Three (3) years of development experience with Linux

  • Three (3) years of development experience with Oracle

  • Three (3) years of development experience with SharePoint

Primary Location: Washington,Renton,Renton Administration

  • Rainier Scheduled Weekly Hours: 40 Shift: Day Workdays: Mon, Tue, Wed, Thu, Fri Working Hours Start: 08:00 AM Working Hours End: 05:00 PM Job Schedule: Full-time Job Type: Standard Employee Status: Regular Employee Group/Union Affiliation: NUE-WA-04|NUE|Non Union Employee Job Level: Individual Contributor Specialty: IT ENG Applications Department: Renton Admin Rainier

  • IT Data Warehouse

  • 1130 Travel: No 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.

External hires must pass a background check/drug screen. Qualified applicants with arrest and/or conviction records will be considered for employment in a manner consistent with federal and state laws, as well as applicable local ordinances, including but not limited to the San Francisco and Los Angeles Fair Chance Ordinances.

Load More

See Additional Requirements >

Share This Job

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Principal Data Engineer Psjh Telecommute

Pacific Medical Centers

Posted 3 weeks ago

VIEW JOBS 1/5/2022 12:00:00 AM 2022-04-05T00:00 Providence St. Joseph Health is calling a Principal Data Engineer PSJH to work remotely within our footprint states: AK, CA, MT, NV, OR, TX and/or WA. We are seeking a Principal Data Engineer PSJH to lead the development of data structures, processes and algorithms using advanced technologies to support population health initiatives. He or she will develop data processing methods for ingesting, processing, storing and reporting in an Azure cloud environment. He or she will work with healthcare claims, Electronic Medical Record (EMR), vendor and other healthcare data. The Principal Data Engineer will also train and oversee the daily work of Data Engineers and establish data standards for the Population Health Informatics team. In this position you will have the following responsibilities: * Lead the design and management of data structures, processes and algorithms to support population health risk arrangements and government programs. * Develop data processing methods for ingesting, processing, storing and reporting with healthcare claims from payers, Electronic Medical Record, vendor, and other healthcare data. * Design, manage and automate DevOps tasks and processes in an Azure cloud environment. * Design, manage and automate using Azure Databricks. * Mentor and train Data Engineers and lead team meetings and projects. * Establish data processing standards for the Pop Health Informatics team. Required qualifications for this position include: * Master's Degree in Health Informatics, MPH, MBA, Statistics, Computer Science or a related field or equivalent education/experience. * 8 years experience querying large datasets using SQL, Java, python and/or scala. * 2 years experience working with one or more of the following cloud-based technologies: Azure, AWS, or Google Cloud. * 3 years experience with Extract, Load, Transform (ELT) technologies like Azure Data Factory or Informatica. * 3 years Data architecture experience, including data ingestion, processing, storage and reporting in a big data environment. Preferred qualifications for this position include: * 2 years experience working with healthcare claims and/or Electronic Medical Record billing data. * Knowledge of Azure cloud, Azure Databricks and CICD tools About the department you will serve. Providence Shared Services provides a variety of functional and system support services for our Providence family of organizations across Alaska, California, Montana, New Mexico, Oregon, Texas and Washington. We are focused on supporting our Mission by delivering a robust foundation of services and sharing of specialized expertise. Pacific Medical Centers Renton WA

Principle Data Warehouse Engineer

Kaiser Permanente