Job Summary:
Ace Relocation Systems is a recognized leader in relocation and logistics, known for its innovation and reliability. The Data and Analytics Engineer will design and maintain data pipelines, optimize data models, and collaborate with stakeholders to deliver actionable insights through reporting and analytics.
Responsibilities:
โข 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.
Qualifications:
Required:
โข 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
โข 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 role
โข Demonstrated experience building data pipelines, data models, or analytics solution
Preferred:
โข Exposure to logistics, transportation, or CRM systems is a plus
Company:
Ace Relocation Systems is a company that helps you move your belongings when you move. Founded in 1955, the company is headquartered in San Diego, USA, with a team of 201-500 employees. The company is currently Growth Stage.