Senior Data Engineer

Summary

Join Gemini's data engineering team as a Senior Data Engineer and contribute to the design, implementation, and maintenance of high-quality data warehousing and reporting solutions. You will lead design discussions, mentor junior engineers, and build scalable data pipelines using Python. Responsibilities include developing real-time data solutions, enhancing dimensional models, researching new technologies, and collaborating with cross-functional teams. The role requires strong technical and communication skills, along with experience in data warehousing, ETL processes, and MPP databases. This position is hybrid, requiring in-person presence twice a week in either Seattle, WA or New York City, NY.

Requirements

• 5+ years experience in data engineering with data warehouse technologies
• 5+ years experience in custom ETL design, implementation and maintenance
• 5+ years experience with schema design and dimensional data modeling
• Experience building real-time data solutions and processes
• 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, preferable Python
• 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
• Lead and participate in design discussions and meetings
• Mentor data engineers and analysts
• Design, automate, build, and launch scalable, efficient and reliable data pipelines into production using Python
• Build real-time data and reporting solutions
• Design, build and enhance dimensional models for Data Warehouse and BI solutions
• Research new tools and technologies to improve existing processes
• Develop new systems and tools to enable the teams to consume and understand data more intuitively
• Partner with engineers, project managers, and analysts to deliver insights to the business
• 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

Preferred Qualifications

• Kafka, HDFS, Hive, Cloud computing, machine learning, text analysis, NLP & Web development experience is a plus
• Experience with Continuous integration and deployment
• Knowledge and experience of financial markets, banking or exchanges
• Web development skills with HTML, CSS, or JavaScript

Benefits

• Competitive starting salary
• A discretionary annual bonus
• Long-term incentive in the form of a new hire equity grant
• Comprehensive health plans
• 401K with company matching
• Paid Parental Leave
• Flexible time off