Sr Data Engineer
Role details
Job location
Tech stack
Job description
- Design, develop, and maintain scalable data pipelines using Snowflake, Azure, dbt, and Apache Airflow
- Lead the migration and modernization of legacy ETL workflows (Informatica, Oracle, SQL Server) into cloud-native architectures
- Build and optimize ELT/ETL processes for structured and semi-structured data from internal and external sources
- Develop and manage Snowflake data models, including performance tuning, clustering strategies, and cost optimization
- Implement dbt models following analytics engineering best practices including testing, documentation, and version control
- Orchestrate workflows and dependencies using Apache Airflow
- Integrate and support marketing data pipelines, including Adobe Campaign and related marketing technologies
- Partner with Data Analysts, Data Scientists, Marketing teams, and business stakeholders to deliver reliable, scalable solutions
- Ensure data quality, lineage, and observability through monitoring, validation, and alerting frameworks
- Mentor junior engineers and contribute to engineering standards, architecture discussions, and best practices
- Continuously evaluate opportunities to improve scalability, performance, and reliability across the data ecosystem
Requirements
Do you have experience in Schema design?, Do you have a Bachelor's degree?, * Bachelor's degree required
- 6+ years of experience supporting data warehouse and data engineering environments
- Strong understanding of data warehousing concepts, dimensional modeling, and ELT architecture
- Hands-on experience building and supporting cloud-based data solutions
- Experience working in hybrid environments spanning legacy systems and modern cloud platforms
- Experience integrating external vendor data via APIs, web services, and XML-based sources
- Proficiency with Git, CI/CD pipelines, and modern development practices
- Experience with Azure DevOps, Jira, or similar Agile project management tools, * Strong collaboration and communication skills across technical and non-technical stakeholders
- Ability to thrive in fast-paced, evolving environments
- Flexible, curious, and solution-oriented mindset
- Experience working within Agile teams and development environments
We bring together human insight and digital expertise to anticipate the needs of our customers. Our team members are innovative, technologically sophisticated, and motivated to achieve.
Benefits & conditions
Pulled from the full job description
- Tuition reimbursement
- Pet insurance
- Parental leave
- Health insurance
- 401(k) matching
- Paid time off
- Vision insurance, The base salary range for this role is $140,000-$150,000 annually for employees based in Boston, MA. Final compensation may vary and will be determined based on factors such as relevant experience, skills, internal equity, and geographic location. In addition to base pay, this role is eligible for an annual incentive bonus and first-class benefits, which include:
Health & wellness: Comprehensive and heavily subsidized medical, dental, and vision plans, plus on-site gym access, holistic wellness sessions, and group fitness classes
Time for you: Substantial Paid Time Off (PTO), and 11 paid holidays-including Juneteenth, Memorial Day, and Labor Day-and Summer Fridays. Plus, extensive parental leave with up to 12-16 weeks paid leave at 100% base salary
Travel more, spend less: 50% off our trips for you and a companion, 25% for additional immediate family members, and exclusive quarterly associate travel deals
Your future, secured: 401(k) with company match, life insurance, and disability coverage
Continuous growth: Tuition assistance for both professional and personal development, opportunities for professional development through overseas travel, and direct access to Pinnacle Leadership & Team Development
Extra perks: Commuter benefits, FSA options, pet insurance, home & auto discounts, and paid volunteer time off to give back to the community