Data & Analytics Engineer: Pipelines & BI

Who we are:

For over four decades, Ace has been moving industries and families forward. As a recognized leader in relocation and logistics, we’ve built our reputation on innovation, reliability, and a relentless drive to deliver. Through strategic investments in technology, talent, and infrastructure, Ace has grown into the largest hauler in the Atlas Van Lines network and a trusted name in commercial relocation and logistics. But it’s not just about size — it’s about service. Year after year, we’re recognized by clients and industry peers as one of the best in the business. And while relocation and logistics may not always make headlines, it’s the engine that keeps companies agile, employees supported, and families connected — and we’re proud to be at the heart of it.

Who we are:

For over four decades, Ace has been moving industries and families forward. As a recognized leader in relocation and logistics, we’ve built our reputation on innovation, reliability, and a relentless drive to deliver. Through strategic investments in technology, talent, and infrastructure, Ace has grown into the largest hauler in the Atlas Van Lines network and a trusted name in commercial relocation and logistics. But it’s not just about size — it’s about service. Year after year, we’re recognized by clients and industry peers as one of the best in the business. And while relocation and logistics may not always make headlines, it’s the engine that keeps companies agile, employees supported, and families connected — and we’re proud to be at the heart of it.

If you are interested in a solid career working with a tenured, growing company that puts its people first while serving valuable clients, then we want you to be a part of the Ace Relocation Systems team!

Priorities:

• Design, build, and maintain data pipelines to ingest, transform, and load data from various sources including SQL Server, PostgreSQL, SaaS platforms (e.g., HubSpot), and internal applications
• Develop and optimize data models to support reporting, analytics, and operational use cases
• Manage and monitor data ingestion processes using data replication tools, Azure Data Factory, and Snowflake stages
• Ensure data quality, integrity, and reliability across all pipelines and datasets
• Collaborate with business stakeholders to gather reporting and analytics requirements and translate them into scalable data solutions
• Develop and maintain dashboards and reports to deliver actionable insights to end users
• Implement best practices in data governance, documentation, and pipeline monitoring
• Optimize query performance and storage efficiency within Snowflake
• Evaluate and recommend tools, technologies, and architecture improvements to support Ace’s data strategy
• Other duties as assigned.

Benefits:

• Collaborative and team-oriented environment
• Paid vacation/sick/holidays
• Comprehensive benefits package including 401k with match
• Workplace Flexibility
• And much, much more!

Company information can be found at www.acerelocation.com.

The pay range is $102,000 - $120,000 base salary plus additional incentives. Starting pay is based on criteria such as location, experience, qualifications, and the terms of any applicable agreement. Dependent on the length of service, hours worked, and applicable agreements, benefits include medical, dental, vision, life, and optional disability insurance, sick pay of 2.66 hours for every 80 hours worked, flexible time off, paid holidays, bereavement pay and retirement benefits.

Please note that we do not wish to be contacted by external recruiters regarding job candidates. All applications must be submitted through our official channels.

We Take Equality Seriously: Indeed, all aspects of employment with the Company will be governed based on merit, competence, and qualifications and will not be influenced in any manner by an individual's race, religion, color, national origin, ancestry, citizenship status, physical disability, mental disability, genetic information (including testing and characteristics), sex (including pregnancy, lactation, childbirth or related medical conditions), gender identity, age (40 and over), sexual orientation, veteran status, uniformed service member status or any other status protected by local, state or federal law.

Qualifications

Technology Skills:

• Strong experience with SQL and relational databases (SQL Server, PostgreSQL)
• Experience working with cloud data warehouses, preferably Snowflake
• Experience building and maintaining ETL/ELT pipelines using tools such as Azure Data Factory or similar
• Familiarity with data replication/integration tools (e.g., Fivetran, Stitch, Hevo, etc.)
• Strong understanding of data quality, governance, and validation techniques
• Experience with BI and data visualization tools, preferably Sigma
• Experience working with SaaS data sources (e.g., HubSpot) and API-based data ingestion
• Exposure to logistics, transportation, or CRM systems is a plus

Minim