[Hiring] Data Engineer @Aston Carter

Role Description

The Data Engineer will play a key role in the continued development and modernization of the organization's data environment, focusing 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.

• 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 company's 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 company's 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.

Requirements

• Experience with SparkSQL for querying and processing distributed datasets.
• Experience with Microsoft Fabric, Azure Synapse, or similar cloud data technologies.
• Understanding of project accounting concepts and how they translate into data and reporting requirements.
• Experience working with data in the engineering or professional services industry.
• Familiarity with tools such as Vantagepoint or similar project accounting systems.
• Experience supporting AI and automation initiatives through robust data foundations.
• Ability to work effectively in a remote, distributed team environment and collaborate across time zones.

Benefits

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

Company Description

Aston Carter provides world-class corporate talent solutions to thousands of clients across the globe. Specialized in accounting, finance, human resources, talent acquisition, procurement, supply chain and select administrative professions, we extend the capabilities of industry-leading companies.