Data Engineer

Aston Carter; Chicago (IL); Remoto; USD 83.000 - 92.000; Tempo pieno

Vantaggi offerti da questo lavoro

Medical, dental & vision

401(k) Retirement Plan

Life Insurance

Disability coverage

Transportation benefits

Paid time off

Descrizione del lavoro

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

Competenze

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

Mansioni

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

Conoscenze

SQL

VertiPaq semantic modeling

DAX

Python

R

Scala

Spark

Strumenti

Spark

Descrizione del lavoro

Job Title: Data Engineer

Job Description

The Data Engineer will play a key role in the continued development and modernization of the organizations data environment, with a focus on creating a clean, reliable, and scalable data foundation for reporting, analytics, and future AI and automation initiatives. This role works with large volumes of business and project data, gaining a deep understanding of existing methodologies and workflows and then designing, developing, and improving the processes used to collect, transform, organize, and deliver data across the organization. The Data Engineer will use SQL extensively to develop and troubleshoot complex data transformations, build and maintain VertiPaq semantic models, and utilize DAX to support business calculations and reporting needs. The role will also help establish efficient data pipelines and structures that integrate information from different systems and ensure it is used consistently by the business.

Responsibilities

• Design, develop, and enhance data processes used to collect, transform, organize, and deliver large volumes of business and project data across the organization.
• Use SQL extensively to develop, optimize, and troubleshoot complex data transformations that support reporting and analytics.
• Build, maintain, and improve VertiPaq semantic models to provide a robust foundation for business intelligence and self-service analytics.
• Develop and refine DAX calculations to support business metrics, reporting requirements, and analytical use cases.
• Collaborate with stakeholders to understand existing methodologies and workflows and translate them into efficient, scalable data solutions.
• Establish and maintain efficient data pipelines and data structures that integrate information from multiple systems in a consistent and reliable manner.
• Contribute to the modernization of the companys data environment, enabling advanced analytics, AI, and automation initiatives.
• Utilize Python, R, Scala, or similar programming languages to support data processing, transformation, and automation tasks.
• Leverage Spark or other distributed data processing engines to handle large-scale data workloads and improve performance.
• Work closely with business and technical teams to ensure data models, transformations, and reports align with business requirements and industry best practices.

Qualifications

• 3+ years of experience using SQL to develop and troubleshoot complex data transformations.
• 3+ years of experience with VertiPaq semantic modeling, including building and maintaining data models for analytics.
• 3+ years of experience using DAX to create and optimize business calculations and support reporting needs.
• 3+ years of experience using Python, R, or Scala for data processing, transformation, or automation.
• 3+ years of experience utilizing Spark or other distributed data processing engines to manage large-scale data workloads.
• 3+ years of experience developing and modernizing a companys data environment for reporting, analytics, and automation.
• Strong understanding of database concepts and large-scale data architectures.
• Ability to analyze and document existing methodologies and workflows and translate them into improved data processes.
• Proficiency in designing scalable, reliable, and maintainable data pipelines and data structures.

Work Environment

This position operates in a 100% remote work environment, with core collaboration aligned to Eastern or Central Time Zones. The role involves working with modern data technologies, including SQL-based environments, VertiPaq semantic models, DAX, Python or other programming languages, and distributed data processing engines such as Spark. The Data Engineer will support a growing organization as it develops and modernizes its IT and data infrastructure to enable advanced analytics, AI, and automation. The remote setup offers flexibility while maintaining a professional, results-oriented culture focused on continuous improvement and innovation in data practices.

Job Type & Location

This is a Contract to Hire position based out of Chicago, IL.

Pay and Benefits

The pay range for this position is $60.00 - $67.00/hr.

Individual compensation offered for this position within this range will depend on many factors, including qualifications, skills, relevant experience, job knowledge, geographic location, internal equity, and other pertinent job-related factors.

Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: Medical, dental & vision Critical Illness, Accident, and Hospital 401(k) Retirement Plan Pre-tax and Roth post-tax contributions available Life Insurance (Voluntary Life & AD&D for the employee and dependents) Short and long-term disability Health Spending Account (HSA) Transportation benefits Employee Assistance Program Time Off/Leave (PTO, Vacation or Sick Leave)

Application Deadline

This position is anticipated to close on Nov 15, 2026.

Workplace Type

This is a fully remote position.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

If you would like to request a reasonable accommodation, such as the modification or adjustment of the job application process or interviewing process due to a disability, please email [e-mail] ([e-mail]) for other accommodation options.

San Francisco Fair Chance Ordinance: Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records.

Massachusetts Lie Detector: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools.