Senior Analytics Engineer
Senior Analytics Engineer building dimensional models, data marts, and transformation pipelines in dbt, Airflow, and BigQuery to support analytics for banking, product, marketing, finance and other teams. Requires 6+ years experience, strong SQL, dimensional modeling, and BI tool expertise (Looker preferred).
About the job
Responsibilities
- Build data warehousing and data modeling strategy and roadmap.
- Build core data models and data marts in the Data Warehouse.
- Design and build data transformation pipelines, dimensional models, data marts and data aggregation layers in dbt, Airflow and Bigquery.
- Implement scalable and easy to use data models housing complex data sets.
- Support Looker as a primary data reporting and analytics tool and build core data models in Looker to easily do sophisticated data analysis.
- Work closely with Banking, Product, Marketing, Finance, Credit, Risk and other teams to support their analytics and modeling needs in Looker.
- Partner with data engineers to build data integrations, robust tools and infrastructure.
- Implement framework and processes for data reconciliation and quality management.
- Build trust and confidence in the data that you and your team will transform/produce.
Requirements
- 6+ years of experience working as a data engineer or analytics engineer.
- Implemented dimensional models and summarized data marts in the data warehouse; completed at least one full Data Warehouse development cycle.
- Fluent in building data transformation pipelines, dimensional models and data marts using one or more ETL or Transformation tools (Preferred: dbt).
- Proficient in dimensional modeling concepts to power meaningful analytics.
- 3+ years of experience building meaningful metrics, reports and dashboards in BI/reporting tools like (Preferred: Looker).
- Strong expertise in SQL and performance tuning.
- Experience working with services in cloud environment(s) like AWS or GCP.
- Programming experience in Python, Scala or other language(s).
- Focus on data quality, integrity and security.
Nice-to-Haves
- Experience modeling data in dbt and Looker.
- Experience working with Financial services companies.
- Experience working with one or more MPP databases (Preferred: Bigquery, etc).
- Experience in D2C domains.
This role has a base salary range of $170,000.00 - $220,000.00. Compensation is determined based on experience, skill level, and qualifications. Current offers a competitive total rewards package which includes base salary, equity, and comprehensive benefits.
Skills
SQL, dbt, Looker, BigQuery, Airflow, Python, AWS, GCP, Dimensional Modeling, Data Warehousing, ETL, Data Modeling
Similar jobs
Data Analytics jobs
Okta
Bellevue, WALeads marketing analytics strategy by owning attribution, full-funnel measurement, forecasting, dashboards, experimentation, and AI/ML-driven insights. The role requires 8+ years of overall experience, deep B2B SaaS marketing analytics expertise, and advanced proficiency with Tableau, Salesforce, Snowflake, and Excel.
United States
Senior Business Analyst supporting Reddit’s revenue strategy by building BigQuery data pipelines, semantic models, and dashboards for the Large Customer Sales channel. The role requires strong SQL, analytics, cross-functional collaboration, and the ability to translate complex data into measurable business outcomes.
Docker
CanadaStrategic marketing analytics manager-level individual contributor who connects customer, campaign, product usage, and revenue data to improve conversion and pipeline growth. Requires 7+ years of GTM analytics experience, advanced SQL, strong funnel and attribution expertise, and executive communication skills.
Zapier
United States
Leads a hands-on GTM analytics team supporting Marketing, Sales, and Customer Operations through trusted reporting, forecasting, experimentation, and self-service automation. Requires 6+ years of analytics experience, at least 1 year of team management, strong SQL, GTM expertise, and advanced analytical judgment.
Permitflow
New York, NY
Senior Data Analyst partnering with Customer Success and Operations to improve retention, permit turnaround, and organizational scalability. The role requires strong SQL, BI modeling, data warehousing, dbt, and the ability to translate ambiguous business questions into actionable dashboards and metrics.