Junior Data Engineer (no c2c)

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

LOCATION: Hybrid in Indianapolis

INDUSTRY: Government

JOB OVERVIEW:

We are seeking a Junior Data Engineer to join a newly formed team responsible for modernizing and governing enterprise data across the court system. This role is ideal for someone who is curious, detail-oriented, personable, and motivated by solving complex data quality challenges.

The position is heavily focused on data cleansing, validation, transformation, and testing. You will work with diverse datasets from multiple source systems, leveraging Python, SQL, and ETL/ELT tools to create accurate, reliable, and reusable datasets that support enterprise analytics and reporting. The team currently utilizes Wherescape and SQL Server data warehouse technologies and is evolving toward more Python-based data engineering practices.

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.

REQUIREMENTS:

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

PREFERRED:

• Azure Data Factory and Microsoft Fabric exposure.
• Wherescape, Informatica, Talend, or Databricks experience.
• Knowledge of Medallion Architecture.
• Python logging and Git version control experience.
• Exposure to Power BI or other data visualization tools.

Best-In-Class-Benefits

We are in the people business; treating people right is our ONLY priority. Theoris Services consultants are full-time employees with full benefits, including:

• Robust Health Insurance
• 401(k) plan
• PTO
• Paid holidays

About Theoris:

Our goal is to Fuel Your Career! As a Theoris team member, you join a culture based on people-centered values and an environment that fosters both personal and professional growth. We build long-term relationships with our clients and our consultants. With over 30 years of building strong relationships in the industry, we’re uniquely positioned to make the right connections. This knowledge is used to find the right job placement. Our recruiting teams are experts dedicated to the information technology and engineering staffing space and are highly respected by our client base.