Data Engineer

Anteriad; United States; On-site; USD 120,000 - 165,000; Full time

Benefits offered by this job

Work from home

Flexible PTO

Percipio LMS access

Collaborative & independent work mix

Anteriad Cares community outreach

Mentoring program

Employee Resource Groups

Job summary

Anteriad seeks a Data Engineer to join the Data Integration team in New York City. You will receive, organize, and load data into Anteriad’s Data Warehouse to support marketing analytics and reporting across Power BI and Excel.

You will design, build, and optimize data pipelines using Azure Data Factory, Databricks, and Microsoft Fabric, while ensuring data quality and reliability for client onboarding and internal analytics.

Qualifications

• Experience in data engineering or data integration (>=3 years).
• Proficient in SQL (T-SQL) and data modeling concepts.
• Experience building ETL/ELT pipelines in cloud environments (Azure).
• Experience with Databricks notebooks, Python, and Spark SQL.
• Strong analytical, problem-solving, and communication skills.

Responsibilities

• Partner with stakeholders to translate requirements into scalable data solutions.
• Design and maintain ETL/ELT pipelines with Azure Data Factory and Fabric.
• Develop data transformation logic with Azure Databricks and Fabric notebooks.
• Build data models, stored procedures, and data delivery components for BI.
• Support migration of legacy ETL to cloud-based architectures.
• Implement data quality checks, logging, and alerts.

Skills

Analytical thinking

Problem solving

Communication skills

Education

Bachelor’s degree in CS/IT/Data Analytics

Tools

SQL Server

Azure Data Factory

Azure Databricks

Microsoft Fabric

Power BI

Job description

Come Join Our Team At Anteriad and innovate the way B2B marketers make data-driven business decisions.

About Anteriad We are not just another B2B solution provider. We're problem solvers. We believe that data is the key to unlocking effective solutions that span a range of marketing challenges - from customer acquisition to demand generation to account-based marketing. Data is at the core of everything we do. Our team works tirelessly to create powerful solutions that drive real results for our clients. Whether it's through innovative technology or deep analysis, we're committed to finding the best path to growth for every one of our customers.

Why Join Our Data Integration Team? This is an excellent opportunity for an intelligent, energetic, and self-motivated individual to play a vital role within a growing part of Anteriad. As our Data Engineer, you will have an important role in receiving, organizing, and loading data into Anteriad’s Data Warehouse to be used by our clients and throughout the Anteriad organization. As an integral part of the Data Integration team, you will play a key role in building, managing, and optimizing data pipelines that support our marketing and analytics efforts. You will be a professional with deep expertise in SQL and hands-on experience with SSIS and cloud-based data solutions, especially within the Azure ecosystem.

This role may require 1-4 on-site meetings at our NYC office per year. You must be willing to attend if scheduled.

This role is not eligible for sponsorship, including current OPT and/or partner VISA status.

Anteriad means “always moving forward” and we apply that to our company culture by tirelessly promoting an environment that allows our employees to thrive:

• Work from home
• Flexible PTO
• Training & development with unlimited access to Percipio LMS
• Mix of collaborative & independent work
• Community outreach via Anteriad Cares - encouraging staff to take time to volunteer
• Professional mentoring program - career guidance from leadership
• Employee Resource Groups - collaborate with others that share your passions!

Benefits We Bring to You:

• Comprehensive medical (choice of 3 plans), dental and vision coverage
• Company paid short-term disability, long term disability, and life insurance
• Optional supplemental life, accident, and critical illness insurance plans
• 401K with company match
• Flexible PTO and generous holiday schedule
• Fully paid primary caregiver leave (12 weeks) & parental bonding leave (2 weeks)

What You’ll Do

• Partner with technical and non-technical stakeholders to translate business requirements into scalable, reliable, and maintainable data engineering solutions.
• Design, develop, and maintain data integration solutions using Microsoft SQL Server, Azure Data Factory, Azure Databricks, Microsoft Fabric, and related Azure services.
• Build, manage, and optimize ETL/ELT pipelines using Azure Data Factory and Microsoft Fabric Pipelines, including pipeline orchestration, parameterization, scheduling, monitoring, and error handling.
• Develop and maintain data transformation logic using Azure Databricks notebooks and Microsoft Fabric notebooks, with a focus on performance, scalability, reusability, and operational reliability.
• Design and implement data ingestion, transformation, validation, and delivery processes across structured, semi-structured, and external data sources.
• Develop and optimize data integration processes utilizing Azure Data Factory, Azure Databricks, Azure Storage Accounts, Azure Data Lake Storage, Azure Key Vault, Microsoft Fabric Lakehouses, Warehouses, Pipelines, and Notebooks.
• Build and maintain SQL-based data models, stored procedures, views, automation scripts, and database objects to support operational and analytical workloads.
• Support the modernization and migration of legacy data integration processes from SSIS and on-premises platforms to cloud-based Azure and Microsoft Fabric architectures.
• Design and implement reusable pipeline patterns, data quality checks, validation controls, logging, alerting, and performance monitoring processes.
• Support new client onboarding efforts by designing and implementing reliable data ingestion, transformation, reconciliation, and validation workflows.
• Troubleshoot and resolve data pipeline, data quality, performance, and integration issues in collaboration with teams across Intelligence & Analytics.
• Design, develop, and maintain datasets, semantic models, and data structures that support reporting, analytics, and visualization solutions across Power BI, Excel, Microsoft Fabric, and other business intelligence platforms.
• Contribute to data engineering standards, documentation, best practices, and reusable frameworks that improve scalability, maintainability, and operational efficiency.
• Research, evaluate, and recommend emerging technologies and platform capabilities that improve data architecture, automation, performance, and reliability.

What You’ll Bring

• 3+ years of experience in data engineering, data integration, business intelligence engineering, or a related technical role.
• 3+ years of experience writing, optimizing, and troubleshooting SQL, including T-SQL, stored procedures, views, indexing strategies, and query performance tuning.
• Hands-on experience designing, building, and supporting ETL/ELT pipelines using Azure Data Factory and/or Microsoft Fabric Pipelines.
• Hands-on experience developing data processing and transformation logic using Azure Databricks notebooks, Microsoft Fabric notebooks, PySpark, Spark SQL, Python, or similar technologies.
• Strong Microsoft SQL Server and relational database design principles skills.
• Experience with Azure data platform services such as Azure Data Factory, Azure Databricks, Azure Storage Accounts, Azure Data Lake Storage, Azure Key Vault, and related cloud data services.
• Strong knowledge and in depth work with Microsoft Fabric components such as Pipelines, Notebooks, Lakehouses, Warehouses, Dataflows, and semantic models.
• Experience building reliable data ingestion and transformation processes from APIs, flat files, databases, web services, cloud storage, and other external data sources.
• Hands on experience implementing data validation, reconciliation, monitoring, logging, and alerting processes for production data pipelines.
• Experience supporting production data workloads, including troubleshooting failures, optimizing performance, and improving pipeline reliability.
• Prior experience modernizing or migrating legacy ETL processes from SSIS, SQL Server, or on-premises environments to Azure or Microsoft Fabric is strongly preferred.
• Bachelor’s degree in Computer Science, Information Technology, Data Analytics, a related field, or equivalent professional experience.
• Power BI, semantic models, or other data visualization and analytics tools experience is a plus.
• Experience with Customer Data Platforms, CDPs, database marketing, marketing analytics, or client data onboarding environments is a plus.
• Working knowledge with AWS or Google Cloud Platform is a plus.
• Strong analytical, problem-solving, and critical thinking skills.
• Excellent verbal and written communication skills, with the ability to explain technical concepts to both technical and non-technical audiences.
• Ability to work independently on moderately complex data engineering tasks while collaborating effectively in a team-oriented environment.

Our Values

• Lead & Learn We lead with unrivaled vision, innovation and execution, always learning and embracing new ways of doing things to stay out in front
• Collaborate & Celebrate We build great things when we work together as one Anteriad team, celebrating our achievements – both great and small – along the way
• Innovate & Inspire We are always looking for bold new ways to exceed the expectations of our customers and to inspire each other to even greater success
• Do More & Do Good We go above and beyond in the service of our clients and colleagues, and the communities where we live

Notice to California Applicants: We collect and process personal information as described in our California Applicant Privacy Notice, in compliance with the California Consumer Privacy Act (CCPA/CPRA). Please review the notice here: Anteriad Privacy Policy