Data Engineer

Data Engineer (ETL / ELT & Data Modeling)

Overview

We are seeking a Data Engineer to support large-scale data platforms used for research, analytics, and regulatory reporting. This role focuses on designing, maintaining, and evolving ETL/ELT pipelines and data models that support high‑volume, complex, and highly structured datasets within a PostgreSQL-based data warehouse environment.

You will work closely with internal stakeholders and external data providers to manage periodic data loads, schema changes, and historical backfills. Strong SQL expertise is essential, along with experience supporting static and incrementally growing datasets in a massively parallel processing (MPP) environment.

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines for large, structured datasets
• Own and support 3–5 primary datasets, handling scheduled loads (monthly, quarterly, or annual) and schema updates
• Perform full reloads and historical backfills as data models evolve
• Collaborate with internal partners and third‑party data providers to ensure accurate, timely data delivery
• Ensure pipelines are scalable, repeatable, secure, and well-documented
• Implement and enforce data quality, validation, and integrity controls
• Conduct regular and ad hoc data audits, reviews, and investigations
• Produce technical documentation for data structures, processes, and standards
• Identify opportunities to improve data ingestion, modeling, and quality processes
• Support PostgreSQL schemas in a Greenplum (MPP) data warehouse environment
• Participate in Agile/DevOps workflows, working independently or as part of a database/data platform team

Data Environment

• PostgreSQL data warehouse running on Greenplum MPP architecture
• Approximately 25 heterogeneous datasets totaling 300+ TB
• Data domains include financial, credit, mortgage, risk, real estate, and market data
• Some datasets contain billions of rows and grow incrementally over time
• Data is generally static between loads, with full reloads performed on refresh
• Mix of manual and automated loads, primarily driven by Linux and Bash scripting
• Production and contingency environments are mirrored for resiliency
• Limited downstream BI usage (, select Tableau feeds)

Required Skills

• Advanced SQL (complex querying, performance tuning, data validation)
• PostgreSQL data modeling and schema management
• ETL / ELT pipeline development
• Data warehousing concepts and best practices
• Linux / Bash scripting
• Git and GitLab version control workflows
• Experience working with large-scale, structured enterprise datasets

Preferred / Nice‑to‑Have Skills

• Greenplum or other MPP database platforms
• Python for data processing or automation
• Exposure to Databricks environments
• Familiarity with cloud platforms (AWS)
• Tableau or other BI/reporting tools

Qualifications

• Bachelor’s degree in a STEM-related field (or equivalent practical experience)
• 4–10+ years of relevant data engineering experience (level dependent)
• Proven experience developing and maintaining complex SQL across relational databases
• Strong understanding of data quality, governance, and validation practices
• Ability to work independently with minimal supervision
• Senior-level candidates should demonstrate subject-matter depth and serve as a technical resource to others

Job Type & Location

This is a Contract position based out of Kansas City, MO.

Pay and Benefits

The pay range for this position is $ - $

Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following:
• Medical, dental & vision
• Critical Illness, Accident, and Hospital
• 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available
• Life Insurance (Voluntary Life & AD&D for the employee and dependents)
• Short and long-term disability
• Health Spending Account (HSA)
• Transportation benefits
• Employee Assistance Program
• Time Off/Leave (PTO, Vacation or Sick Leave)

Workplace Type

This is a hybrid position in Kansas City,MO.

Application Deadline

This position is anticipated to close on May 10, 2026.

h4>About TEKsystems:

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

About TEKsystems and TEKsystems Global Services

We’re a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We’re a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We’re strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We’re building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.