Remote Senior Data Engineer: Scale Data Pipelines

Foley; Boston (MA); On-site; USD 120,000 - 180,000; Full time

Benefits offered by this job

Medical, dental, vision coverage

401(k) with company match

Paid time off and holidays

Wellness programs

Employee assistance program

Job summary

Foley is seeking a Senior Data Engineer to design, build, and scale data systems that power the company. You will create reliable data pipelines, contribute to enterprise data architecture, and ensure data is modeled, governed, and accessible for decision-making.

You will partner with Engineering, Product, Analytics, and stakeholders to deliver production-quality data solutions, addressing ambiguity, and delivering well-structured outcomes in a defined scope.

Qualifications

• Strong experience building and maintaining ETL/ELT pipelines in production environments.
• Experience with both batch and streaming/CDC/event-driven data patterns.
• Proven ability to design and maintain scalable warehouse schemas and data models within a layered architecture.
• Strong experience with Python, SQL, and cloud-based data platforms.
• Experience with AWS data services such as Redshift, Glue, Lambda, S3, and EventBridge.
• Strong software engineering fundamentals, including reliability, testing, and maintainability.
• Ability to operate independently and deliver high-quality solutions within a defined technical scope.
• Strong problem-solving skills and a track record of handling issues in production environments.

Responsibilities

• Design, build, and maintain scalable data pipelines across internal databases, vendor systems, and our data warehouse.
• Support both batch and event-driven or CDC-based data workflows.
• Improve pipeline reliability, observability, and performance.
• Troubleshoot issues in production and proactively solve data quality or system problems.
• Build and maintain data warehouse schemas and transformation layers to support analytics and operational use cases.
• Contribute to data modeling standards and best practices.
• Implement data governance practices, including RBAC and trusted data definitions.
• Partner with Engineering, Product, Analytics, and business stakeholders to translate requirements into practical data solutions.
• Communicate clearly about implementation choices, tradeoffs, and technical constraints.
• Help stakeholders access data that is reliable, understandable, and useful.
• Identify opportunities to improve data workflows through better tooling, automation, and engineering practices.
• Embrace new technologies, including AI-enabled tools, where they improve quality or efficiency.
• Continuously improve system design, maintainability, and team effectiveness.
• Contribute to the design and evolution of our enterprise data architecture.

Tools

Python

SQL

cloud data platforms

ETL/ELT pipelines

Batch data processing

Streaming/CDC data patterns

Data warehousing

AWS data services

Redshift

Glue

Lambda

S3

EventBridge

Job description

Foley is seeking a Senior Data Engineer to design, build, and scale data systems that power the company. You will create reliable data pipelines, contribute to enterprise data architecture, and ensure data is modeled, governed, and accessible for decision-making.

You will partner with Engineering, Product, Analytics, and stakeholders to deliver production-quality data solutions, addressing ambiguity, and delivering well-structured outcomes in a defined scope.