Acquisition.com is looking to architect, implement, and optimize data models, pipelines, and storage solutions across its data ecosystem to ensure reliability, performance, and accessibility of data, serving as a bridge between raw information and actionable business intelligence.
Requirements
- 5+ years of experience building and scaling modern data infrastructure.
- Proven ability to design and maintain ETL/ELT workflows with tools like Fivetran and dbt, and to operate within distributed data systems.
- Expertise in SQL and proficiency in at least one general-purpose language, with strong preference for TypeScript; Python or Scala is also valuable.
- Strong knowledge of Snowflake, data modeling, dbt development, and cloud-based architectures.
- Experience with AWS, infrastructure-as-code, CI/CD, and monitoring/alerting systems.
- Familiarity with agent-driven development tools such as Cursor and Claude Code.
- Experience supporting analytics and reporting environments, ideally using Metabase.
Responsibilities
- Design, implement, and maintain robust data pipelines using modern ETL/ELT frameworks, including Fivetran for extraction and dbt for transformation and orchestration.
- Develop and optimize Snowflake data warehouse models to support analytics, automation, and reporting.
- Implement automated quality checks, observability, and monitoring to ensure data integrity, lineage visibility, and reliability.
- Build abstractions, libraries, and frameworks—primarily using TypeScript and SQL—for scalable ingestion and transformation of structured and unstructured data.
- Collaborate with analytics, engineering, and leadership to deliver consistent, actionable insights through tools such as Metabase.
- Leverage cloud-native infrastructure (AWS) and infrastructure-as-code to support data storage, compute, and deployment workflows.
- Continuously refine data architecture to meet evolving performance, scalability, governance, and compliance needs.
Other
- Work hours aligned with local time zone or Pacific time zone 8a-5p M-F
- Flexible to travel to Vegas roughly 4-6 times per year
- Must be flexible and able to work additional hours/weekends before workshop events/holidays if the situation warrants it
- Remote, USA
- Must reside in AL, AZ, CA, FL, GA, IN, MD, MI, MN, NV, OR, PA, TN, TX, UT
