Senior Analytics Engineer: Data Warehousing & BI Architect

Gemini; United States; Hybrid; USD 126,000 - 180,000; Full time

Benefits offered by this job

Competitive starting pay

A discretionary annual bonus

Long-term equity grant

Comprehensive health plans

401K with company matching

Paid Parental Leave

Flexible time off

Job summary

Gemini is seeking a Senior Analytics Engineer to design scalable data models, build data warehouses, and deliver insightful analytics across the organization. You will partner with product teams and data engineers to translate business requirements into actionable data assets and insights, ensuring quality and maintainability while advancing the modern data ecosystem.

The role emphasizes collaboration, data governance, and automation within a hybrid work model at Gemini's New York hub.

Qualifications

• 5+ years of experience in analytics engineering, data engineering, or similar roles.
• Strong experience designing dimensional data models and schemas for enterprise data warehouses.
• Strong experience designing, building, and maintaining scalable data transformation pipelines.
• Strong experience developing analytics and BI solutions using platforms such as Looker, Tableau, or Power BI.
• Advanced SQL skills are required. Proficiency with Python for data transformation and automation is preferred.
• Experience translating business requirements into scalable dimensional data models and actionable insights.
• Experience with modern data transformation frameworks such as dbt.
• Experienced in working collaboratively across different teams and departments.
• Strong technical and business communication.

Responsibilities

• Design, architect and implement best‑in‑class data warehousing and reporting solutions
• Design, build, and evolve scalable dimensional data models that serve as trusted foundations for Data Warehouse and BI solutions
• Partner with product managers, data engineers, and business stakeholders to translate business requirements into scalable data models and actionable insights
• Perform analysis to derive actionable insights for key stakeholders
• Perform root‑cause analysis and resolve production and data issues
• Develop and maintain automated data quality checks, validation frameworks, and testing to ensure the accuracy and reliability of data assets
• Optimize SQL transformations and data models for performance, scalability, and maintainability
• Build and maintain data dictionary and process documentation
• Research new tools and technologies to improve existing processes

Skills

Advanced SQL

Python for data transformation

Dimensional data models

Data transformation pipelines

Data quality/validation

Communication

dbt

Tools

Looker

Tableau

Power BI

dbt

Job description

Gemini is seeking a Senior Analytics Engineer to design scalable data models, build data warehouses, and deliver insightful analytics across the organization. You will partner with product teams and data engineers to translate business requirements into actionable data assets and insights, ensuring quality and maintainability while advancing the modern data ecosystem.

The role emphasizes collaboration, data governance, and automation within a hybrid work model at Gemini's New York hub.