Data Engineer

Aston Carter • Hampden Township, PA

2d • $60 - $67 • Remote

About The Position

The Data Engineer will help develop and modernize the organization’s data environment, creating a clean, reliable, and scalable foundation for reporting, analytics, and future AI and automation initiatives. The role works with large volumes of business and project data, learning existing methodologies and workflows and designing, developing, and improving processes to collect, transform, organize, and deliver data across the organization.

The Data Engineer will use SQL to develop and troubleshoot complex data transformations, build and maintain VertiPaq semantic models, and use DAX to support business calculations and reporting. The role will also establish efficient pipelines and data structures that integrate information from different systems consistently. It will work with business and technical teams to align data models, transformations, and reports with requirements and industry best practices, supporting a growing organization’s data infrastructure and advanced analytics, AI, and automation work.

This is a fully remote, contract-to-hire position based out of Mechanicsburg, Pennsylvania. Core collaboration is aligned to Eastern or Central Time Zones.

Requirements

• At least 3 years of experience using SQL to develop and troubleshoot complex data transformations.
• At least 3 years of experience with VertiPaq semantic modeling, including building and maintaining analytics data models.
• At least 3 years of experience using DAX to create and optimize business calculations and support reporting.
• At least 3 years of experience using Python, R, or Scala for data processing, transformation, or automation.
• At least 3 years of experience using Spark or other distributed data processing engines for large-scale data workloads.
• At least 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.
• Ability to work effectively in a remote, distributed team environment and collaborate across time zones.

Nice To Haves

• 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 Vantagepoint or similar project accounting systems.
• Experience supporting AI and automation initiatives through robust data foundations.

Responsibilities

• Design, develop, and enhance processes for collecting, transforming, organizing, and delivering large volumes of business and project data.
• Use SQL to develop, optimize, and troubleshoot complex data transformations for reporting and analytics.
• Build, maintain, and improve VertiPaq semantic models for business intelligence and self-service analytics.
• Develop and refine DAX calculations for 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 data pipelines and structures that reliably integrate information from multiple systems.
• Contribute to modernizing the organization’s data environment to enable advanced analytics, AI, and automation initiatives.
• Use Python, R, Scala, or similar programming languages for data processing, transformation, and automation.
• Use Spark or other distributed data processing engines to handle large-scale workloads and improve performance.
• Work with business and technical teams to ensure data models, transformations, and reports align with business requirements and industry best practices.

Benefits

• Medical, dental, and vision coverage, if eligible.
• Critical Illness, Accident, and Hospital coverage, if eligible.
• 401(k) retirement plan with pre-tax and Roth post-tax contributions available, if eligible.
• Voluntary life and AD&D insurance for employees and dependents, if eligible.
• Short- and long-term disability coverage, if eligible.
• Health Spending Account (HSA), if eligible.
• Transportation benefits, if eligible.
• Employee Assistance Program, if eligible.
• Time off or leave, including PTO, vacation, or sick leave, if eligible.

What This Job Offers

• Career Level: Mid Level
• Education Level: No Education Listed