Jr Data Engineer

JOB TITLE: Junior Data Engineer (No C2C)
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.
• Support data delivery into downstream reporting platforms, including Power BI.
• 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.
• Strong Python skills, including:
  • Pandas
  • DataFrames
  • Data transformation techniques
  • Data cleansing and manipulation
• Strong SQL skills, including:
  • SELECT statements
  • WHERE clauses
  • JOINs
  • Views
  • Stored Procedures
  • Data validation
  • Data deduplication
• 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.
• SQL stored procedure development.
• 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.

All qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. Rate of pay within the stated range will depend on the qualification of the applicant.