CompassX Group
Senior Data Engineer - Python and Snowflake (1099 contract, Remote, must be based in US)
Design and build ETL/ELT data pipelines using Python and Snowflake, manage data workflows, and support analytics through Power BI dashboards.
About Us:
At CompassX, our clients rely on us to lead high-priority strategic initiatives and transformational projects. Our mission is to create a community of people who come up with innovative approaches and deliver the best outcomes for our clients.
You will have the opportunity to leverage your experience, creativity, and skills to impact your clients and influence the trajectory of our firm to achieve growth for the team and your career.
We are honored to be recognized as a “Best Place to Work” in Southern California and listed as one of INC.’s 5000 fastest-growing private companies in the U.S.
We’re looking for a Senior Data Engineer (Python and Snowflake) to support one of our life sciences clients. This role will focus on designing and building scalable data pipelines, integrating data into Snowflake, and enabling downstream analytics and reporting in Power BI.
The client environment is still maturing, so your ability to shape structure, define logic, and deliver value will be key.
What you'll do
- Design, build, and maintain ETL/ELT pipelines using Python, integrating data from APIs, flat files, and relational systems into Snowflake
- Develop and optimize data models and transformations (dbt) to support reporting and analytical use cases
- Implement data validation, testing, and quality checks to ensure accuracy and reliability across datasets
- Manage data workflows, orchestration, and automation using modern tools and practices (e.g., Airflow, GitHub Actions)
- Support downstream users and analysts by preparing clean, well-structured datasets for Power BI dashboards and reports
- Contribute to the development and management of containerized environments using Docker and Linux
- Collaborate with BI developers, analysts, and business stakeholders to deliver end-to-end data solutions
- Help define and promote data engineering best practices, frameworks, and standards within a growing data environment
What we're looking for
- 7–10 years of data engineering experience across the full data lifecycle
- Strong programming experience in Python, including data libraries such as Pandas, PySpark, or SQLAlchemy
- Advanced SQL skills and hands-on experience developing transformations using dbt
- Experience with Snowflake or similar cloud data platforms (e.g., Redshift, BigQuery)
- Working knowledge of Linux, Docker, and GitHub Actions for environment management and CI/CD automation
- Understanding of data architecture concepts, including modeling, lineage, and orchestration
- Exposure to Power BI and experience supporting analytics or BI teams
- Comfortable working in a fast-paced and collaborative environment
Top Skills
Airflow
Dbt
Docker
Elt
ETL
Github Actions
Linux
Pandas
Power BI
Pyspark
Python
Snowflake
SQL
Sqlalchemy
Similar Jobs
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
In this role, you will champion Samsara's principles, hire and lead an inclusive team, and improve customer success as the company scales globally.
Healthtech • Software
The role involves managing key accounts, ensuring high user adoption, conducting business reviews, and fostering strong relationships for renewals.
Top Skills:
SQL
Fintech • HR Tech
The Software Engineer will enhance developer productivity by managing CI systems, improving build pipelines, and collaborating with teams to boost efficiency and reliability.
Top Skills:
BuildkiteCi SystemsCodeDeveloper Tooling
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
