The Senior Data Engineer will build and deploy data pipelines, develop warehouse architectures, and design analytics solutions for the team.
Company Description
PatternAI is an automated machine learning platform that reveals critical patterns in data for narrow business problems.
Job DescriptionWe are looking for a savvy Data Engineer to join our growing team of data experts. The hire will be responsible for expanding and optimizing our data pipeline architecture, as well as optimizing data flow and collection for cross functional teams.
Responsibilities:
- Build and deploy the data pipelines that power PatternAI’s machine learning platform.
- Develop warehouse architectures that integrate data from diverse sources.
- Design analytics solutions for both product development and internal collaborators.
Experience:
- A minimum of 4 years experience in data engineering, analytics engineering, or software engineering with an emphasis on large scale data management and processing systems.
- Proficiency in Python and advanced SQL.
- Advanced experience with ETL pipelines, data modeling and managing data warehouses (Snowflake, BigQuery, Redshift, etc).
- Experience with SQL RDBMS such as MySQL, Postgres, Oracle, SQL Server, etc., as well as NoSQL systems such as MongoDB is required.
- Experience with tools including Meltano, dbt, Airflow, and Superset is required.
- Experience with Docker, Git and AWS (EC2, ECS, S3, Step Functions, and Athena).
- Analytics and Business Intelligence knowledge is highly preferred.
- Experience working with common SaaS APIs (such as CRMs) is preferred.
About PatternAI
PatternAI is an early stage startup that is growing rapidly and recently closed a successful round of venture funding. We are emerging from stealth and with an exciting series of machine learning products and a rapidly growing number of enterprise customers.
All your information will be kept confidential according to EEO guidelines.
PatternAI, Inc. San Mateo, California, USA Office
400 Concar Dr, San Mateo, California , United States, 94402
Similar Jobs
Big Data • Cloud • Productivity • Software • Database • Analytics • Automation
Build and maintain Databricks-based data platforms, including ingestion, transformation, storage, governance, data modeling, and serving pipelines. Establish medallion architecture standards, canonical data models, quality controls, lineage, schema evolution, and reliable batch or incremental processing. Improve pipeline observability, scalability, idempotency, and recoverability while moving curated data to systems such as ClickHouse. Collaborate across application and analytics teams to create durable, governed production datasets.
Top Skills:
Amazon AuroraAmazon RdsApache AirflowSparkBigQueryCdcClickhouseCloud Object StorageDatabricksDelta LakeIamOpenmetadataPostgresSnowflakeUnity Catalog
AdTech • Consumer Web • Digital Media • eCommerce • Marketing Tech • SEO
Build and support scalable data platforms and pipelines, leading migrations such as Snowflake to BigQuery and transitioning reporting to Looker. Responsibilities include data architecture, ETL/ELT, API and marketing integrations, data quality, production troubleshooting, warehousing, performance optimization, and platform modernization. The role partners with analytics and business teams, owns projects through production, documents solutions, and provides technical guidance.
Top Skills:
AWSAzureBigQueryConfluenceDraw.IoGCPGitJIRAKafkaLookerLucidchartMiroModeNotionPower BIPythonSnowflakeSparkSQLTableauTalend
Information Technology • Productivity • Software • Infrastructure as a Service (IaaS)
Design and scale lakehouse architecture, streaming and batch pipelines, and reliable data platforms using Kafka, Spark, Airflow, Iceberg, Databricks, and related technologies. Build Medallion-layer data systems, manage open table formats, optimize distributed queries, monitor platform reliability, resolve data quality issues, and collaborate with analysts, data scientists, and product teams.
Top Skills:
Apache AirflowApache HudiApache IcebergApache KafkaSparkDatabricksDelta LakePythonSQLStarburstTrino
What you need to know about the San Francisco Tech Scene
San Francisco and the surrounding Bay Area attracts more startup funding than any other region in the world. Home to Stanford University and UC Berkeley, leading VC firms and several of the world’s most valuable companies, the Bay Area is the place to go for anyone looking to make it big in the tech industry. That said, San Francisco has a lot to offer beyond technology thanks to a thriving art and music scene, excellent food and a short drive to several of the country’s most beautiful recreational areas.
Key Facts About San Francisco Tech
- Number of Tech Workers: 365,500; 13.9% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Google, Apple, Salesforce, Meta
- Key Industries: Artificial intelligence, cloud computing, fintech, consumer technology, software
- Funding Landscape: $50.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Sequoia Capital, Andreessen Horowitz, Bessemer Venture Partners, Greylock Partners, Khosla Ventures, Kleiner Perkins
- Research Centers and Universities: Stanford University; University of California, Berkeley; University of San Francisco; Santa Clara University; Ames Research Center; Center for AI Safety; California Institute for Regenerative Medicine
