Remote Data Engineer - SQL, Spark & BI Modeling

Aston Carter; Chicago (IL); Remote; USD 83,000 - 92,000; Full time

Benefits offered by this job

Medical, dental & vision

401(k) Retirement Plan

Life Insurance

Disability coverage

Transportation benefits

Paid time off

Job summary

Aston Carter is seeking a Data Engineer to advance our data environment, focusing on clean, scalable foundations for analytics and AI initiatives. You will design and optimize data transformations, build robust data models, and support reporting with DAX and SQL across large datasets in a remote-capable role.

You will collaborate with business and technical teams to ensure data pipelines meet needs, while leveraging Spark, Python, R, or Scala for automation and data processing in a modern

Qualifications

• 3+ years of experience using SQL to develop and troubleshoot complex data transformations.
• 3+ years of experience with VertiPaq semantic modeling and analytics data models.
• 3+ years of experience using DAX for calculations and reporting needs.
• 3+ years of experience using Python, R, or Scala for data processing and automation.
• 3+ years of experience utilizing Spark or distributed data processing engines.

Responsibilities

• Design, develop, and enhance data processes to collect, transform, organize, and deliver large data volumes.
• Use SQL to optimize and troubleshoot complex data transformations for reporting and analytics.
• Build and improve VertiPaq models for analytics and self-service BI.
• Develop and refine DAX calculations to support metrics and reporting needs.
• Collaborate with stakeholders to translate methodologies into efficient data solutions.
• Establish and maintain data pipelines and structures across multiple systems.
• Contribute to modernization of the data environment for AI and automation initiatives.
• Utilize Python, R, Scala, or similar languages for data processing and automation tasks.
• Leverage Spark and other engines to handle large-scale workloads.

Skills

SQL

VertiPaq semantic modeling

DAX

Python

R

Scala

Spark

Tools

Spark

Job description

Aston Carter is seeking a Data Engineer to advance our data environment, focusing on clean, scalable foundations for analytics and AI initiatives. You will design and optimize data transformations, build robust data models, and support reporting with DAX and SQL across large datasets in a remote-capable role.

You will collaborate with business and technical teams to ensure data pipelines meet needs, while leveraging Spark, Python, R, or Scala for automation and data processing in a modern