Data and Analytics Engineer

About the role

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.

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.

Requirements

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

Qualifications

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

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.

Benefits

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