Senior Data Engineer

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

We are looking for a Senior Data Engineer to help design, build, and scale the data systems that power how Foley operates and grows. In this role, you will build reliable data pipelines, contribute to our enterprise data architecture, and help improve how data is modeled, governed, and accessed across the organization.

This is a hands-on senior engineering role for someone who enjoys solving real technical problems, delivering production-quality data solutions, and improving systems over time. You will partner closely with Engineering, Product, Analytics, and business stakeholders to ensure our data systems are scalable, trusted, and built to support decision-making across the company.

The ideal candidate combines strong technical depth with practical execution. They should be comfortable operating in ambiguity, troubleshooting issues as they arise, and delivering well-structured solutions within a defined scope.

What you'll do

Pipeline Development & Execution

• 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

Data Modeling & Governance

• 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 role-based access control and trusted data definitions
• Support data quality and consistency across systems

Cross-Functional Partnership

• 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

Continuous Improvement

• 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

Data Architecture & Systems Design

• Contribute to the design and evolution of our enterprise data architecture
• Help shape scalable patterns for how data is ingested, transformed, stored, and accessed
• Apply sound architectural judgment to build solutions that balance scalability, maintainability, and performance
• Support a layered data architecture, including bronze, silver, and gold data models

Who you are

• Strong experience building and maintaining ETL/ELT pipelines in production environments
• Experience working across 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

Nice-to-Haves

• Experience with medallion architecture and bronze, silver, gold data modeling patterns
• Experience with graph data models and entity resolution
• Experience implementing data governance practices, including RBAC
• Experience supporting machine learning or LLM-related pipelines in production environments
• Familiarity with tools or workflows that use AI to improve engineering productivity
• Experience partnering with Data Science or Analytics teams to support data products

You Might Thrive in This Role If You

• Enjoy being hands-on and solving concrete technical problems
• Think in systems and tradeoffs, not just tools
• Can clearly explain what you built, why you built it that way, and what impact it had
• Are comfortable owning execution and working through ambiguity
• Notice when something is broken or inefficient and take initiative to improve it
• Are open to using AI and automation thoughtfully, even if you are not an expert in AI systems

Location: This role is primarily remote, US-based, and operates largely in EST hours, with occasional travel for team collaboration and company events.

About us

At Foley, we’re reimagining how safety-sensitive industries hire, stay compliant, and manage risk. We’ve evolved into a modern SaaS company with an all-in-one, AI-ready platform that helps transportation, construction, distribution, and utility businesses operate faster, smarter, and safer.

As we continue to grow, we’re looking for curious, strategic thinkers who thrive in complexity, are motivated by making an impact, and want to join a team that’s passionate about building great products and supporting customers. Our core values — Teammateship, Grit, and Innovation — guide everything we do. Whether we’re collaborating internally or helping customers, we approach every challenge with optimism, humor, and a shared commitment to success.

Benefits
Foley offers a comprehensive benefits package that includes medical, dental, and vision coverage, a 401(k) with company match, paid time off and holidays, wellness programs, and an employee assistance program.

Equal Employment Opportunity
Foley is an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, disability, protected veteran status, or any other legally protected characteristic.

Reasonable Accommodations
If you require a reasonable accommodation during the application or interview process, please contact us at [e-mail]

Employment Status
Employment with Foley is on an at-will basis. Nothing in this job posting or in future communications should be construed as a contract of employment.

Massachusetts Applicants: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

Privacy Policy: Please see our Applicant Privacy Policy for more information on how Foley processes your personal information during the recruitment process and, if applicable based on your location, how you can exercise any privacy rights.