Remote Data Engineer - Scalable Pipelines & Analytics

Talentify; Mechanicsburg (Cumberland County); Remote; USD 83,000 - 92,000; Full time

Benefits offered by this job

Medical benefits

401(k) Retirement Plan

Life Insurance

Disability Insurance

HSA (Health Savings Account)

Transportation benefits

PTO

Job summary

A data engineer role with Aston Carter focuses on modernizing and scaling the organization’s data environment in a fully remote setup. You will design, develop, and optimize data pipelines, models, and transformations to support reporting, analytics, and AI initiatives across the business.

You will work with SQL, VertiPaq models, DAX calculations, and distributed processing (Spark) while collaborating with stakeholders to translate complex methodologies into robust data solutions that scale with

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.

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.

Skills

SQL

Python

R

Scala

Spark

DAX

VertiPaq

Education

Bachelor's degree or higher in a relevant field

Tools

VertiPaq

Power BI

Job description

A data engineer role with Aston Carter focuses on modernizing and scaling the organization’s data environment in a fully remote setup. You will design, develop, and optimize data pipelines, models, and transformations to support reporting, analytics, and AI initiatives across the business.

You will work with SQL, VertiPaq models, DAX calculations, and distributed processing (Spark) while collaborating with stakeholders to translate complex methodologies into robust data solutions that scale with