Senior Analytics Data Engineer

About the Role

Key Responsibilities

• Design, build, and maintain scalable data models and transformation workflows using Snowflake, DBT, and SQL.
• Develop and manage business-ready datasets and data marts to support dashboards, performance tracking, AI/ML use cases, and marketing/commercial applications.
• Setup, monitor and validate data workflows to ensure accuracy, reliability, and timely delivery.
• Review code written by other team members, providing constructive feedback and ensuring adherence to quality standards.
• Guide and support team members, helping them improve their coding skills and understanding coding best practices.
• Collaborate with Data Product Owners and Business Analysts to gather requirements, translate business needs into technical solutions, and prioritize work based on value and urgency.
• Serve as a data subject matter expert (SME) working directly with marketing, analytics, digital solutions, and commercial stakeholders to quickly assess and resolve data challenges.
• Proactively provide hands-on, responsive support to evolving data needs, from exploratory investigations to production-ready pipelines.
• Maintain clear and thorough documentation for data logic, models, lineage, and workflows.
• Ensure all data processes align with internal governance standards, privacy requirements, and documentation protocols.
• Enable and enhance AI-powered marketing initiatives, including lead scoring, real-time personalization, and optimization models by delivering clean, structured, and accessible data.

Requirements

• 5+ years of professional experience in data engineering or a similar technical role focused on transforming and modeling data for business use.
• Expertise in SQL, with hands-on experience designing data models and transformation pipelines in Snowflake and DBT.
• Experience in integrating and transforming data from Salesforce.
• Proven ability to work collaboratively with cross-functional partners while operating independently as a data subject matter expert (SME).
• Strong problem-solving skills and ability to provide responsive, hands-on solutions to data-related questions and requests.
• Familiarity with working in regulated industries or with sensitive business data (e.g., healthcare, life sciences).

Nice to Have

• Bachelor's degree in information technology, Computer Science, Engineering, or a related field.
• Excellent communication and documentation skills.
• Experience with marketing data (e.g., campaign performance, lead funnel, audience segmentation, web/media analytics).
• Experience with healthcare claims and prescription data.
• Experience with Python for data transformation or workflow automation.
• Knowledge of BI tools (e.g., Tableau, Power BI) and enabling data for self-service use.
• Experience supporting AI/ML applications (e.g., lead scoring, predictive modeling, personalization).

Qualifications

• Bachelor's degree in relevant field (preferred).
• 5+ years of experience in data engineering or similar roles.

Benefits & Perks

• Competitive salary range from $82,600 to $156,900, commensurate with experience.
• Core and optional employee benefits (details at www.bscbenefitsconnect.com).
• Potential variable compensation including bonuses and incentives.
• Supportive work environment with access to latest tools and training.