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.
CompassX is a boutique business and technology consulting firm. We help Fortune 500 and high-growth clients deliver their most strategic initiatives, from enterprise transformations to digital and data-driven projects. With over 15 years of proven results, we’ve expanded across industries including financial services, pharmaceuticals, aerospace, consumer products, and quick service restaurants.
We are honored to be recognized as a three-time winner of Consulting Magazine’s Best Boutique Firms to Work For, and previously recognized as a “Best Place to Work” in Southern California and 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 scalable, maintainable data pipelines for ingestion and transformation using Python
- Implement, manage, and monitor data workflows using Dagster (preferred) or similar orchestration tools like Airflow or Prefect, focusing on asset-driven, modular pipelines
- Apply software engineering best practices (testing, code review, CI/CD) to ensure pipeline reliability and data quality
- Develop and optimize data models and transformations to support analytics and BI outputs
- Collaborate with BI developers, analysts, and business stakeholders to deliver end-to-end data solutions
- Contribute to standards, frameworks, and reusable components to improve efficiency and maintainability across pipelines
- Support downstream users by preparing clean, well-structured datasets for analytics and reporting (Power BI)
What we're looking for
- 7–10 years of experience in data engineering or data pipeline development
- Advanced proficiency in Python, including data libraries such as Pandas, PySpark, or SQLAlchemy
- Experience with Dagster preferred, but candidates with orchestration experience in Airflow, or similar are also considered
- Hands-on experience with Snowflake preferred; experience with other cloud data warehouses (BigQuery, Redshift) is acceptable
- Strong SQL skills and familiarity with data modeling and transformations
- Experience with Git and CI/CD processes for deploying pipelines
- Self-driven, capable of owning solutions end-to-end and establishing standardized processes
- Comfortable working in a fast-paced, collaborative, global environment
Our consultants say CompassX is a place where they can truly find their own path. As part of a smaller firm, they see the impact of their work, have an identity, and know their voice matters. They value the freedom to take the reins of their careers, shape their client work, and maintain a direct line to leadership.
With CompassX’s focus on serving local Southern California clients, consultants not only build lasting relationships but also see the results of their work in the communities where they live.
At CompassX, you won’t just follow a path - you’ll create one.
Top Skills
Airflow
Dbt
Docker
Elt
ETL
Github Actions
Linux
Pandas
Power BI
Pyspark
Python
Snowflake
SQL
Sqlalchemy
Similar Jobs
Artificial Intelligence • Machine Learning • Software • Defense
Lead the growth of the Perception Management platform by designing, building, and integrating defense tech applications, mentoring engineers, and setting the technical direction.
Top Skills:
ElasticsearchNode.jsPostgresReactRedisS3TailwindTypescript
Artificial Intelligence • Big Data • Cloud • Information Technology • Machine Learning • Software
The Sales Engineer supports sales by providing presales support, demonstrating Nexthink solutions, and driving the business value through collaboration with multiple stakeholders, focusing on enterprise accounts.
Top Skills:
Cloud-Based SolutionsDigital Experience MonitoringIt OperationsIt SecurityIt Service ManagementItil FrameworkO365SaaSWin10
eCommerce • Mobile • Payments
Drive strategic client partnerships and deliver business results. Lead sales initiatives, manage executive relationships, and mentor teams while meeting revenue targets.
Top Skills:
Google SuiteLookerSalesforce
What you need to know about the Charlotte Tech Scene
Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus
