Data Engineer: Build Scalable Pipelines & Insights (Remote)

Gemini; New York (NY); Hybrid; USD 104,000 - 145,000; Full time

Benefits offered by this job

Health plans

401K with company matching

Paid Parental Leave

Flexible time off

Discretionary annual bonus

New hire equity grant

Job summary

Gemini is seeking a Data Engineer to design and deliver scalable data pipelines, dimensional models, and robust ETL processes. You will work with analysts and engineers to understand data needs, validate data quality, and implement production-grade solutions.

The role emphasizes collaboration across teams and a strong engineering mindset within a hybrid US-based environment. The team values data-driven decision making, reliable data infrastructure, and clear communication of insights to

Qualifications

• 4+ years experience in data engineering with data warehouse technologies.
• 4+ years experience in custom ETL design, implementation and maintenance.
• 4+ years experience with schema design and dimensional data modeling.
• Advanced skills with Python and SQL are a must.
• Experience with one or more MPP databases (Redshift, BigQuery, Snowflake, etc).
• Experience with one or more ETL tools (Informatica, Pentaho, SSIS, Alooma, etc).
• Strong computer science fundamentals including data structures and algorithms.
• Strong software engineering skills in any server side language, preferably Python.
• Experienced in working collaboratively across different teams and departments.
• Strong technical and business communication

Responsibilities

• Design, automate, build, and launch scalable, efficient and reliable data pipelines into production using Python
• Design, build and enhance dimensional models for Data Warehouse and BI solutions
• Research new tools and technologies to improve existing processes
• Work closely with data analysts to understand data integration and modeling requirements
• Develop new systems and tools to enable the teams to consume and understand data more intuitively
• Perform root cause analysis and resolve production and data issues
• Create test plans, test scripts and perform data validation
• Tune SQL queries, reports and ETL pipelines
• Build and maintain data dictionary and process documentation
• Take ownership and can work autonomously

Skills

Python

SQL

Data warehousing

ETL

Tools

Informatica

Pentaho

SSIS

Alooma

Redshift

BigQuery

Snowflake

Job description

Gemini is seeking a Data Engineer to design and deliver scalable data pipelines, dimensional models, and robust ETL processes. You will work with analysts and engineers to understand data needs, validate data quality, and implement production-grade solutions.

The role emphasizes collaboration across teams and a strong engineering mindset within a hybrid US-based environment. The team values data-driven decision making, reliable data infrastructure, and clear communication of insights to