Data Engineer

Come Join Our Team At Solstice Analytics and innovate the way B2B marketers make data-driven business decisions. About Solstice Analytics 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 Solstice Analytics . As our Data Engineer, you will have an important role in receiving, organizing, and loading data into Solstice Analytics ’s Data Warehouse to be used by our clients and throughout the Solstice Analytics 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. Solstice Analytics 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 Solstice Analytics 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