Data Integration Engineer I/II/III/IV-004293

Summary:

The Data Integration Engineer is responsible for the design, build, unit testing and deployment of the project's data integration components that link various sources of data together. This role works with other teams in the division to develop and maintain data integration standards and architecture. This position ensures implementation of data integration standards across projects/programs. The incumbent works closely with Solution/Data Architects, Platform Architects, Business Intelligence (BI) analysts, Testers, Delivery Leads, and Operations staff to ensure structure and migration of data for successful customer use. This position also assists in project management activities such as project planning, time/effort estimating, and status reporting.

Essential Accountabilities

Level I

• Identifies and resolves personal time management problems at the appropriate level through recognition that time is an asset requiring forward-looking management so that it can be used when available.

• Writes program code/logic according to predefined specifications.

• Ensures the solution follows data integration best practices.

• Acquires specialized knowledge spanning business, systems, data, and technology, developing skills in practical application of specialized knowledge, while growing self-confidence to increase capacity for effective action.

• Tests individual units of source code (sets of one or more computer program modules together with associated control data, usage procedures, and operating procedures) to ensure that code meets design needs and is fit for use.

• Maintains processes that feed data from various systems across the enterprise, ensuring data quality and process efficiency.

• Develops standards, policies and procedures for the form, structure and attributes of the data warehouse tools and systems.

• Participates in rotating on-call support schedule working with Operations team as level 2 support.

• Consistently demonstrates high standards of integrity by supporting the Lifetime Healthcare Companies' mission and values and adhering to the Corporate Code of Conduct and leading to the Lifetime Way values and beliefs.

• Maintains high regard for member privacy in accordance with the corporate privacy policies and procedures.

• Regular and reliable attendance is expected and required.

• Performs other functions as assigned by management.

Level II - in addition to Level I responsibilities:

• Anticipates, identifies and analyzes problems, accepting nothing at face value, instead gaining knowledge through examination of the truth and validity of arguments, classifying the relative importance of ideas, and applying reason, logic and judgment to determine the merits of arguments; develops solutions and decides on the most appropriate solution to achieve the desired outcome in a collaborative manner.

• Applies technical/business knowledge, scope assessment, experience, predictive skills, risk awareness and analysis to define a level of effort and cost.

• Includes and works together with cross-functional teams, diverse groups, and individuals of all levels to achieve a common goal.

• Documents the requirements, capabilities, limitations, design, operation, and maintenance of a system, such as a communications, computing, or information processing system.

• Ensures technical metadata/documentation is maintained in appropriate repositories

• Works with the DBAs, Informatica Admins, Hadoop Admins, R-Studio Admins and data warehouse operations to determine how to meet SLAs defined with the business.

Level III - in addition to Level II responsibilities:

• Applies the information framework against business requirements within security and operational constraints in support of delivery of new technology or capability.

• Analyzes existing systems, identifies impacted areas and changes to design at a system or functional level to support requirements for a given. technology/platform/application.

• Implements and measures audit, balance, and control procedures to monitor security and efficiency of the data warehouse environment.

• Acts as development lead on projects as assigned, coordinating activities of development team.

• Leads, manages and/or implements technical change initiatives, acting in a lead role to incorporate the change into day-to-day processes.

• Provides training and mentoring to staff on the use of the tools.

• Develops and applies standards and best practices for data storage, data processing and platform integration.

• Develops the ability to work across multiple data platforms (Hadoop and Oracle).

Level IV - in addition to Level III responsibilities:

• Transforms business requirements and functional specification into a set of components, modules, process flows, and interfaces required to satisfy those requirements. This includes dimensions such as stability, performance, maintainability, and disaster recovery.

• Sets up rules for cleansing the data according to data quality policies.

• Assists with system/UAT testing by providing expertise in data subset needs and job execution.

• Helps with the selection of data integration tools for the solutions being implemented

• Interfaces with Solution Architecture, Data Architecture, Data Integration Analysts, Data Integration Architects, and Business Intelligence to ensure the business' data requirements are designed for optimal use.

• Mentors other Engineers in the Data Integration Engineer level I/II/III roles.

• Develops and recommends standards and best practices related to Data Integration.

• Researches new technology and makes recommendations on how to improve and evolve our ongoing data strategy.

• Addresses performance and scalability issues and performs necessary capacity planning to meet new business initiatives.

Minimum Qualifications

NOTE

We include multiple levels of classification differentiated by demonstrated knowledge, skills, and the ability to manage increasingly independent and/or complex assignments, broader responsibility, additional decision making, and in some cases, becoming a resource to others. In addition to using this differentiated approach to place new hires, it also provides guideposts for employee development and promotional opportunities.

Level I

• Bachelor's degree in Computer Science, Information Technology, or relevant field (or four additional years of work experience in lieu of bachelor's).

• Core classes within computer science and information systems track.

• Course work in principles and practices of basic computer hardware, operating systems, and software application.

• Course work in principles and practices of applications programming and software troubleshooting.

• SQL (or Hive) experience developing queries, tables, functions, and stored procedures.

• Knowledge of MS Word, Excel, and OneNote, Toad, Oracle 11g or higher, SharePoint, Unix, Java, SQL Developer, Cloudera Hadoop Platform, Spark, Python.

• Has the ability to develop work plans and follow through on assignments with some guidance.

• Understanding of architectural principles and data integration styles.

• Understanding of various types of data models.

• Novice in data integration tools.

• Strong communication and written skills.

• Ability to effectively organize one's work.

Level II - (in addition to Level I Qualifications)

• 3 years production-level data integration of application development experience (or related experience).

• 2 years Data Warehouse experience.

• 2 years database utilities (e.g., TOAD, SQL Developer, Cloudera Hadoop Platform, Spark, Python)

• 1 year job scheduling software knowledge

• 2 years SQL experience (or Hive).

• Has the ability to develop work plans and follow through on assignments with minimal guidance.

• Practitioner in data integration tools.

Level III - (in addition to Level II Qualifications)

• 5 years production-level data integration of application development experience (or related experience).

• 3 years Data Warehouse experience.

• 3 years database utilities (e.g., TOAD, SQL Developer, Cloudera Hadoop Platform, Spark, Python).

• 1 year of data services experience.

• 3 years SQL experience (or Hive).

• Has the ability to develop work plans and follow through on assignments with minimal guidance.

• Advanced knowledge of data integration tools.

Level IV - (in addition to Level III Qualifications)

• 8 years production-level data integration of application development experience (or related experience).

• 7 years large-scale Data Warehouse experience.

• 5 years database utilities (e.g., TOAD, SQL Developer, Cloudera Hadoop Platform, Spark, Python).

• 3 year of data services experience.

• 5 years SQL experience (or Hive).

• Has the ability to develop work plans and follow through on assignments with minimal guidance.

• Experience in Data Modeling (Conceptual, Logical and Physical). A plus if familiar with master data concepts such as Party, Product, Location, Agreement as well as patterns such as Data Vault.

• Experience working with Change Data Capture.

• Expert in data integration tools.

• Ability to mentor junior level Data Integration Developers.

Physical Requirements

• Ability to work prolonged periods sitting and/or standing at a workstation and working on a computer.

• Ability to travel across the Health Plan service region for meetings and/or trainings as needed.

One Mission. One Vision. One I.D.E.A. One you.

Together we can create a better I.D.E.A. for our communities.

At the Lifetime Healthcare Companies, we're on a mission to make our communities healthier, and we can't do it without you. We know diversity helps fuel our mission and that's why we approach our work from an I.D.E.A. mindset (Inclusion, Diversity, Equity, and Access). By activating our employees' experiences, skills, and perspectives, we take action toward greater health equity.

We aspire to reflect the communities we live in and serve, and strongly encourage people of color, LGBTQ+ people, people with disabilities, veterans, and other underrepresented groups to apply.

OUR COMPANY CULTURE:

Employees are united by our Lifetime Way Values & Behaviors that include compassion, pride, excellence, innovation, and having fun! We aim to be an employer of choice by valuing workforce diversity, innovative thinking, employee development, and by offering competitive compensation and benefits.

In support of the Americans with Disabilities Act, this job description lists only those responsibilities and qualifications deemed essential to the position.

Equal Opportunity Employer

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)