
Senior Data Engineer
Museum of Science, Boston
Innovation and creativity come from the unique perspectives of a diverse staff. We value your perspective.
Who We Are: The Museum of Science is dedicated to inspiring a lifelong love of science in everyone. We are committed to inclusivity, innovation, and education, serving diverse communities through our exhibits, programs, and outreach efforts.
Why We Need You:
As a Senior Data Engineer, you will be key in building and optimizing scalable data pipelines that power analytics and business intelligence. Reporting to the Head of Data and Analytics, you will collaborate with analytics engineers, data analysts, and business teams to design efficient data architectures, automate data flows, and ensure high-performance data processing—delivering iterative value in line with the Data Strategy.
Your work will ensure data is reliable, accessible, and well-structured, enabling teams to drive insights and decision-making. If you thrive on optimizing data infrastructure, solving complex data challenges, and working with modern cloud technologies, this role is for you.
What You'll Accomplish:
Design & Maintain Scalable Data Infrastructure: Build, optimize, and maintain data pipelines using tools like Fivetran, Estuary, and dbt Cloud to ensure seamless ingestion, transformation, and storage in Snowflake. Implement best practices for data integrity, performance, and cost optimization.
Enhance Data Quality & Governance: Establish data governance frameworks to ensure compliance with GDPR, CCPA, and internal security policies. Design robust ELT workflows using dbt Cloud to standardize and transform raw data into analytics-ready models.
Deliver Actionable Insights: Work closely with data analysts and business teams to ensure reliable, well-structured datasets are available for decision-making. Optimize reporting and self-service analytics in Power BI to enable business users to derive insights effectively.
Drive Cross-Functional Collaboration: Partner with analytics engineers, data analysts, and business stakeholders to design efficient data solutions. Automate deployments using CI/CD workflows and ensure a scalable, well-documented data architecture.
Lead Technical Execution & Best Practices: Contribute to code reviews, technical design documentation, and architectural discussions. Provide mentorship for junior engineers and ensure best practices in data modelling, testing, and modular programming.
Optimize Cloud-Based Data Ecosystem: Manage and enhance Snowflake, ensuring it supports performance and scalability needs. Integrate data from diverse sources using Fivetran and Estuary, leveraging event-driven architectures and pub/sub-design patterns where necessary.
This is a Hybrid position, with the selected candidate working 2-3 days onsite at the Museum of Science in Boston, MA.
What We’re Looking For:
Proven Data Engineering Expertise: You have experience designing and managing scalable data pipelines in cloud-based environments as a Data Engineer or in a similar role. You are proficient in SQL and Python and have hands-on experience working with Snowflake, dbt Cloud, Fivetran, and Estuary to build and optimize ELT workflows.
Cloud Data Architecture & Performance Optimization: You have a deep understanding of cloud platforms (AWS, Azure, or Google Cloud) and expertise in managing data warehouses like Snowflake. You are skilled in data partitioning, indexing, caching, and query optimization, ensuring efficient and scalable data solutions.
Data Modelling, Transformation & Governance: You are experienced in data modelling and transformation using dbt Cloud, ensuring data is structured for analytics and reporting. You enforce data quality, security, and governance standards (GDPR, CCPA) to maintain compliance and reliability across data assets.
Integration & Automation: You have experience integrating data sources using Fivetran or Estuary, enabling seamless structured and semi-structured data movement. You are comfortable working with CI/CD pipelines, infrastructure-as-code (Terraform, Pulumi), and automation workflows to improve reliability and efficiency.
Business-Focused Analytics Enablement: You understand how data supports decision-making and have experience working with Power BI or similar BI tools to enable self-service analytics. You can structure data for reporting, ensuring stakeholders can easily access and interpret insights.
Collaboration & Stakeholder Engagement: You have strong communication skills and can work cross-functionally with data analysts, engineers, and business teams. You are comfortable translating technical concepts into clear, actionable insights and guiding teams toward data-driven decision-making.
Problem-Solving & Adaptability: You are a critical thinker with strong analytical and troubleshooting skills. You proactively identify inefficiencies, optimize workflows, and adapt to new challenges. You stay ahead of industry trends and continuously seek ways to improve data operations.
How We Work-Our Values:
Everyone: We are everyone’s museum. We pursue equity and celebrate every person for who they are. We foster an inclusive environment in which we value and respect diversity.
Service: We serve our colleagues and community. We hold ourselves accountable to be a trustworthy public resource, and to support a sustainable, just and evidence-based future.
Learning: We love learning. We are curious about the world and want to share our joy and wonder with others. We value open minds and recognize that everyone has more to explore, discover and create.
Connection: We find strength in connections. We collaborate across communities, organizations and disciplines to make science relevant and accessible to all.
Boldness: We dream big. We boldly push ourselves forward, pursuing new ideas and challenges. We experiment and learn from our failures as we seek to inspire purpose, spark imagination and encourage hope.
Salary Range
$104,000 - $130,000 USD
Apply for this job
*
indicates a required field