Data and Analytics Engineer

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 applicationsDevelop and optimize data models to support reporting, analytics, and operational use casesManage and monitor data ingestion processes using data replication tools, Azure Data Factory, and Snowflake stagesEnsure data quality, integrity, and reliability across all pipelines and datasetsCollaborate with business stakeholders to gather reporting and analytics requirements and translate them into scalable data solutionsDevelop and maintain dashboards and reports to deliver actionable insights to end usersImplement best practices in data governance, documentation, and pipeline monitoringOptimize query performance and storage efficiency within SnowflakeEvaluate and recommend tools, technologies, and architecture improvements to support Ace’s data strategyOther duties as assigned. Benefits:Collaborative and team-oriented environmentPaid vacation/sick/holidaysComprehensive benefits package including 401k with matchWorkplace FlexibilityAnd 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.QualificationsTechnology Skills:Strong experience with SQL and relational databases (SQL Server, PostgreSQL)Experience working with cloud data warehouses, preferably SnowflakeExperience building and maintaining ETL/ELT pipelines using tools such as Azure Data Factory or similarFamiliarity with data replication/integration tools (e.g., Fivetran, Stitch, Hevo, etc.)Strong understanding of data quality, governance, and validation techniquesExperience with BI and data visualization tools, preferably SigmaExperience working with SaaS data sources (e.g., HubSpot) and API-based data ingestionExposure to logistics, transportation, or CRM systems is a plusMinimum Qualifications (Knowledge, Skills, and Abilities):Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or related field (or equivalent experience)2+ years of experience in data engineering, analytics engineering, or a related roleDemonstrated experience building data pipelines, data models, or analytics solution