Design, build, and maintain ELT pipelines and semantic models in BigQuery using Fivetran and Airflow. Develop LookML, maintain the semantic layer and data documentation, own event instrumentation with Segment, ensure data integrity, and deliver dashboards and analyses to stakeholders.
Choice Sitter Solutions LLC d/b/a Sittercity
Senior Analytics Engineer
Salary: $116,000 - $125,000
2 Wells Ave, Newton, MA 02459
Job Description: Design, develop, and maintain scalable ELT pipelines using Fivetran, Airflow, and
custom integrations. Model raw data into clean, reliable datasets in the cloud data warehouse (BigQuery).
Build and maintain LookML and data pipeline models that transform raw data into usable datasets for
reporting and analysis. Own and improve the semantic layer and data documentation for self-service
tools, creating a single source of truth for metrics and dimensions used across the company. Own the
instrumentation and tracking plan across digital products using Segment. Work closely with product and
engineering teams to ensure data integrity. Collaborate with engineers and business stakeholders to define
clean data definitions and business logic. Partner with stakeholders to understand data needs. Help
translate business questions into scalable data solutions, including presentations, well-designed data
visualizations, and interactive dashboards. Monitor data pipelines for performance and accuracy and
proactively resolve data issues.
Requirements: Bachelor’s degree in Data Science, Engineering, or a related field plus three years of
experience Analytics Engineering. Experience must include three years each of the following: owning
business intelligence tooling end-to-end and leading cross-functional data projects; defining and enforcing
KPI frameworks; working with SQL and data modeling in modern cloud data warehouses such as
BigQuery; Looker (LookML), including semantic modeling, persistent derived tables (PDTs), and
advanced dashboarding; performing data pipeline orchestration using Airflow or similar DAG manager;
Python for data analysis, scripting, and automation, including pandas and NumPy; version control tools
such as Git for deployment workflows; agile methodologies for project management and prioritization;
and managing event tracking though a Customer Data Platform such as Segment. Experience may be
gained concurrently.
Senior Analytics Engineer
Salary: $116,000 - $125,000
2 Wells Ave, Newton, MA 02459
Job Description: Design, develop, and maintain scalable ELT pipelines using Fivetran, Airflow, and
custom integrations. Model raw data into clean, reliable datasets in the cloud data warehouse (BigQuery).
Build and maintain LookML and data pipeline models that transform raw data into usable datasets for
reporting and analysis. Own and improve the semantic layer and data documentation for self-service
tools, creating a single source of truth for metrics and dimensions used across the company. Own the
instrumentation and tracking plan across digital products using Segment. Work closely with product and
engineering teams to ensure data integrity. Collaborate with engineers and business stakeholders to define
clean data definitions and business logic. Partner with stakeholders to understand data needs. Help
translate business questions into scalable data solutions, including presentations, well-designed data
visualizations, and interactive dashboards. Monitor data pipelines for performance and accuracy and
proactively resolve data issues.
Requirements: Bachelor’s degree in Data Science, Engineering, or a related field plus three years of
experience Analytics Engineering. Experience must include three years each of the following: owning
business intelligence tooling end-to-end and leading cross-functional data projects; defining and enforcing
KPI frameworks; working with SQL and data modeling in modern cloud data warehouses such as
BigQuery; Looker (LookML), including semantic modeling, persistent derived tables (PDTs), and
advanced dashboarding; performing data pipeline orchestration using Airflow or similar DAG manager;
Python for data analysis, scripting, and automation, including pandas and NumPy; version control tools
such as Git for deployment workflows; agile methodologies for project management and prioritization;
and managing event tracking though a Customer Data Platform such as Segment. Experience may be
gained concurrently.
Top Skills
Fivetran,Airflow,Bigquery,Looker,Lookml,Sql,Python,Pandas,Numpy,Git,Segment,Elt
Sittercity Newton, Massachusetts, USA Office
2 Wells Ave., Newton, MA, United States, 02459
Similar Jobs at Sittercity
Kids + Family • Software
As a caregiver with Sittercity, you will provide reliable and engaging care to children, supervising activities, preparing meals, and managing bedtime routines according to family instructions.
Top Skills:
Sittercity Platform
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
