Junior Data Engineer — Data Quality & ETL (Hybrid, Indy)

Theoris; Indianapolis (IN); Hybrid; USD 65,000 - 85,000; Full time

Benefits offered by this job

Health insurance

401(k)

PTO

Paid holidays

Job summary

Theoris is seeking a Junior Data Engineer to join a newly formed government data team in Indianapolis. You will focus on cleansing, validating, transforming, and testing enterprise data across multiple source systems to support analytics and reporting.

You will work with Python, SQL, and ETL/ELT tools, with exposure to Wherescape and SQL Server. This role emphasizes data quality, collaboration, and continuous learning in a hybrid work environment.

Qualifications

• Approximately 2 years of experience in Data Engineering, ETL, Data Integration, or a related field.
• Experience with enterprise ETL/ELT or data integration tools.
• Must be a USC or Greencard Holder, no EADs or OPTs.
• Must be local to Indianapolis, available to work onsite day one.
• DataFrames
• Data cleansing and manipulation
• SELECT statements
• WHERE clauses
• JOINs
• Views
• Stored Procedures
• Data validation
• Experience working with SQL Server or other relational databases.
• Experience cleaning, transforming, and validating data from multiple sources.
• Ability to perform cross-database validation and data quality testing.
• Strong analytical and troubleshooting skills.
• Excellent attention to detail and commitment to data accuracy.
• Strong communication and collaboration skills.
• Curious, thorough, personable, and eager to learn new technologies and data environments.

Responsibilities

• Develop and support data engineering processes using Python, SQL, and enterprise ETL/ELT tools.
• Extract, transform, and load data from multiple production systems into clean, usable datasets.
• Perform extensive data cleansing, validation, quality assurance, and testing activities.
• Identify and resolve data issues including duplicates, inconsistent values, formatting discrepancies, missing information, and data entry errors.
• Use Python, particularly Pandas and DataFrames, to transform data, create new fields, and prepare datasets for downstream consumption.
• Write and maintain SQL queries, views, joins, tables, and stored procedures.
• Validate and reconcile data across multiple databases and source systems.
• Troubleshoot data quality issues and verify transformation accuracy through testing.
• Support reusable and scalable data processes that can be expanded across projects and datasets.
• Work within a medallion-style data architecture to organize and manage data throughout its lifecycle.
• Communicate data findings, quality issues, and validation results with stakeholders.
• Contribute to the organization's transition from traditional ETL tooling toward more modern Python-based data engineering solutions.

Skills

DataFrames

Data cleansing

SELECT statements

WHERE clauses

JOINs

Views

Stored Procedures

Data validation

Python

SQL Server

Tools

Wherescape

SQL Server

Azure Data Factory

Informatica

Talend

Databricks

Job description

Theoris is seeking a Junior Data Engineer to join a newly formed government data team in Indianapolis. You will focus on cleansing, validating, transforming, and testing enterprise data across multiple source systems to support analytics and reporting.

You will work with Python, SQL, and ETL/ELT tools, with exposure to Wherescape and SQL Server. This role emphasizes data quality, collaboration, and continuous learning in a hybrid work environment.