Data Engineer

About this Position:

Job Title: Data Engineer

Deliverables:

Deliverable 1:

• Fulfill high-volume, one-time, ad hoc requests for business data requested by business divisions.

• Monthly fulfillment of business data requests is expected to consist of fulfilling 70-80 requests per month.

• This estimate is based on counts from 2025 and is expected to be representative of the workload in the 2026/2027 fiscal year.

• Most of the business data requests use SQL queries to query records from the client's database and/or the data warehouse.

• The client's data model includes 2,000+ tables that contain business transactions and related information.

• The client's data warehouse model consists of 30+ fact tables and 100+ dimension tables.

• Business data requests have a 10-day service level agreement that the vendor will be bound to.

Deliverable 2:

• Design and deliver a set of data marts that will support client's analytics.

• Data marts will be handled in phases.

• Phase I is the design phase.

• Clients will agree to the design and scope of the data marts.

• Phase II is the development phase.

• The client will develop data models for the data marts and the code needed to refresh the data in the data marts based on Phase I.

• Phase III is the review and acceptance phase where the data in the data marts is validated and the refresh code is integrated into the existing data platform's ETL batch window.

Deliverable 3: Knowledge Transfer

• Knowledge transfer occurs via the Data Request Centralization process: (1) requests are submitted through ServiceNow, (2) routed to the fulfiller, (3) fulfillment artifacts and scripts are stored in the Data Request Library, and (4) data is securely shared via a Data Locker.

• Any data issues that are identified during fulfillment of business data requests are reported to client and recorded in the Data Request Library.

Qualifications:

• At least five (5) years of experience supporting the design and development of analytical models, tools, or programs using Oracle tools.

• At least five (5) years of experience with interpreting requirements and developing complex PL/SQL and SQL.

• Proven ability to reason logically and creatively and use a variety of analytical and research techniques to solve complex problems; visualize data sets; analyze situations and propose an effective course of action; analyze data; identify the need for and provide creative thinking related to complex problems, develop and evaluate alternatives.

• At least five (5) years of experience in some or all areas of Pension and Health Insurance.