Data Engineer

STEM Search Group; Cincinnati (OH); Hybrid; USD 110,000 - 140,000; Full time

Job summary

STEM Search Group is seeking a data engineering professional to design and optimize production‑grade data pipelines and data warehouses. You will collaborate with a data science team, implement ETL using C#, Python, SSIS, and SQL Server 2019–2025, and work with Databricks in a hybrid office/remote setting.

You will join a seasoned team of engineers, contribute to agile planning, ensure code quality with documentation, and grow with AI initiatives in data warehousing and engineering.

Qualifications

• Production‑grade data pipelines and enterprise data warehouse design experience
• Hands‑on SQL Server 2019–2025 and SSIS ETL development
• Proficient in C# and Python with ability to interface with data science outputs
• Familiar with Databricks environments for cloud/big data initiatives
• Team‑oriented, problem‑solving mindset in a hybrid in‑office/remote environment
• Knowledge of SDLC and version control; may complete a programmer aptitude test
• Interest in AI as it relates to data warehousing and data engineering

Responsibilities

• Build and optimize data pipelines using C#, Python, SSIS, and SQL Server
• Design data warehouses and data structures for reliable downstream use
• Collaborate with data science to productionize models and prototypes
• Work with a team of eight data engineers and consultants; leverage Databricks as needed
• Contribute to agile estimation, clean coding, and comprehensive documentation

Skills

C#

Python

SSIS

SQL Server

ETL design

Data warehousing

Databricks

Team collaboration

Hybrid work

Code debugging

Tools

Databricks

SQL Server 2019-2025

Git

Job description

• Build and optimize robust data pipelines using a blend of modern programming and traditional enterprise tools including C#, Python, SSIS, and Microsoft SQL Server versions 2019 through 2025.
• Design and implement custom data warehouse solutions and data structures to ensure high data availability, cleansing, and seamless integration for downstream business consumption.
• Collaborate closely with the data science team to integrate their R-based models and prototypes into reliable production workflows.
• Work closely with an established team of eight data engineers, a principal engineer, and external consultants to manage existing systems while selectively leveraging Databricks for cloud data processing.
• Participate actively in a collaborative agile environment by contributing to work estimates, following clean coding practices, and maintaining comprehensive documentation.

What we’re looking for

• Proven experience designing production‑grade data pipelines, custom data models, and enterprise data warehouse solutions
• Extensive hands‑on experience working with Microsoft SQL Server platforms, specifically versions 19, 22, and 25, alongside building complex ETL processes with SSIS
• Solid proficiency writing and debugging code in both C# and Python, paired with the ability to interface effectively with data science outputs
• Familiarity with Databricks environments to effectively support evolving cloud and big data initiatives
• A team‑oriented mindset with excellent problem‑solving skills, comfortable working in a hybrid environment requiring three days in‑office and two days remote
• Comfort navigating software development lifecycles and source control, along with a readiness to complete a programmer aptitude test as part of the evaluation process
• A desire to grow with AI as it relates to data warehousing and data engineering