Alpaca

Developer APIs for stocks and crypto trading, investing apps, and embedded fintech.

Senior Analytics Engineer

Analytics EngineerAnalytics EngineerFull TimeRemoteTeam 201-500H1B No SponsorCompany SiteLinkedIn

Location

United States

Posted

85 days ago

Salary

Not specified

Bachelor Degree4 yrs expEnglishAWSCloudETLGoogle Cloud PlatformPostgresPythonSQL

Job Description

• Own the Transformation Layer: Design, build, and maintain scalable data models using dbt and SQL to support diverse business needs, from monthly financial reporting to near-real-time operational metrics. • Set Technical Standards: Establish and enforce best practices for data modelling, development, testing, and monitoring to ensure data quality, integrity (up to cent-level precision), and discoverability. • Enable Stakeholders: Collaborate directly with finance, operations, customer success, and marketing teams to understand their requirements and deliver reliable data products. • Integrate and Deliver: Create repeatable patterns for integrating our data models with BI tools and reverse ETL processes, enabling consistent metric reporting across the business. • Ensure Quality: Champion high standards for development, including robust change management, source control, code reviews, and data monitoring as our products and data evolve.

Job Requirements

  • 4+ years of experience in analytics engineering or data engineering with a strong focus on the "T" (transformation) in ELT.
  • Proven track record of owning data products end-to-end, applying analytics and data engineering best practices to ensure data quality, scalability, and robust data models.
  • Comfortable working with ambiguity and collaborating with stakeholders to define requirements; able to take ownership with minimal oversight in a fast-paced environment.
  • Experience proactively identifying and implementing improvements to data warehouse performance and ETL efficiency.
  • Technical Versatility:
  • Expert-level SQL and DBT skills for complex queries and data transformations.
  • Proficiency in Python for transformations that extend beyond SQL.
  • Hands-on experience with query optimization across OLTP and OLAP systems (e.g., Postgres, Iceberg).
  • Proficiency with Semantic Layer modelling (e.g. Cube, dbt Semantic Layer).
  • Experience owning CI/CD workflows and establishing team-wide standards for version control and code review (e.g., Git).
  • Familiarity with cloud environments (GCP or AWS).

Benefits

  • Competitive Salary & Stock Options
  • Health Benefits
  • New Hire Home-Office Setup: One-time USD $500
  • Monthly Stipend: USD $150 per month via a Brex Card

Related Categories

Related Job Pages

More Analytics Engineer Jobs

Analytics Manager II

BlueLabs

BlueLabs is an analytics and technology solutioning firm. We solve your toughest challenges with data-driven insights.

Analytics Engineer85 days ago
Full TimeRemoteTeam 51-200Since 2013H1B No Sponsor

As part of the Insights at BlueLabs, you’ll be working with a group of analysts and data scientists who work across BlueLabs’ client sectors, including commercial, political, and non-profit clients, to inform data-driven decisions and strategy. This position requires a mix of...

SQLPythonExcelGoogle SheetsPowerPointKeynoteQGISArcGISstatistical analysisdata visualizationbusiness intelligence toolsbig data analysisGIS
United States
$95K / year

Analytics Engineer

Branch

We provide cross-platform linking and attribution solutions to the world's leading digital brands.

Analytics Engineer86 days ago
Full TimeRemoteTeam 501-1,000Since 2014H1B Sponsor

Analytics Engineer supporting Branch’s Finance and Accounting operations.

Ruby on RailsSQL
United States
$145K - $160K / year

Lead Data & Analytics Engineer

Kandu

Leading the way in stroke recovery.

Analytics Engineer86 days ago
Full TimeRemoteTeam 51-200H1B No Sponsor

Lead Data & Analytics Engineer building data infrastructure at Kandu Inc.

AirflowAmazon RedshiftBigQueryPythonSQLTableau
United States
$150K - $175K / year
Analytics Engineer86 days ago
Full TimeRemoteTeam 5,001-10,000

The Sr. Manager, Measurement is a strategic leader responsible for developing and governing the enterprise measurement framework across digital and omnichannel initiatives. This role ensures that senior leaders have access to actionable insights connecting customer, distributor, ...

SQLPythonRAdobe AnalyticsPower BISnowflakeDatabricksDAXData EngineeringData VisualizationMeasurement FrameworkAttribution ModelingConversion TrackingData GovernanceDigital Analytics
United States