Anteriad

Title: Data Engineer Location: remote 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

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

• Build and maintain data ingestion pipelines using Azure Data Factory (ADF) to move data into the corporate Azure Data Lake and related platforms. • Develop and enhance data transformation logic in Databricks notebooks, primarily leveraging SQL-based transformations in existing SQL scripts and stored procedures. • Support a medallion data architecture (Bronze, Silver, Gold) with Silver and Gold datasets stored primarily in Parquet format. • Assist in migrating SQL Server–based processes (scripts, stored procedures, SSIS logic) running on Azure VMs into Azure-native pipelines and Databricks transformations. • Continuously update and enhance existing database solutions and systems based on new and evolving requirements from marketing campaign activation and analytics teams, ensuring data remains accurate, timely, and fit for purpose. • Manage multiple concurrent initiatives, including modernization efforts and ongoing enhancement requests, while maintaining platform stability and data quality. • Configure Azure Data Factory pipelines to orchestrate Databricks notebooks and Fabric-related processes as applicable. • Use Azure DevOps for source control, versioning, and deployment of Azure Data Factory, Databricks, and Fabric assets. • Test, monitor, and troubleshoot pipelines to ensure data reliability, performance, and quality. • Collaborate with senior engineers, project managers, campaign services, analytics, and platform teams to deliver ongoing data solutions. Participate in the adoption and use of Microsoft Fabric, understanding how Fabric components (e.g., OneLake, Lakehouse, Warehousing) integrate with existing Azure and Databricks workflows. • Maintain technical documentation for data pipelines, transformations, and datasets

• Reporting to the Senior Director, Customer Success, you will be involved in all aspects of the internal/client support function for Anteriad. • Internal and external client-facing resource available for Q and A on all details related to accounts. • The ideal candidate will become the primary resource in this area for our customers, Sales Directors, and Operations team. • Work in tandem with our India and US Operations teams in order to ensure Anteriad can offer true customer support and customer insights. • Identify and escalate situations requiring urgent attention. • Situations requiring escalation could arise from both customer and internal inquiries at any stage of a potential, active, or completed campaign. • Collaborate with sales to develop strategies to help customers see greater success with Anteriad and grow their investments. • Expert utilization and understanding of Salesforce and Qlik, as well as proprietary platforms to execute daily work. • Be responsible for all products sold within their team for both non enterprise and enterprise customers. • Understand customer motivations and use that understanding to improve their service campaign over campaign and quarter over quarter. • Execute and present a wide range of reports including check-ins, campaign summaries, and QBRs. • Assist Customer Success, Sales, Marketing, Operations, and Anteriad Management teams in any support and projects as needed. • Utilize SFDC cases to track campaign status and offer pre-sales support activities.

Lead analytical workstreams by translating complex marketing questions into actionable insights, conducting thorough analyses, and effectively communicating results to stakeholders, while fostering strong client relationships and continuously improving...

• Sell all data-centric solutions to key lead generation decision-makers within agencies and enterprise prospects in the EMEA region. • Lead generation via aggressive prospecting and networking • Prospect qualification, needs assessment, and competitive positioning to develop needs-based proposals. • Post-close issues resolution • Conduct client meetings both in person and video • Product demonstrations both in person and video • Negotiating, closing business and securing renewal business • Navigating large, complex enterprise accounts to identify multiple decision makers, buying committees and budgets to effectively grow the business

• Internal and external client-facing resource available for Q and A on all details related to assigned accounts or campaigns. The ideal candidate will become the primary resource in this area for our customers, Sales Directors, and Operations team. • Creative strategic thinker that collaborates internally and with clients to create targeted efficient plans, execution, and insightful reporting. • Work in tandem with our India and US Operations teams to ensure Anteriad can offer true customer support and customer insights. • Identify and escalate situations requiring urgent attention. Situations requiring escalation could arise from both customer and internal inquiries at any stage of a potential, active, or completed campaign. • Become an expert in utilizing and understanding a variety of digital communication and project management platforms (including Salesforce, Qlik, and Anteriad’s proprietary tools) • Manage the day-to-day administration of all client programmatic projects – meeting deadlines, driving optimizations and recommendations based on reporting, change requests, etc. • Understand customer motivations and use that understanding to improve their service campaign over campaign and quarter over quarter. • Craft strategic solutions for our digital clients, including providing budget, targeting/audience recommendations, and creative options for client proposals • Utilize SFDC cases to track campaign status and offer pre-sales support activities. • Candidate will have the opportunity to train and mentor other members of the Customer Success Team in Programmatic best practices.

• Sell all data-centric solutions to key lead generation decision-makers within agencies and enterprise prospects. • Lead generation via aggressive prospecting and networking • Prospect qualification, needs assessment, and competitive positioning to develop needs-based proposals. • Post-close issues resolution • Conduct client meetings both in person and video • Product demonstrations both in person and video • Negotiating, closing business and securing renewal business • Navigating large, complex enterprise accounts to identify multiple decision makers, buying committees and budgets to effectively grow the business