Data Engineer: Build Scalable Pipelines & Analytics

Colonial Group; Carmel (IN); On-site; USD 100,000 - 150,000; Full time

Job summary

Schwarz Partners in Carmel, IN is seeking a Data Engineer to build and maintain data pipelines and analytics infrastructure. You will transform raw data, design ETL processes, and collaborate with data, design, product, and executive teams to deliver insights and improve data workflows.

The role requires SQL expertise, experience with data warehousing, and strong communication to translate business needs into technical solutions.

Qualifications

• Bachelor's degree or 4+ years in related field.
• Demonstrated SQL experience in large databases and data profiling.
• Experience with quantitative and qualitative data analysis.
• Experience in systems analysis and systems engineering.
• Self-starter with ability to multi-task and adapt to changing priorities.

Responsibilities

• Build and maintain data pipelines using SQL and cloud technologies.
• Assemble large, complex data sets meeting business requirements.
• Design data warehousing and ETL processes.
• Collaborate with stakeholders across design, product, and exec teams.
• Create/maintain BI reports and data models.
• Document technical requirements and design results.
• Drive improvements to data workflows and architecture.

Skills

SQL proficiency

Data analysis

Systems analysis

Systems engineering

Self-starter

Education

Bachelor's degree in Computer Science

Tools

Microsoft Fabric

OneLake

Delta Lake

Direct Lake

DirectQuery

Spark/PySpark

Azure Data Factory / Fabric Pipelines

Power Query/M (Dataflows Gen2)

DAX measures

Job description

Schwarz Partners in Carmel, IN is seeking a Data Engineer to build and maintain data pipelines and analytics infrastructure. You will transform raw data, design ETL processes, and collaborate with data, design, product, and executive teams to deliver insights and improve data workflows.

The role requires SQL expertise, experience with data warehousing, and strong communication to translate business needs into technical solutions.