Data engineer- data validation - SQL Queries

Company:
Location: Remote

*** Mention DataYoshi when applying ***

HHS Technology Group is a valued and trusted systems integration partner for several departments within a number of State Governments. The intense growth and tremendous financial forecast we are experiencing at HHS Technology Group can largely be attributed to our successes on these initiatives.

HHS Technology Group’s flagship product, Discover your Provider (DyP) is a provider relations/provider enrollment solution.

  • Project Effective Dates

August 1, 2021 through June 30 ,2022

  • Project Scope/Tasks

The scope of this project encompasses the following tasks:

The scope of this Letter of Engagement is to provide services to fulfill high-volume, one-time, ad hoc requests for business data that are used by the business divisions to:

    • Respond to employer inquiries for various reasons such as data validation in their software systems,
    • Conduct internal and external audits,
    • Conduct research about pension plans and health plans,
    • Work with health plan providers to reconcile subscribers,
    • Evaluate business operational procedures and optimize those procedures,
    • Support outreach campaigns such as email marketing efforts,
    • Support legislative and legal issues and cases,
    • Maintain annual reporting efforts,
    • Verify business transactions and operations analytics

The fulfillment of business data requests consists of the following activities:

    • Write Structured Query Language (SQL) queries with advanced functions and large, complex data models
    • Perform data extracts, data profiling, data transformations and data set validation
    • Analyze team findings relative to the fulfillment of the business data extract
    • Provide expert-level data evaluations and fixes, transformation logic, programmatic implementations of business rules and SQL programs
    • Validate business information flow and business rules against data models utilizing existing documentation such as use cases and business requirements

Monthly fulfillment of business data requests is expected to consist of fulfilling 25-60 requests per month. This estimate is based on counts from 2020 and is expected to be representative of the workload in the 2021/2022 fiscal year. The majority of business data requests use SQL queries to query records from the database and/or the data warehouse. The data model includes 2,000+ tables that contain business transactions and related information. The 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.

Knowledge transfer between the vendor and will be facilitated through an existing process called Data Request Centralization where:

  • requests for business data are submitted via ServiceNow,
  • requests are routed to the fulfiller,
  • request fulfillment artifacts such as technical documents and SQL scripts are added to the Data Request Library and
  • data is transferred securely to the requestor 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.


SCOPE OF WORK REQUIREMENTS


Scoring
Points


Qualifications


70


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


0 -
20


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


0 -
10


3. 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.


0 -
10


4. Proven ability to communicate effectively both verbally and in writing with a variety of audience types using different mechanisms including informal updates, formal presentations, business case documents, and other analytical and technical documents.


0 -
10


5. Proven strong understanding of information technology fundamentals, project management fundamentals, and systems development life cycle.


0 -
10


6. At least five (5) years of experience in some or all areas of Pension, Health Insurance, Customer Service, Finance or Risk


0 -
10


Total:


100


GnUdmY9cJA

*** Mention DataYoshi when applying ***

Offers you may like...

  • ELLKAY LLC

    SQL Developer/Data Engineer
    Elmwood Park, NJ 07407
  • Trimble

    Data Engineer
    Saint Paul, MN 55122
  • UnitedHealth Group

    Sr. Data Engineer - DataStage - Telecommute
    Eden Prairie, MN 55344
  • Wavicle Data Solutions

    API Integration (Salesforce) Data Engineer
    Remote
  • Tiger Analytics

    Data Engineer (Azure)
    Remote