Data Engineer

Hollstadt & Associates; Northern (KY); Hybrid; USD 123,000 - 146,000; Full time

Benefits offered by this job

Medical options

Dental coverage

Vision coverage

401(k) with match

Longevity bonus

Referral bonus

Job summary

Hollstadt Consulting seeks a Data Engineer for a remote, 9-month contract, with potential extension. The role focuses on building automated data pipelines, managing a GBQ data repository, and enabling dashboards for decision support.

Responsibilities include ingesting data from multiple sources, refining data pipelines as sources evolve, and collaborating with software engineers to define data contracts and APIs. Competitive hourly rate applies.

Qualifications

• 4+ years of experience as a data engineer or similar role.
• Hands-on experience with Google BigQuery or an equivalent cloud data warehouse (e.g., Snowflake, Redshift) required or strongly preferred.
• Strong SQL and ETL/pipeline development experience across multiple source systems.
• Experience with API integrations and scheduled/automated data exports.
• Experience designing data models that support downstream dashboards and applications.

Responsibilities

• Design and build automated data pipelines that ingest and reconcile data from LTC, Compass, Data Factory, DLMP exports, and future Beaker exports.
• Build and maintain the GBQ data repository that hosts the crosswalk and comparison datasets.
• Develop the automated data layer used for the Test Classification Dashboard and Executive Impact Dashboard.
• Support ongoing refinement of the crosswalk repository's data pipelines as DLMP source data changes over time.
• Partner with Software Engineers to define data contracts/APIs that power client-facing tools.

Skills

SQL

ETL/pipeline development

Data modeling

API integrations

Dashboard development

Tools

Google BigQuery

Google Cloud Data Fusion

Job description

Hollstadt Consulting is a management and technology consulting firm dedicated to placing professionals at engagements where they will excel. When you work with us, you'll work with a refreshingly real company led and staffed by seasoned experts who are also down-to-earth, good people. We're committed to treating you with respect and helping you achieve your career aspirations.

Since 1990, Hollstadt has been a trusted partner to more than 150 domestic and global companies and has successfully completed over 3,000 projects. Our continued growth has created challenging and rewarding opportunities for accomplished IT and Business Consultants.

Hollstadt Consulting is an equal opportunity employer including disability/veteran.

By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from Hollstadt Consulting and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel at any time.

Job Description

Role: Data Engineer

Location: Remote

Duration: Full-time contract, estimated 9 months with likely extension

Rate: $89-$106/hour W2, dependent on skills and qualifications

Key Responsibilities

• Design and build automated data pipelines that ingest and reconcile data from LTC, Compass, Data Factory, DLMP exports, and future Beaker exports.
• Build and maintain the Google BigQuery (GBQ) data repository that hosts the crosswalk and comparison datasets.
• Develop the automated comparison/visualization data layer used for the Test Classification Dashboard and Executive Impact Dashboard.
• Support ongoing refinement of the crosswalk repository's data pipelines as DLMP source data changes over time.
• Partner with the Software Engineer(s) to define data contracts/APIs that power the client-facing tools.

Required Skills & Experience

• 4+ years of experience as a data engineer or similar role.
• Hands-on experience with Google BigQuery (GBQ) or an equivalent cloud data warehouse (e.g., Snowflake, Redshift) required or strongly preferred.
• Strong SQL and ETL/pipeline development experience across multiple source systems.
• Experience with API integrations and scheduled/automated data exports.
• Experience designing data models that support downstream dashboards and applications.

Preferred Skills & Experience

• Experience with Google Cloud Data Fusion or similar ELT/ETL no-code pipeline tooling.
• Healthcare, laboratory, or life sciences industry experience.
• Experience supporting agentic AI or AI-assisted query tools (a future-state opportunity for this program).

Primary Deliverables

• Automated data pipelines from all required source systems
• GBQ-hosted comparison/crosswalk repository
• Data layer supporting the Test Classification Dashboard and Executive Impact Dashboard

Benefits

• Hollstadt offers medical, dental, vision, life insurance, short-term disability, long-term disability, paid sick leave, and retirement benefits to eligible employees.
• With three different medical plans to choose from, you can enroll in the coverage you need from individual to family, or anywhere in between!

Remarketing Process

Hollstadt is based on retention and relationships. We get to know your strengths and career wishes throughout your assignment and then start remarket discussions 6-8 weeks prior to your end date. By being proactive, we are able to keep your down time between assignments as short as possible, unless you choose otherwise.

Professional Development

Hollstadt offers on-demand training through our consultant portal. Trainings give our consultants the continuing education they need to excel on their projects. Many of our courses apply towards continuing education credits and we have an entire training hub dedicated to upskilling in Artificial Intelligence (AI).

401k + Matching

One popular benefit is our 401(k) match on the first 4% of your contributions. Hollstadt wants to help you reach your long-term financial goals and understands that planning for your future is critical. Consultants also have access to support from a Financial Advisor.

Loyalty Rewards

We appreciate and reward loyalty. Join Hollstadt, stay for 5 years, and we’ll give you a $5,000 Longevity Award bonus! Additionally, we know great talent knows other great talent. If you are on contract with Hollstadt and refer one of your connections who gets placed, we’ll pay you $1,000!

Ongoing Support & Networking

We have made a significant investment in building a support program for our consultant team - so you never have to feel like you are going it alone. We also have a Consultant Coach program which acts like a 'work buddy' to provide a safe ear for questions or concerns at your client site.